I try to find out what objects use buffer cache. As example, in Oracle there is fixed table x$bh. This table gives us infomation about buffer cache on per block basis. Is there similar view or table in SQL Server 2005? How can I find out what table uses
most of buffer cache?
View Complete Post