Increasing timeout for Activity Monitor
One of my servers is at 100% CPU. I am trying to open activity monitor to find out the culprit but its timing out by giving following errors "
===================================
Cannot show requested dialog.
===================================
Unable to execute requested command.
Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()
===================================
Unable to launch Activity Monitor. You may not have sufficient permissions. (ActivityMonitor)
Program Location:
at Microsoft.SqlServer.Management.UI.ActivityMonitor.ActivityMonitorSqlServer.Microsoft.SqlServer.Management.UI.ActivityMonitor.IActivityMonitor.Initialize()
at Microsoft.SqlServer.Management.UI.ActivityMonitor.ActivityMonitorUserControl.InitializeActivityMonitor(IServiceProvider serviceProvider, IActivityMonitor plugin)
at Microsoft.SqlServer.Management.UI.ActivityMonitor.ActivityMonitorUserControl..ctor(IServiceProvider serviceProvider, IActivityMonitor plugin)
at Microsoft.SqlServer.Management.UI.ActivityMonitor.ActivityMonitorForm.InitializeInnerUserControl(IServiceProvider serviceProvider, XmlDocument xmlDoc, String pluginType, Object extendedContext)
at Microsoft.SqlServer.Management.UI.ActivityMonitor.ActivityMonitorForm.InternalInitialization(IServiceProvider serviceProvider, XmlDocument xmlDoc, Object extendedContext)
at Microsoft.SqlServer.Management.UI.ActivityMonitor.ActivityMonitorForm..ctor(XmlDocument xmlDoc, IServiceProvider serviceProvider)
===================================
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)
For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476
Server Name: ANAXASVR12
Error Number: -2
Severity: 11
State: 0
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.UI.ActivityMonitor.ConnectionManager.ExecuteNonQueryAndReportErrors(String commandText)
at Microsoft.SqlServer.Management.UI.ActivityMonitor.ProcessesSnapshot.CaptureSnapshot90(String filter)
at Microsoft.SqlServer.Management.UI.ActivityMonitor.ProcessesSnapshot.CaptureSnapshot(String filter)
at Microsoft.SqlServer.Management.UI.ActivityMonitor.ActivityMonitorSqlServer.CheckUserAccess()
at Microsoft.SqlServer.Management.UI.ActivityMonitor.ActivityMonitorSqlServer.Microsoft.SqlServer.Management.UI.ActivityMonitor.IActivityMonitor.Initialize()
Any ideas how Can I increase timeout for activity monitor tool.
Thanks
