Data World

Posts Tagged ‘sql server statistics’

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

Posted in DBA | Tagged: , | Leave a Comment »