Versions Compared

Old Version 8

changes.mady.by.user Unknown User (6092b4ded35380006886a5ee)

Saved on

compared with

New Version 9

changes.mady.by.user Unknown User (6092b4ded35380006886a5ee)

Saved on

Key

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

...

This alert is raised based on the database metrics collection interval specified in Server Properties. For more information, see Set general server options.

Reduce your SQL Server log space used

  • You can allocate more disk space to the event log, turn on the auto-growth feature for your SQL Server log, or add additional disk space to the computer hosting your SQL Server instance.
  • If autogrowth is turned off for your logs, this alert may indicate the need to either increase the allocated space for logs and/or add disk space to your SQL Server environment.
  • If autogrowth is turned on and you are seeing this alert often, you may need to adjust your autogrowth settings to a higher percentage to improve degraded performance resulting from constant growth adjustments.
  • In certain cases, SQL Diagnostic Manager may incorrectly report the file size. This issue occurs when certain columns in the 'sysindexes' table in SQL Server 2000 become inaccurate and provide SQL Diagnostic Manager with incorrect information regarding the number of rows and table size.
  • Use the following T-SQL syntax to correct this issue:

...