Archive for the ‘Uncategorized’ Category

Procedure Cache – Memory Pressure

December 13, 2012 3 comments

_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

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…