Post reply

Content of Buffer Cash

  • September 25, 2010 at 3:22 am

    #229746

    Dear All ,

    in order to know the objects that consuming from buffer cash any one knows how can we get detail of The content of Buffer Cash like :

    1- TableName,

    2- Index Name,

    3- Cashed By MB

    Thanks in Advance

  • September 25, 2010 at 5:55 pm

    #1227417

    I do not have my lab up right now so I cannot test this, but I got this from a 2005 troubleshooting article on TechNet:

    Note that the previous query treats Buffer Pool differently as it provides memory to other components via a single-page allocator. To determine the top ten consumers of the buffer pool pages (via a single-page allocator) you can use the following query.

    -- top 10 consumers of memory from BPool

    select

    top 10 type,

    sum(single_pages_kb) as [SPA Mem, Kb]

    from

    sys.dm_os_memory_clerks

    group by type

    order by sum(single_pages_kb) desc

    Troubleshooting Performance Problems in SQL Server 2005

    Joie Andrew
    "Since 1982"

  • September 26, 2010 at 6:44 am

    #1227451

    Thanks for Replay , but I need to know the detail of objects Cashed into Buffer ,the Query which you Post retriving data by type .

    I need to Know :TableName, Index Name, Cashed by MB

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply