Sql server Agent stops working

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Sql server Agent stops working

Sql server Agent stops working

Rate Topic

Display Mode

Topic Options

Author

Message

Saidba17

Posted Thursday, August 25, 2011 2:31 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, July 03, 2012 8:05 AM
Points: 12, Visits: 589

Hi all,
I have been seeing a strange issues.We have a Sql server 2005 Enteprise edition installed on a windows 2008 server.Sql server agent stopped working suddenly and this issue started since the last couple of days .Tried to start it up but shutdowns immediatley.We have 32 gb of Ram and 16 cpu's allocated.I dont see any issues with the Sql Server services

Sql Agent Output file
[097] Memory leak detected [204 bytes]
Exception 5 caught at line 403 of file e:\sql9_sp2_t\sql\komodo\src\core\sqlagent\src\alerter.cpp. SQLServerAgent initiating self-termination

Please share your suggestions

Thanks,
Sai

Post #1165745

Meet George Jetson

Posted Friday, August 26, 2011 10:12 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:51 AM
Points: 1,274, Visits: 1,204

Are there any entries in the logs? Start with the SQL Error Logs and then move to the Windows Logs.

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.

Post #1166230

MasterDB

Posted Monday, August 29, 2011 4:06 AM

Old Hand

Group: General Forum Members
Last Login: Saturday, February 09, 2013 3:44 PM
Points: 345, Visits: 565

Through which account your agent service is running.

check that account has sysadmins rights?

Post #1166835

Saidba17

Posted Monday, August 29, 2011 8:40 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, July 03, 2012 8:05 AM
Points: 12, Visits: 589

They were few errors in the .Notified windows admins to look into the logs .

Event Logs :
The description for Event ID '0' in Source '' cannot be found. The local computer may not have the necessary registry information or message DLL files to display the message, or you may not have permission to access them.

Yes,Account has sysadmin rights.Both Sql Server services and agent are running through the same domain account .I dont have any issues with the Sql server services.Everything was running fine untill the server was rebooted few days ago .

Thanks,
Sai

Post #1166939

Ajay...

Posted Tuesday, August 30, 2011 1:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 10:07 PM
Points: 1, Visits: 17

Is msdb database working fine?

Post #1167330

Joie Andrew

Posted Tuesday, August 30, 2011 4:00 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 553, Visits: 1,032

If nothing is reported in the SQL error log when the instance starts have you tried just making changes just to the SQL Agent service through SQL Server Configuration Manager to start eliminating possibilities? Tried setting the SQL Agent to use the local system account? Set the agent to use a new domain account? A new local account?

Joie Andrew
"Since 1982"

Post #1167847

EdVassie

Posted Wednesday, August 31, 2011 3:18 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:26 AM
Points: 2,621, Visits: 2,759

The clue to the problem might just be in the error message

[097] Memory leak detected [204 bytes]
Exception 5 caught at line 403 of file e:\sql9_sp2_t\sql\komodo\src\core\sqlagent\src\alerter.cpp. SQLServerAgent

My reading of the message is that SQL Agent has detected a memory leak in a third-party component called alerter.cpp. This could be supplied with the komodo ide or be a locally developed product. Try Googling 'Mark Russinovich memory leak' for a step by step guide on how to detect if a memory leak is happening and the module causing it.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Post #1167954

Saidba17

Posted Thursday, September 01, 2011 12:48 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, July 03, 2012 8:05 AM
Points: 12, Visits: 589

Ajay,
Msdb database is running fine

Joie,
I have tried to startup sevrices under domain account as well as local system account.All our services run under one domain account a a standard

I will look into the article.Also opened an incident with microsoft technical support .Will keep posted with any updates as i receive .

Thanks,
Sai

Post #1168861

Bob Bogdanovic-469359

Posted Tuesday, January 15, 2013 10:22 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:01 PM
Points: 1, Visits: 93

Hi Sai,

Can you please let us know what was the output of the Case with Microsoft, was there solution for your problem?

Thanks

Post #1407592

« Prev Topic | Next Topic »

Permissions