July 21, 2009 at 10:05 am
I just installed SQL 2008 Management Studio and I am recieving the following error message when I open Activity Monitor for SQL 2005 Standard Edition SP3 server. All SQL 2005 SP2 servers display the graphs without error.
The Server is running Windows Server 2008 (64Bit) with 16GB RAM
===================================
The Activity Monitor is unable to execute queries against server
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.
===================================
Unable to find SQL Server process ID 5472 on server
------------------------------
Program Location:
at Microsoft.SqlServer.Management.ResourceMonitoring.SqlPerfmonProcessReader.GetSqlProcessCpuUtilization()
at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundSqlCpuTask.Execute()
at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundWorkRequest.Execute()
at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundWorkRequestQueue.BackgroundWorker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
July 29, 2009 at 5:21 pm
I installed SP3 on my SQL2005 cluster running Windows Server 2003 today and could not duplicate the problem. So I ruled out SP3 as being the cause. I did however find the solution. The server in question is running on Windows Server 2008. I enabled the Performance Counter DLL Host service and the issue was resolved.
July 21, 2011 at 3:08 pm
Thanks for this post. There is a ton of bad information surrounding this problem. Changing the service from manual to automatic and starting it up worked well and now I can start Activity monitor using SSMS. this pertained to 64 bit 2008 install on win 7
July 21, 2011 at 4:49 pm
I see this issue many times in my old environment so many times as the server is already busy with tons of requests, Activity monitor hangs and displays timeouts for activity monitor
But then I decide its not worth using Activty Monitor in peak busy time as it is also a overhead to the server so then I decide to use the activty monitor script which also includes the headblocker here[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply