August 25, 2011 at 2:31 pm
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
August 26, 2011 at 10:12 am
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.
August 29, 2011 at 4:06 am
Through which account your agent service is running.
check that account has sysadmins rights?
August 29, 2011 at 8:40 am
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
August 30, 2011 at 1:34 am
Is msdb database working fine?
August 30, 2011 at 4:00 pm
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"
August 31, 2011 at 3:18 am
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.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 1, 2011 at 12:48 pm
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
January 15, 2013 at 10:22 pm
Hi Sai,
Can you please let us know what was the output of the Case with Microsoft, was there solution for your problem?
Thanks
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply