Viewing 4 posts - 1 through 5 (of 5 total)
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...
June 29, 2011 at 11:22 am
Log on to the Managment studio, connect to the sql server instance, and click on "new query".
June 29, 2011 at 9:15 am
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...
June 29, 2011 at 8:32 am
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...
June 29, 2011 at 5:31 am
Viewing 4 posts - 1 through 5 (of 5 total)