PerfMonitor Problem

Question

question

Cyborg asked Jul 18, '10

PerfMonitor Problem

I was assigned a task to monitor the production DB Server remotely, My machine is running on Windows XP Prof. Version 2002 service pack 3. The problem is, I am able to access the performance objects called 'SQL Server Locks' of my remote machine. (I can access most of the objects like SQL General Statistics,Memory Manager etc) When I am accessing 'SQL Server Lock', as usual all the counters of 'SQL Server Locks' are displayed in the counter list, but my Add button is disabled... Why it is so?

monitoring

6

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 commented · Jul 19, 2010 at 06:11 AM

Is this the only set of counters you cannot add? Can you add base Windows counters or other SQL Server ones from the remote server?

0 ·

Cyborg commented · Jul 19, 2010 at 06:17 AM

Yes i can add all windows counters and also some SQL Server counters but the counters like SQL Server Locks are not able to add (The Add Button is Disabled)

0 ·

Blackhawk-17 commented · Jul 19, 2010 at 06:51 AM

If you run PerfMon on the server are they available?

0 ·

Cyborg commented · Jul 19, 2010 at 08:29 PM

Yes, the counters are available on the server

0 ·

Scot Hauder commented · Jul 19, 2010 at 08:35 PM

RDP into the server

0 ·

Cyborg commented · Jul 19, 2010 at 08:44 PM

I dont privilege for RDP

0 ·

Answer 1 · 2010-07-18T23:20:25Z

ramesh 1 answered Jul 18, '10

create the perfmon add counter on the server and while you save the file just specifiy the path of you computr \\ip address\drive$\filename.csv. hopefully i have no clear idea, but i blindly think so

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question