sp_monitor output
View the image below.
SP Monitor
- last_run – last_run is the last time that sp_monitor was run.
- Current_run – current_run is the current date/time.
- Seconds – Seconds is the number of seconds between the last run and the current time.
- Cpu_busy – Cpu_busy is the number of seconds that the cpu was busy processing SQL Server requests.
- Io_busy – io_busy is the number of seconds that SQL Server was doing input or output.
- Idle – idle is the number of seconds that SQL Server was not doing anything.
- Packets_received – Packets_received is the number of network packets received by SQL Server.
- Packets_sent – Packets_sent is the number of network packets sent by SQL Server.
- Packets_errors – Packets_errors are the number of network errors.
- Total_read – Total_read is the total number of disk reads performed by SQL Server.
- Total_write – Total_write is the total number of disk writes performed by SQL Server.
- Total_errors – Total_errors is the total number of disk errors that occurred for I/O initiated by SQL Server.
- Connections – Connections is the total number of connection attempts that were made to SQL Server.