1. Help Center
  2. AIMS Platform Guides
  3. Agent - Microsoft SQL Server monitoring

SQL agent logfiles

the agent was compiled for any CPU (32 and 64)

the log.txt is rolling with max size 10 mb

the error.txt is ever growing to not miss any errors

you can can change the default behavior for error.txt

  1. go to c:\Program Files (x86)\AIMS Innovation\_MSSQL Agent\
  2. find aims-mssql-agent.exe.config and backup it first
  3. edit the section <appender name="errorAppender" type="log4net.Appender.FileAppender" > on the way as it is done in the section <appender name="fileAppender" type="log4net.Appender.RollingFileAppender">

so the type has to be type="log4net.Appender.RollingFileAppender" + add 2 xml nodes:

<rollingStyle value="Size" /><maximumFileSize value="10000KB" />

restart the agent