Archive

Archive for the ‘Memory’ 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…

Advertisements
Categories: Memory, Uncategorized

Do I have to assign the Lock Pages in Memory privilege for Local System?


This article has been written in the beginning of 2007 but, anyway, I face quite often with memory related issues dealing with costumers who are using Standard Edition of SQL Server. From my point of view it is worth to read this article through and systematize your knowledge about Locked Pages in SQL Server Standard Edition. Read more…