STAY IN TOUCH

Get New posts delivered straight to your inbox

  • Madeira Team

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

JOIN OUR MAILING LIST

CONTACT US

4 Itzhak Ben Zvi, Hod-Ha'sharon,

Israel 4537302

 +972-9-7400101

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