The SQL Server Data Used (Percent) alert indicates that you have a high percentage of allocated database space in use.
This alert is raised based on the database metrics collection interval specified in Server Properties. For more information, see Set general server options.
sysindexes
table become inaccurate and provide SQL Diagnostic Manager with incorrect information regarding the number of rows and table size. To correct this problem, use the following T-SQL syntax:DBCC UPDATEUSAGE ('database_name' ) GO
We recommend that you execute this command during non-peak hours as it is server intensive.
To enable alerting when this metric is outside its established baseline, click the Baseline Thresholds Enabled (as percentage of baseline) check box in the Alert Configuration window. |
| | | | | | | |