capturing performance monitor counter issue

  • 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.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply