capturing performance monitor counter issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » capturing performance monitor counter issue

capturing performance monitor counter issue

Rate Topic

Display Mode

Topic Options

Author

Message

WarrenDar2

Posted Thursday, July 15, 2010 10:07 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 9:37 AM
Points: 15, Visits: 255

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 »

Permissions