Return
-
Title
Unable to find contents of Buffer Cache in v11.5 -
Description
Since installing v11.5, it's no longer possible to find the contents of the Buffer Cache. This option was good to identify bad indexing, as it showed tables/indexes that were consuming large amounts of buffer pool space.
This used to exist in previous versions of Spotlight.
-
Cause
This has been deprecated in 11.5. Please see the Release Notes for more details. -
Resolution
There is no alternative drilldown that can show buffer cache table in 11.5 any longer.
Also the SQL memory report will not contain this kind of information, as it just has a summary.
If you need to see the buffer cache content, please try the SQL script attached, which shows the top 20 buffer cache objects.
-
Defect ID
SOSSE-5604 -
Attachments
-
Additional Information
This options was removed it because the data from it was enormously expensive to collect and didn’t provide any information that wasn’t obtainable from elsewhere much more cheaply. The cost of collecting the data goes up exponentially compared to the buffer cache size, so now that buffer caches are becoming enormous, it’s quite possible to cripple a SQL Server by collecting this sort of data.