Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 1:16 PM
Points: 15, Visits: 301
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 http://www.mssqltips.com/tip.asp?tip=1722

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
\\SrvrA\Memory\Pages/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