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
>
>

No comments:

Post a Comment