Procedure Cache – Memory Pressure


_MG_2719Hi everyone,

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…

Categories: Memory, Uncategorized

Inside the SQL Server Query Optimizer

September 30, 2011 Leave a comment

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.

Now it is available on Amazon and some other book-stores. You also can find more detail description chapter y chapter using this link. Read more…

NetScaler DataStream as a database server load balancer

August 26, 2011 1 comment

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…

Categories: News Tags: ,

Microsoft® SQL Server® 2008 R2 Service Pack 1


Hi everyone!

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…

Using fn_dblog


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.

SELECT *
FROM ::fn_dblog(NULL, NULL)
WHERE operation = ‘LOP_DELETE_SPLIT’

Read more…

Categories: News, SQL Server 2005 Tags: , ,

Key improvements in Microsoft SQL Server 2008 R2 Service Pack 1


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…

Categories: News Tags:

Summary of the Amazon EC2 and Amazon RDS Service Disruption in the US East Region


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…

Categories: News Tags:
Follow

Get every new post delivered to your Inbox.

Join 84 other followers