Home Forums Article Discussions Article Discussions by Author Discuss content posted by Patrick Akhamie what tables and indexes are using the most memory in the buffer cache RE: what tables and indexes are using the most memory in the buffer cache

  • October 28, 2015 at 8:19 am

    #1836062

    Iwas Bornready (10/28/2015)

    SQLQuest29 (5/27/2014)

    Contrary to the title, the query does not show the indexes.

    Below is an enhanced version (courtesy of Aaron Bertrand)

    Thanks for the enhancement.

    Thank you Aaron for a script that gives us the index name, uses a CTE, and determines buffer space using values in a column instead of the number of rows in the result.

    😎