dbcc memusage | monitor memory buffers |
dbcc proccache | monitor the procedure cache |
dbcc buffer | monitor data cache |
dbcc perform | monitor overall system performance |
dbcc output buffer | monitor data sent back to clients |
dbcc input buffer | monitor data sent from clients |
Command category | Perform |
---|---|
Maintenance | Maintenance tasks on a database, index, or filegroup. |
Miscellaneous | Miscellaneous tasks such as enabling trace flags or removing a DLL from memory. |
Informational | Tasks that gather and display various types of information. |
Validation | Validation operations on a database, table, index, catalog, filegroup, or allocation of database pages. |