Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In an attempt to improve response time and avoid using unnecessary space on your server, you can designate the maximum size of your SQL Server Agent log and your SQL Server Error log that SQL Diagnostic Manager reads. When a log reaches the size limit set in the Alert Configuration, it triggers an alert. SQL Diagnostic Manager does not display in the Logs view any data from error or agent logs in excess of the size limit. A quick solution to decrease the size of your file is to click Cycle Server Log to archive the information in the most recent log and start a new log. You can also cycle the log using SSMS.

...

  1. View the Alert Configuration for your monitored SQL Server instance.
  2. Select either the SQL Server Agent Log or the SQL Server Error Log alert, and then click Advanced.
  3. In the Alert Filters tab, adjust the Size (MB) field based on what you want for your log size limit.
  4. Click OK, and then click Apply.
  5. Click OK in the confirmation message if you want to apply your change to any other SQL Server instances, or click No.

...