November 28, 2012 at 3:21 am
Hi folks,
Need your help. I have 2008 R2 Express Edition. Max Mem is 500MB.
select count(*) * 8/(1024) from sys.dm_os_buffer_descriptors
select cntr_value * 8/( 1024) from sys.dm_os_performance_counters where counter_name like '%data%page%'
Above two queries give the size of BPool as 1372 MB. How it could be more then maxmem setting. Also express edition has 1GB memory limit?
Thanks
November 28, 2012 at 5:37 am
Unless I'm misreading this, the buffer pool doesn't come from SQL Server's allocated memory.
BOL says
When SQL Server starts, it computes the size of virtual address space for the buffer cache based on a number of parameters such as the amount of physical memory on the system, the configured number of maximum server threads, and various startup parameters. SQL Server reserves this computed amount of its process virtual address space (called the memory target) for the buffer cache, but it acquires (commits) only the required amount of physical memory for the current load.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply