March 25, 2010 at 7:08 am
I am running SQL2008 Server Standard edition on Server 2008 x64. When I try to run the Activity Monitor in Management Studio I get the following error:
The Activity Monitor is unable to execute queries against server [my instance name].
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 1328 on server [server name]
(Microsoft.SQLServer.Management.ResourceMonitoring)
When I used the context menu to resume, I get the same message. Does anyone have any idea's?
THANKS in advance.
March 26, 2010 at 3:26 am
Just try close the SSMS and reconnect to server
March 26, 2010 at 6:57 am
Done that several times. Same result.
MK
March 26, 2010 at 7:05 am
Not that his has the fix but it does mention to ensure the user account running Activity Monitor has permission in the "Performance Monitor Users" Windows group.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
March 26, 2010 at 7:11 am
I have logged into the box as a domain admin and into the SQL instance with the sa account. Still same issue.
MK
March 29, 2010 at 5:04 am
Can you please let me know the default database of the user you used to connect?
Is your CPU 100% saturated??
March 29, 2010 at 5:42 am
The user sa defaults to the 'master' database. And no the CPU is not saturated at all. There is only one database actively running on this server.
March 29, 2010 at 5:57 am
mkuechler (3/26/2010)
I have logged into the box as a domain admin and into the SQL instance with the sa account. Still same issue.MK
If you have Windows Authentication allowed...can you try adding your Windows login account into SQL and then logon to SSMS with windows authentication to see if that works? I would believe the SA account should work, but I don't use that account in my environment.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
March 29, 2010 at 6:25 am
Same deal.
It doesn't matter which account I use it still comes up with that error.
Anyone know what the "SQL Server Process ID 1328" is?
March 29, 2010 at 7:46 am
mkuechler (3/29/2010)
Anyone know what the "SQL Server Process ID 1328" is?
sp_who
--OR
sp_who2
Executing one of these commands in query should give you pretty much what is shown in Activity Monitor
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
March 29, 2010 at 7:52 am
Thanks! That is good to know.
Is there one to show the db locks?
March 29, 2010 at 7:58 am
This is the MSDN (aka Books Online) that show the DMVs used in SQL Server 2005:
http://msdn.microsoft.com/en-us/library/ms188754.aspx
Then sys.dm_tran_locks will shows you the locks currently active (http://msdn.microsoft.com/en-us/library/ms190345.aspx)
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 5, 2019 at 9:26 am
Using SSMS 17.9.1, I right-clicked the tab and clicked resume several times, and eventually got the expected information.
February 6, 2019 at 7:54 am
I have this same issue come up from time to time. The only thing I see is that the CPUs may not be near 100% but there is a LOT of activity going on within SQL Server.
February 6, 2019 at 1:35 pm
Hi
"If SQL is running on a Windows 2008 R2 server or cluster, go to the Performance Monitor application, expand the Data Collection Sets, then select the System Performance, if the arrow is green on the line below the menu just click on it. This will restart the counters, you may wish to do same for System Diagnosis collection set.
Then just refresh or open new connection to the SQL instance you wish to open SSMS Activity Monitor for, this should have solved your problem."
Hope this helps.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply