监控SQL SERVER性能：快速版
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)'
如图:
Author:Petter Liu http://wintersun.cnblogs.com