I'm looking for a sample query to extract meaningful measurement values and
timestamps out of the schema that perfmon in Win2003/XP stores it's data in.
(Tables "CounterData", "CounterDetails", etc)
The counters I'm primarily interested are Processor:%Processor Time,
PhysicalDisk:Disk Queue Length and PhysicalDisk:Disk Transfers/Sec. Storing
the data is not a problem, extracting it is.
GUID CounterID RecordIndex CounterDateTime
CounterValue FirstValueA
FirstValueB SecondValueA SecondValueB MultiCount
------------------------------------ ----------- ----------- ---------------
--------- ----------------------------------------------------- -----------
----------- ------------ ------------ -----------
8E82C26A-6372-43CC-9973-0769EB327178 1 1 2004-02-12
11:32:11.316 502.93732995001142 2699017
0 992676856 1874 1
(1 row(s) affected)
obviously 502.9 is not a valid CPU %.
>> Stay informed about: Perfmon ODBC Database Query