Post reply

SQLAGENT.OUT is blowing up

  • August 22, 2008 at 6:44 pm

    #71783

    For some reasons, the size of the SQLAGENT.OUT file keeps growing and is reaching 240 GB.

    Does anyone know why and how to avoid it?

    Any input will be greatly appreciated in advance.

  • August 25, 2008 at 2:17 pm

    #862783

    Have you gone thru the following suggestion from Tibor-

    It is an errorlog file for the SQL server Agent service. The fact that it is so big in size is worrying. You can stop Agent and find some editor which can read large files (there are editors out there that doesn't read the whole file into memory). Find out where all these errors come from. You can now delete the file and start agent. And now, fix the reason why you had all those entries in

    the log file.

    MJ

  • August 26, 2008 at 6:44 am

    #863082

    Run

    sp_cycle_agent_errorlog

  • August 3, 2009 at 12:44 pm

    #1033837

    By right clicking on sql agent go on to it's properties and check whether have u clicked on EXECUTION TRACE MESSAGES . If yes plz unchecked that.

  • September 3, 2011 at 8:13 am

    #1376767

    You can identify the file by going into Configuration manager, click on SQL Server agent, advanced tab and then you will see it under "Dump Directory".

    You may want to do the following.

    http://www.sqlcoffee.com/Troubleshooting046.htm

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply