November 2, 2010 at 4:38 pm
Recently one of the sql server started acting weired. It was working very very smooth but now i can not start activity monitor,sql agent and the servers performance is dead slow.
I get this error for activity monitor
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Unable to execute requested command.
------------------------------
Unable to launch Activity Monitor. You may not have sufficient permissions. (ActivityMonitor)
------------------------------
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=09.00.4053&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I get this error for sql agent
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
Enumerate target servers failed for Job 'Dev_synch'. (Microsoft.SqlServer.Smo)
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot perform this operation while SQLServerAgent is starting. Try again later. (Microsoft SQL Server, Error: 14258)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=14258&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
All this is happening after the recent windows updates, how should i fix this issue now?
November 2, 2010 at 4:51 pm
Is this persistent or just after a server startup?
Have you rebooted the server?
How much free disk space do you have?
How much memory is in use on the server?
Is SQL Server the only thing installed on this server?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 2, 2010 at 4:55 pm
I got this from another post that had one of the same error messages. May or may not apply:
http://support.microsoft.com/kb/303287/
November 2, 2010 at 5:37 pm
Is this persistent or just after a server startup?
-- Yes problem persists all the time
Have you rebooted the server?
-- Many times
How much free disk space do you have?
-- so much nearly 2TB
How much memory is in use on the server?
-- 15g out of 36gb
Is SQL Server the only thing installed on this server?
--yes
David.. I think that solution applied only to sql 2000, is there an article for 2005 with same issue ?
ONe other thing i am seeing is that, every time i restart sql agent, "Agent Xp's" are disabled, i have revonfigure it manually.
November 3, 2010 at 9:48 am
Have you looked for a problem SPID, one that is just beating the crap out of the CPU?
SELECT * FROM sys.dm_exec_sessions
SELECT * FROM sys.dm_exec_connections
SELECT * FROM sys.dm_exec_requests
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 3, 2010 at 11:09 am
Do you have any additional errors in the system event logs?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply