Activity Monitor - % Processor Time Grayed Out

Question

Activity Monitor - % Processor Time Grayed Out

JamesNZ

SSCommitted

Points: 1615
More actions
February 14, 2010 at 9:13 pm

#220568

Does anyone know why the % Processor Time area within Activity Monitor would be grayed out?

Viewing 15 posts - 1 through 15 (of 20 total)

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

anna.ellis@getronics.com Default port Points: 1465 More actions · Answer 1

There's a MS Connect item that flags this behaviour when connecting to remote servers. Does the account you are using have Performance Counter rights?

Satish Nagaraja SSCrazy Points: 2632 More actions · Answer 2

From my experience mostly rely on perfmon tool to observe the counters instead of process monitor 🙂

This would not answer your question but does keep you away from good looking dame with lot of makeup to fool trained eye 😉

Cheer Satish 🙂

JamesNZ SSCommitted Points: 1615 More actions · Answer 3

Aeterna (2/15/2010)
There's a MS Connect item that flags this behaviour when connecting to remote servers. Does the account you are using have Performance Counter rights?

Yes it does, my domain user is a local administrator on that server and I can open Performance Counter and monitor on anything I want to.

JamesNZ SSCommitted Points: 1615 More actions · Answer 4

TECHBABU (2/15/2010)
From my experience mostly rely on perfmon tool to observe the counters instead of process monitor 🙂
This would not answer your question but does keep you away from good looking dame with lot of makeup to fool trained eye 😉

I would just find it handy to be able to see these stats on the fly within Management Studio, that's all really.

David Wiseman SSCommitted Points: 1713 More actions · Answer 5

I've found that adding an entry in the host file (c:\windows\system32\drivers\etc) of your client machine for the remote server can help with this issue. You would also need to have the correct permissions on the server. It does work when accessing servers on non-trusted domains - I think connecting to a UNC path on the server from your client machine to cache credentials for the server works.

This issue annoyed me for a while until I figured it out. There doesn't seem to be much info on fixing the issue so hopefully this will help someone. 🙂

DBA Dash - Free, open source monitoring for SQL Server

massoud-1045248 SSC-Addicted Points: 435 More actions · Answer 6

Hi 1982,

I've seen your post multiple times online but I am not sure what you mean exactly by adding an entry. Could you clarify?

Thanks

David Wiseman SSCommitted Points: 1713 More actions · Answer 7

The host file is used to provide host name resolution - to convert a name into an IP address. This is a simple text file that you can edit in notepad. The file is located here (Note the file has no file extension):

c:\Windows\System32\drivers\etc\hosts

There should be some examples in the file (Comments begin with a #).

See here for more info:

http://en.wikipedia.org/wiki/Hosts_(file)

I'm not sure why it doesn't work with DNS name or IP address, but I've found that adding the host entry allows it to work. I think you might also need to authenticate against the server if it's a non-trusted domain. e.g. Connect to a UNC path on the server (\\servername\share) and provide your credentials.

DBA Dash - Free, open source monitoring for SQL Server

adejola.oyetti SSC Veteran Points: 282 More actions · Answer 8

Activity Monitor does %Processor Time greyed.

On SQL SERVER 2008 servers

Fix

On the host to the sql server instance.

Go my Start -> Right click Computer , select Manage.

This brings up the service manager.

Expand Configuration from left menu

Expand the “Local users and Groups” -> select Groups.

Right click on the Performance Monitor Users and add the users in there.

massoud-1045248 SSC-Addicted Points: 435 More actions · Answer 9

hi adejola,

After following the instructions you provided. I get the following error:

"TITLE: Microsoft SQL Server Management Studio

------------------------------

The Activity Monitor is unable to execute queries against server DSQL.

Activity Monitor for this instance will be placed into a paused state.

Use the context menu in the overview pane to resume the Activity Monitor.

------------------------------

ADDITIONAL INFORMATION:

Unable to find SQL Server process ID 1528 on server DSQL (Microsoft.SqlServer.Management.ResourceMonitoring)

------------------------------

BUTTONS:

OK

------------------------------

"

adejola.oyetti SSC Veteran Points: 282 More actions · Answer 10

I would suggest once you have made the changes to the user on the O/S as described above

you can then :

GRANT VIEW SERVER STATE TO "user"

Finally log in using the user named above.

Try loggin in locally first.

massoud-1045248 SSC-Addicted Points: 435 More actions · Answer 11

massoud-1045248

SSC-Addicted

Points: 435

June 29, 2011 at 8:34 am

#1345969

Thanks

Where do I do the grant view ?

adejola.oyetti SSC Veteran Points: 282 More actions · Answer 12

Log on to the Managment studio, connect to the sql server instance, and click on "new query".

massoud-1045248 SSC-Addicted Points: 435 More actions · Answer 13

Thanks but still get this error message:

TITLE: Microsoft SQL Server Management Studio

------------------------------

The Activity Monitor is unable to execute queries against server DSQL.

Activity Monitor for this instance will be placed into a paused state.

Use the context menu in the overview pane to resume the Activity Monitor.

------------------------------

ADDITIONAL INFORMATION:

Unable to find SQL Server process ID 1528 on server DSQL (Microsoft.SqlServer.Management.ResourceMonitoring)

------------------------------

BUTTONS:

OK

------------------------------

adejola.oyetti SSC Veteran Points: 282 More actions · Answer 14

How to fix it: Use regedit to find HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\PerfProc\Performance there is a key in there called Disable Performance Counters , delete it or set it to 0 You may need a restart after you change the key.