July 15, 2010 at 10:07 am
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