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:

sp_monitor

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

NetworkPacketSize

Advertisements

This entry was posted on May 31, 2011 at 12:34 pm and is filed under DBA. Tagged: , . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )

w
Cancel

Connecting to %s

«
»