cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

WQL WMI Query for Disk I/O

Jump to solution

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!

0 Kudos
1 Solution
4 Replies
Level 12

Level 15

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

0 Kudos