how to get sql server statistics

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