ShowMemoryUtilization
Shows the operating system level memory utilization used by the database engine.
Metrics reported:
- WorkingSet64
- MinWorkingSet
- MaxWorkingSet
- PeakWorkingSet64
- PagedMemorySize64
- NonpagedSystemMemorySize64
- PeakVirtualMemorySize64
- VirtualMemorySize64
- PrivateMemorySize64
- TotalCacheSize
Exec ShowMemoryUtilizationSQL :: ShowHealthCounters
Shows the health counters that are tracked by the engine.
SQL :: ShowLocks
Shows all locks for all transactions.
SQL :: ShowProcesses
Shows all active processes, their session ID, process ID and various transaction information.
SQL :: ShowTransactions
Shows all transactions that are current active.
SQL :: ShowVersion
Shows the names and versions of all loaded assemblies.
SQL :: ShowWaitingLocks
Shows processes that are currently waiting on locks.
SQL::Keywords
A breakdown of all high-level statements available via the query handler.
SQL::ShowAggregateFunctions
Displays the list of built-in aggregation functions and their parameters.
SQL::ShowCachePages
Displays information about cached database pages.
SQL::ShowScalarFunctions
Displays the list of built-in scaler functions and their parameters.