SQLConfiguration SQLConfiguration


Monitoring SQL  «Prev 

sp_monitor output

View the image below.
SP Monitor

  1. last_run – last_run is the last time that sp_monitor was run.
  2. Current_run – current_run is the current date/time.
  3. Seconds – Seconds is the number of seconds between the last run and the current time.
  4. Cpu_busy – Cpu_busy is the number of seconds that the cpu was busy processing SQL Server requests.
  5. Io_busy – io_busy is the number of seconds that SQL Server was doing input or output.
  6. Idle – idle is the number of seconds that SQL Server was not doing anything.
  7. Packets_received – Packets_received is the number of network packets received by SQL Server.
  8. Packets_sent – Packets_sent is the number of network packets sent by SQL Server.
  9. Packets_errors – Packets_errors are the number of network errors.
  10. Total_read – Total_read is the total number of disk reads performed by SQL Server.
  11. Total_write – Total_write is the total number of disk writes performed by SQL Server.
  12. Total_errors – Total_errors is the total number of disk errors that occurred for I/O initiated by SQL Server.
  13. Connections – Connections is the total number of connection attempts that were made to SQL Server.