Monitoring SQL Server Performance: Quickie Edition
But how about if you only need a quick and dirty way of monitoring your SQL Server right now?
There are built-in functions for that one.
Take a look at this quickie:
@@total_read AS 'Total Read',
@@total_write AS 'Total Write',
@@total_errors AS 'Total Error',
@@io_busy AS 'IO Processing Time (ms)',
@@cpu_busy AS 'CPU Processing Time (ms)',
@@idle AS 'Idle Time (ms)'
Here’s the example in action: