Post reply

buffer_memory_mgt

  • April 22, 2014 at 10:50 pm

    #292646

    Comments posted to this topic are about the item buffer_memory_mgt

  • May 14, 2014 at 6:01 am

    #1713419

    Did you know that if you comment out USE dbname, your results include buffer information at each of the database levels on your server. THen you also get specific object results at the database in which you are running the query(connected to).

    So, not sure what the need is to change the dbname, it gives no results if you are connected to master then change the use dbname to another app database.

    examble, gave no results when I used

    USE <UDS>; -- change this to the database you want to find the largest buffer objects

    GO

  • May 14, 2014 at 7:59 am

    #1713473

    Patrick,

    Thanks for taking the time and effort to make this script available to us. I find it very useful.

    However, the first section will not work in SQL 2012. The "total pages" counter for the Buffer Manager object no longer exists in sys.dm_os_performance_counters.

    Thanks again.

    Lee

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

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