ShowCachePages



Much like ShowCacheAllocations, but ShowCachePages only displays information about cached database pages. Notably, this procedure also shows the count of documents in each page.


Exec ShowCachePages




SQL::ShowSystemFunctions
Displays the list of built-in system functions and their parameters.
SQL::System Procedures
Built in procedures that allow you to evaluate various aspect of the database engine.