Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

capturing performance monitor counter issue Expand / Collapse
Posted Thursday, July 15, 2010 10:07 AM


Group: General Forum Members
Last Login: Wednesday, October 21, 2015 4:44 PM
Points: 16, Visits: 376
This may be more of Windows question, but I thought I give it a stab here since it's ties to capturing SQL server 2005 performance monitor counters. basically, I have been charged with capturing SQL server 2005 performance monitor counters on several servers. So I use typeperf & logman per

Among the 5 several servers with Windows Server 2003, Standard Edition - 5.2 (3790) and SQL 2005 SP2, 3 of them are able to generates the desired CSV output files fine using the same security credentials, but 2 servers that has the same SW specs generates just 2 columns of data that basically reads like this per 5-min cycle:

"(PDH-CSV 4.0) (Central Daylight Time)(300)"
"07/14/2010 17:01:43.625"
"07/14/2010 17:06:43.637"

Where as it should generate more columns that contains the actual counters specs. I have verified to make sure the input counters are there for it to capture. Below are them.

\\SrvrA\Memory\Page Reads/sec
\\SrvrA\Memory\Page Writes/sec
\\SrvrA\Memory\Pages Input/sec
\\SrvrA\Memory\Pages Output/sec

Has anyone seen that before and wondering if I missed something.

Thanks in advance.
Post #953279
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse