June 6, 2012 at 9:37 am
hi,
By executing the below query, can see that the "BufferPoolMB" usage of each database.
select db_name(database_id) as dbName, count(*)*8/1024 as BufferPoolMB
from sys.dm_os_buffer_descriptors group by db_name(database_id)
order by 2 desc
There is a database which has a high percentage of empty space being stored in buffer pool memory. This database is storing ~18% of its total buffer pool memory as empty space. This memory is being wasted and servers no purpose. Low data density pages can cause performance problems and can be caused by wide data rows, page splits, etc.
As further steps, what are the tasks can be performed to recommend ?
Thanks.
June 6, 2012 at 11:34 pm
Sourav-657741 (6/6/2012)
...There is a database which has a high percentage of empty space being stored in buffer pool memory. This database is storing ~18% of its total buffer pool memory as empty space.
...
What do you mean by "empty space being stored in buffer pool memory"?
How did you find it? Could you post the query that you used to find it?
June 7, 2012 at 2:18 am
The query you've given doesn't give any detail on the 'empty space' you mention.
How are you determining that the pages in the buffer are empty?
The query given simply gives an aggregated storage cost of the current pages in the buffer pool.
---
Note to developers:Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply