Skip to content
Home ยป SQL SERVER SP_MONITOR

SQL SERVER SP_MONITOR

SP_MONITOR is a SQL Server Database Engine system stored procedure which is used to Display statistics about Microsoft SQL Server.





SYNTAX

EXEC sp_monitor

It returns two code values either o or 1

0 means success

1 means failure

Following statement uses sp_monitor system stored procedure to display the statistics.

EXEC sp_monitor

Here result set showing CPU busy – 177717(240)-35%, it means the CPU has been busy 177717 seconds since SQL Server was last started up and 240 seconds since sp_monitor was last run and 35 percent of the total time since sp_monitor was last run.




Following is the complete description for sp_monitor stored procedure output.

last_run Timeย sp_monitorย was last run.
current_run Timeย sp_monitorย is being run.
seconds Number of elapsed seconds sinceย sp_monitorย was run.
cpu_busy Number of seconds that the server computer’s CPU has been doing SQL Server work.
io_busy Number of seconds that SQL Server has spent doing input and output operations.
idle Number of seconds that SQL Server has been idle.
packets_received Number of input packets read by SQL Server.
packets_sent Number of output packets written by SQL Server.
packet_errors Number of errors encountered by SQL Server while reading and writing packets.
total_read Number of reads by SQL Server.
total_write Number of writes by SQL Server.
total_errors Number of errors encountered by SQL Server while reading and writing.
connections Number of logins or attempted logins to SQL Server.

 

Also Read..

SQL Server sp_executesql

SQL Server Startup procedures Sp_Procoption

SQL Server Sp_helptext




 

 1,846 total views,  1 views today

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.