• Eitan Blumin

Buffer Pool Distribution by Tables

Sometimes we need to troubleshoot memory pressure issues. One of the things that can help in these cases is to view the contents of the buffer pool.

This script displays the contents of the buffer pool in terms of tables. For each table, it presents the total table space and the space consumed by the table in the buffer pool.


#troubleshooting #bufferpool #memory

CONTACT US

 3 Rapaport St. Kfar Saba, Israel

JOIN OUR MAILING LIST

 +972-9-7400101

  • Google+ - White Circle
  • Facebook - White Circle
  • Twitter - White Circle
  • LinkedIn - White Circle