Showing posts with label mem. Show all posts
Showing posts with label mem. Show all posts

Monday, March 26, 2012

Lock memory is high

The lock memory is around 600 MB. Are the lock info stored in Buffer pool or
mem to leave area ? Im just trying to figure where that 600 MB is coming
fromThe MemToLeave area is only a max of 384MB by default. But Lock resources
normally come out of the portion of the memory pool that live in the 2GB or
3GB (depending on /3GB) of physical memory. If your lock memory is high
then you should look at optimizing your tsql and or your indexes.
--
Andrew J. Kelly SQL MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O33vh8cWFHA.628@.tk2msftngp13.phx.gbl...
> The lock memory is around 600 MB. Are the lock info stored in Buffer pool
> or
> mem to leave area ? Im just trying to figure where that 600 MB is coming
> from
>
>