Statements (18)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
system stored procedure
|
| gptkbp:canBe |
any user with EXECUTE permission
|
| gptkbp:category |
system monitoring
|
| gptkbp:documentation |
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-monitor-transact-sql
|
| gptkbp:format |
gptkb:text
|
| gptkbp:hasSyntax |
EXEC sp_monitor;
|
| https://www.w3.org/2000/01/rdf-schema#label |
sp monitor system procedure
|
| gptkbp:introducedIn |
gptkb:SQL_Server_2000
|
| gptkbp:permits |
public
|
| gptkbp:purpose |
returns SQL Server statistics
|
| gptkbp:result |
CPU usage statistics
I/O statistics cache hit ratio connections statistics packets statistics |
| gptkbp:usedIn |
gptkb:Microsoft_SQL_Server
|
| gptkbp:bfsParent |
gptkb:Sybase_SQL_dialect
|
| gptkbp:bfsLayer |
7
|