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.