Using Performance Monitor to log data

I wanted to use Performance Monitor to log data and selected 8 counters that I wanted to monitor. I saved the log file as .csv in CerfLogs. But, when I viewed the csv file, it only showed 6 counters recorded in the file. If I increased the counters to 10 or more, it still recorded only 6 counters.

Does anyone know what may have caused this issue?

Thanks,
Ben

Did you try to log data from other servers?

These are what I tried to gather:

MemoryAvailable Bytes
MemoryPages/sec
SQL Server Buffer: Buffer Cache Hit Ratio
SQL Server General: User Connections
PhysicalDisk(_Total)% Disk Time
PhysicalDisk(_Total)Avg. Disk Queue Length
Processor(_Total)% Processor Time
SystemProcessor Queue Length

But only 6 counters recorded in the csv file:

MemoryAvailable Bytes
MemoryPages/sec
PhysicalDisk(_Total)% Disk Time
PhysicalDisk(_Total)Avg. Disk Queue Length
Processor(_Total)% Processor Time
SystemProcessor Queue Length

I ran this from my desktop (SQL Server client installed) connecting to the NT server where SQL Server 2000 Enterprise edition is running. But, I can get all counters recorded in the file if I run it directly on the server.

I am not sure, but if you have both server and client in same domain then logon on client using same domain id that is being used for server logon.
OR
try to add your client network logon id on server's administrtor group.

server: sql production server.
client : your desktop where from you are running perfmon trace.

I guess you at present you would not be able to get data for any SQL Server related counter, are you?

Deepak Kumar

--An eye for an eye and everyone shall be blind

Yes. You are right. I cannot gather data for any SQL Server related counters.

I'm a member of the server admin group, and I use the same logins (under AD domain) for NT and SQL Server (windows authentication login).

Yes. I see all of them.