The AIMS Microsoft SQL Server agent is by default setup to fetch different data at the following intervals:

  • Every 1 minutes
  • Every 10 minutes
  • Every 720 minutes
  • Every 1440 minutes

Data fetched every minute will automatically have normal-behavior patterns created. They will be part of the automated anomaly detection and correlation towards other systems connected. Read more about automated monitoring here


If necessary, the user can easily move parameters from the 1 minute cycle to any of the other cycles to reduce performance impact. Keep in mind that the automated monitoring will be disabled for these parameters but regular static threshold alerts will still be available. 

The file "localhost.conf" can be found in the folder "C:\ProgramData\AIMS for SQL Server\MS SQL Agent".


SQLagent-configuration.jpg



New cycles with a custom interval can also be added. To create a new cycle, use the same tags as shown in the file above.

Example:
   
 <BatchConfiguration>
      <CycleMinutes>540</CycleMinutes>
.
.
.
</BatchConfiguration>