Welcome to ServerForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Perfmon ODBC Database Query

 
   Windows Server (Home) -> Windows Server Setup RSS
Next:  Very Begginer Server 2003 question.  
Author Message
news

External


Since: Feb 24, 2004
Posts: 2



(Msg. 1) Posted: Sat Feb 28, 2004 9:33 am
Post subject: Perfmon ODBC Database Query
Archived from groups: microsoft>public>windowsxp>configuration_Manage, others (more info?)

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 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Windows cannot query for the list of Group Policy objects - Dear all, After successfully upgrading one more Windows NT 4.0 BDC to Windows Server 2003, and installing another integrated AD DNS using secure only dynamic updates, I started to receive events 1030 - "Windows cannot query for the list of Group ...

ODBC wont password protect - I have two databases outside of the websites webroot, and I am unable to get the username and password for the ODBC connection to take effect. I can access the database with and without the password. How do I get it to require the username and..

convert ODBC's From Windows 2000 to Windows 2003 - Is there any recommended fashion to move ODBC's from a server running Windows 2000 to Windows 2003? Glenn

Windows 2003 Server - Role for Database application? - I'm setting up Windows 2003 Server to support a Phone Order Management application accessed by a number of client machines. The MSDE database will reside on the server. In Windows 2003 Server I need to set up "Server Roles" before install...

remote acl/perfmon/log - Hi We just buy a couple of new server with 2003 server on it One of them (NAS) does not play like the other : - when I try to manage acls from a nt workstation, when I choose add to add a group or personn, the wks can not retrieve the list of users..
   Windows Server (Home) -> Windows Server Setup All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]