Wednesday, May 20, 2009

SQL Server System Statistical Functions

Number of millionths of a second in a timer tick.
The number of connections or attempted connections.
Timer ticks that the CPU has been working for SQL Server.
Time in timer ticks that SQL Server has been idle.
Timer ticks that SQL Server has spent performing I/O operations.
Number of network packet errors that have occurred.
Number of packets read from the network.
Number of packets written to the network.
Number of read/write errors during I/O operations.
Number of disk reads.
Number of disk writes.


Example : (Get SQL Server I/O)

No comments:

Post a Comment

span.fullpost {display:inline;}