I've just started using APM for Orion and I was trying to figure out how to write specific WQL queries to list disk i/o performance.
Any help would be greatly appreciated!
Or use the results from the Win32_PerfFormattedData_PerfDisk_PhysicalDisk WMI class.
Hi,
From the SQL Server 2005 Database Application Template.
Page Reads Per Second:
SELECT PagereadsPersec from Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager
Page Writes Per Second:
SELECT PagewritesPersec from Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager
HTH,Yann
Thanks