Monitoring SQL Server Performance: Quickie Edition
April 28, 2009
There are various mechanisms to measure the performance of your SQL Server. An efficient way to do it is through digging in with Performance Monitor.
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:
SELECT
@@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:
4 Comments
leave one →
Nice work.Can I include this script on the monitoring scripts for http://www.codeplex.com/SqlConsolidate ?