October 8, 2010 at 3:17 pm
When I trying to Open Activity Monitor in SQL 2008 PROD server. Getting following error.
TITLE: Microsoft SQL Server Management Studio
------------------------------
The Activity Monitor is unable to execute queries against server Servername\InstanceName.
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:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Any one help on this. what is issuse ?
October 9, 2010 at 4:03 am
Check if there are any blocking processes using the below query
SELECT session_id, blocking_session_id FROM Sys.dm_exec_requests where blocking_session_id <> 0
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply