Microsoft SQL Server Insight Metrics

Boost the efficiency of your Microsoft SQL Server by monitoring the slow queries, queries consuming more CPU and input/output (I/O), top sessions, locks, and waits statistics in real time. With Site24x7's in-depth insights into the query metrics and wait stats of your database, you can examine the workloads of your database systems to gain more information on performance enhancements. You can also identify bottlenecks and proactively optimize the health of your Microsoft SQL Server from Site24x7's unique, standardized console.

Supported metrics

Metric	Description	Unit
Query Hash	The binary hash value calculated using the query and used to identify queries with similar logic	Text
Category	The category of the query	Text
Creation Time	The time at which the plan was compiled	Time
Average CPU Time	The average amount of CPU time that was consumed by the executions of this plan since it was compiled	Milliseconds
Maximum CPU Time	The maximum CPU time consumed during a single execution	Milliseconds
Minimum CPU Time	The minimum CPU time consumed during a single execution	Milliseconds
Total CPU Time	The total amount of CPU time consumed by the executions of this plan since it was compiled	Milliseconds
Execution Count	The number of times the plan has been executed since it was last compiled	Count
Average Execution Time	The average elapsed time for the completed executions of this plan	Milliseconds
Maximum Execution Time	The maximum elapsed time for completed executions of this plan	Milliseconds
Minimum Execution Time	The minimum elapsed time for completed executions of this plan	Milliseconds
Total Execution Time	The total elapsed time for completed executions of this plan	Milliseconds
Average Physical Reads	The average number of physical reads performed by the executions of this plan since it was compiled	Count
Maximum Physical Reads	The maximum number of physical reads that this plan has ever performed during a single execution	Count
Minimum Physical Reads	The minimum number of physical reads that this plan has ever performed during a single execution	Count
Total Physical Reads	The total number of physical reads performed by the executions of this plan since it was compiled	Count
Average Logical Reads	The average number of logical reads performed by the executions of this plan since it was compiled	Count
Maximum Logical Reads	The maximum number of logical reads that this plan has ever performed during a single execution	Count
Minimum Logical Reads	The minimum number of logical reads that this plan has ever performed during a single execution	Count
Total Logical Reads	The total number of logical reads performed by the executions of this plan since it was compiled	Count
Average Logical Writes	The average number of logical writes performed by the executions of this plan since it was compiled	Count
Maximum Logical Writes	The maximum number of logical writes that this plan has ever performed during a single execution	Count
Minimum Logical Writes	The minimum number of logical writes that this plan has ever performed during a single execution	Count
Total Logical Writes	The total number of logical writes performed by the executions of this plan since it was compiled	Count
Average CLR Time	The average time consumed inside the Microsoft .NET Framework Common Language Runtime (CLR) objects by the executions of this plan since it was compiled	Milliseconds
Maximum CLR Time	The maximum time that this plan has ever consumed inside the .NET Framework CLR objects during a single execution	Milliseconds
Minimum CLR Time	The minimum time that this plan has ever consumed inside the .NET Framework CLR objects during a single execution	Milliseconds
Total CLR Time	The total time consumed inside the .NET Framework CLR objects by the executions of this plan since it was compiled	Milliseconds
Average Logical I/O	The average I/O of the total number of logical reads and writes performed by the executions of this plan since it was compiled	Count
Total Logical I/O	The total number of logical reads and writes performed by the executions of this plan since it was compiled	Count
Average Time Blocked	The average of the difference between the total elapsed time and the total worker time	Milliseconds
Total Time Blocked	The difference between the total elapsed time and the total worker time	Milliseconds
Average Rows	The average number of rows returned by the query	Count
Maximum Rows	The maximum number of rows ever returned by the query during one execution	Count
Minimum Rows	The minimum number of rows ever returned by the query during one execution	Count
Total Rows	The total number of rows returned by the query	Count
Query	The text of the SQL query	Text
Database	The database where the statements were compiled	Text
Last Execution Time	The last time that the plan started executing	Time

Sessions
Sessions	The number of sessions running at that moment	Number
Running Sessions	The number of sessions currently running requests	Number
Sleeping Sessions	The number of sessions currently running without requests	Number
Dormant Sessions	The number of sessions that have been reset because of the connection pooling and are now in the pre-login state	Number
Preconnect Sessions	The number of sessions that are in the Resource Governor classifier	Number
Active Users	The number of unique active users	Number

User details
Username	The name of the principal that is unique within a server	Text
Created Date	The time at which the principal was created	Time
Default Database	The default database for this principal	Text
Login Disabled	The status of the login for the particular user	Text

