ShowCacheAllocations
Overview
Shows the cache allocation details. This system procedure will show each file in the cache, how long its been there, how many times its been read/written and how large it is.
Example
Exec ShowCacheAllocations
See also
Related
- ShowCachePages - Displays information about cached database pages.