<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Activity Monitor - % Processor Time Grayed...
19 posts, Page 1 of 2
1
2
»»
Activity Monitor - % Processor Time Grayed Out
Rate Topic
Display Mode
Topic Options
Author
Message
JamesNZ
JamesNZ
Posted Sunday, February 14, 2010 9:13 PM
Valued Member
Group: General Forum Members
Last Login: Wednesday, September 29, 2010 2:32 AM
Points: 73,
Visits: 274
Does anyone know why the % Processor Time area within Activity Monitor would be grayed out?
Post Attachments
activity_monitor.jpg
(
78 views,
61.90 KB
)
Post #865351
Aeterna
Aeterna
Posted Monday, February 15, 2010 2:33 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:29 AM
Points: 214,
Visits: 402
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?
Post #865422
Satish Nagaraja
Satish Nagaraja
Posted Monday, February 15, 2010 4:42 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, March 29, 2013 2:25 AM
Points: 164,
Visits: 251
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
Post #865463
JamesNZ
JamesNZ
Posted Monday, February 15, 2010 1:53 PM
Valued Member
Group: General Forum Members
Last Login: Wednesday, September 29, 2010 2:32 AM
Points: 73,
Visits: 274
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.
Post #865705
JamesNZ
JamesNZ
Posted Monday, February 15, 2010 1:58 PM
Valued Member
Group: General Forum Members
Last Login: Wednesday, September 29, 2010 2:32 AM
Points: 73,
Visits: 274
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.
Post #865707
wiseman82
wiseman82
Posted Tuesday, September 07, 2010 4:08 AM
SSC Journeyman
Group: General Forum Members
Last Login: Yesterday @ 2:31 PM
Points: 77,
Visits: 566
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.
Post #981434
massoud-1045248
massoud-1045248
Posted Monday, November 15, 2010 3:06 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, December 26, 2012 7:59 AM
Points: 7,
Visits: 25
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
Post #1021116
wiseman82
wiseman82
Posted Tuesday, November 16, 2010 1:25 AM
SSC Journeyman
Group: General Forum Members
Last Login: Yesterday @ 2:31 PM
Points: 77,
Visits: 566
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.
Post #1021271
adejola.oyetti
adejola.oyetti
Posted Wednesday, June 29, 2011 5:31 AM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, October 03, 2012 11:23 AM
Points: 10,
Visits: 114
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.
Post #1133608
massoud-1045248
massoud-1045248
Posted Wednesday, June 29, 2011 8:25 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, December 26, 2012 7:59 AM
Points: 7,
Visits: 25
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
------------------------------
"
Post #1133767
« Prev Topic
|
Next Topic »
19 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
