Data World

SQL Server- Get SQL server Statistics using SP_Monitor

Posted by Pramod Singla on May 31, 2011

Sp_Monitor : It is a useful system function used to see the statistics of the SQL Server.

Following image shows the result sets returned when sp_monitor is executed:


The packet size is defined at the server level. See server properties for packet size:


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s