Purpose: Shows memory allocation for server structures and objects, for example the size and number of stored procedures.
Usage:
dbcc memusage
WARNING! Running dbcc memusage on a multi-engine server can cause the other running processes to timeslice.
