Recently I was dealing with unusual behavior of Procedure Cache caused pseudo-random execution plans to be removed from memory (SQL Server 2005, 2008, 2008R2). As a result, under a large workload there was observed locks contention related to schema locks required in order to compile and insert a procedure into Procedure Cache. This is a predictable behavior of heavy loaded systems. But, the main question here is – how can we identify this type of issues related to so called Memory Pressure in Procedure Cache? Read more…
A new book about SQL Server query optimizer has been published recently by Red gate.
I have not had enough time yet to cover an entire book but selected chapters were really impressive. I would say the book contains much more useful explanations and examples I could expect and focused to an audience which want to go dipper. If you are SQL Server professional and keen dealing with query optimizer the book is definitely for you.
I would like to tell thank you to Benjamin Nevarez which wonderful work as the main author is amazing.
NetScaler DataStream represents a technology which can help IT professionals in enterprise database area enhance scalability and fail-over capability their production databases even further than we have thought.
I want to describe the main features of the package in order to provide readers some more confidence with using such solutions: Read more…
Eventually SQL Server 2008 R2 Service Pack 1(SP1) has been released and now it is accessible for downloading. SQL Server 2008 R2 service pack updates all services of SQL Server 2008 R2 until SP1. Service pack includes all cumulative updates starting from 1 up to 6. You can use it easily to update the further list of SQL Server editions:
(1) SQL Server 2008 R2 Datacenter Edition
(2) SQL Server 2008 R2 Enterprise Edition and Developer Edition
(3) SQL Server 2008 R2 Standard Edition
(4) SQL Server 2008 R2 Web Edition
(5) SQL Server 2008 R2 Workgroup Edition
(6) SQL Server 2008 R2 Express Edition
Important: in order to update SQL Server 2008 R2 Express Edition, you should use SP1 for Express Edition or Express Edition with Advanced Services. Read more…
I like the fn_dblog function even if it is undocumented. It enables you to read from you transaction log which contains very valuable information about stuff that is happening in your database. It is for example the only way I now at this time to determin which object experienced a page split if you search for the LOP_DELETE_SPLIT operation.
FROM ::fn_dblog(NULL, NULL)
WHERE operation = ‘LOP_DELETE_SPLIT’
The Microsoft SQL Server Sustained Engineering team is pleased to announce the availability of SQL Server 2008 R2 Service Pack 1 CTP. Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. Service Pack 1 for SQL Server 2008 R2 includes product improvements based on requests from the SQL Server community, and hotfix solutions provided in SQL Server 2008 R2 RTM Cumulative Update 1 to 6.
Key improvements in Microsoft SQL Server 2008 R2 Service Pack 1 are: Read more…
Now that we have fully restored functionality to all affected services, we would like to share more details with our customers about the events that occurred with the Amazon Elastic Compute Cloud (“EC2”) last week, our efforts to restore the services, and what we are doing to prevent this sort of issue from happening again. We are very aware that many of our customers were significantly impacted by this event, and as with any significant service issue, our intention is to share the details of what happened and how we will improve the service for our customers. Read more…