SQLAGENT.OUT is blowing up

  • 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.

  • 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

  • Run

    sp_cycle_agent_errorlog

  • 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.

  • 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 5 (of 5 total)

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