Sessions and waits
SQL Server Session ID	The SQL Server session ID	Number
Login Time	The time at which a client process logged in to the server	Time
Login Time in Seconds	The time (in seconds) at which a client process logged in to the server	Seconds
Host Process ID	The workstation process ID number	Number
Status	The status of the process ID	Text
Username	The login username	Text
Network Packet Size	The network packet size used for information and data transfers	Number
Hostname	The name of the workstation	Text
Program Name	The name of the application program	Text
Memory Usage	The number of pages in the procedure cache that are currently allocated to this process	Count
CPU Time	The cumulative CPU time for the process	Milliseconds
Physical I/O	The cumulative disk reads and writes for the process	Number
Wait Time	The current wait time to execute the query	Milliseconds
Last Wait Type	The string indicating the name of the last or current wait type	Text
Wait Resource	The textual representation of a lock resource	Text
Byte Reads	The number of byte reads that have occurred over this connection	Bytes
Byte Writes	The number of byte writes that have occurred over this connection	Bytes
Blocking Session ID	The ID of the session that is blocking the request	Number
Database	The database being used by the process	Text
Command	The command that is currently being executed	Text
Last Batch Time	The last time a client process executed a remote stored procedure call or an EXECUTE statement	Time
Network Library	The column in which the client's network library is stored (Every client process comes in on a network connection, and network connections have a network library associated with them that enables them to make the connection)	Text
Query	The text of the SQL query	Text

Locks
Resource Type	The type of the resource (The value can be one of the following: DATABASE, FILE, OBJECT, PAGE, KEY, EXTENT, RID, APPLICATION, METADATA, HOBT, or ALLOCATION_UNIT)	Text
Resource Description	The resource description containing only the information that is not available from other resource columns	Text
Resource Associated Entity	The ID of the entity in a database with which a resource is associated (This can be an object ID, HoBt ID, or allocation unit ID, depending on the resource type)	Text
Resource Lock Partition	The ID of the lock partition for a partitioned lock resource	Number
Request Status	The current status of this request	Text
Request Mode	The mode of the request (For granted requests, this is the granted mode; for waiting requests, this is the mode being requested)	Text
Request Reference Count	The approximate number of times the same requestor has requested this resource	Number
Request Session ID	The ID of the session that currently owns this request	Number
Request Owner Type	The type of the entity that owns the request	Text
Transaction Isolation Level	The isolation level at which the transaction for this request is created	Number
Request Owner ID	The ID of the specific owner of this request	Number
Database	The database under which this resource is scoped	Text
Requesting Query	The requesting SQL query	Text
Query Hash	The binary hash value calculated for the query and used to identify queries with similar logic	Text
Requesting User	The user who submitted the request	Text
Blocking Session ID	The session that is blocking the request	Number
Blocking Query	The SQL query that is blocking the request	Text
Deadlock Priority	The deadlock priority setting for the request	Number
Lock Timeout	The lock timeout period for this request	Milliseconds
Wait Time	The duration of the current wait when the request is blocked	Milliseconds
Wait Type	The type of the wait when the request is blocked	Text
Last Wait Type	The type of the last wait when the request was previously blocked	Text
Percent Complete	The percentage of work that is completed	Decimal
CPU Time	The CPU time that is used by the request	Milliseconds
Execution Time	The total time elapsed since the request arrived	Milliseconds
Reads	The number of reads performed by this request	Number
Writes	The number of writes performed by this request	Number
Logical Reads	The number of logical reads that have been performed by the request	Number
Row Count	The number of rows that have been returned to the client by this request	Number
Granted Query Memory	The number of pages allocated to the execution of a query for the request	Number
Open Transaction Count	The number of transactions that are open for this request	Number

Server configuration options (SQL Server)
Configuration Name	The name of the configuration option	Text
Description	The description of the configuration option	Text
Dynamic Configuration	The status of the variable that takes effect when the RECONFIGURE statement is executed (If the configuration is not dynamic, then a database engine restart is required to apply the changes)	Text
Advanced Configuration	The status of the variable that denotes if the configuration is advanced or not	Text
Minimum Value	The minimum value for the configuration option	Number
Maximum Value	The maximum value for the configuration option	Number
Value	The running value that is currently in effect for this option	Number

Query statistics
Queries	The number of queries running at that moment	Number
Blocked Sessions	The number of blocked sessions at that moment	Number
Select Commands	The number of select queries at that moment	Number
Insert Commands	The number of insert queries at that moment	Number
Update Commands	The number of update queries at that moment	Number
Delete Commands	The number of delete queries at that moment	Number

Lock statistics
Locks	The number of locks at that moment	Number
Granted	The number of granted locks at that moment	Number
Convert	The number of convert locks at that moment	Number
Wait	The number of wait locks at that moment	Number
Low Priority Convert	The number of low priority convert locks at that moment	Number
Low Priority Wait	The number of low priority wait locks at that moment	Number
Abort Blockers	The number of abort blockers locks at that moment	Number

Microsoft SQL Server Insight Metrics

Supported metrics

Related articles