The Data Used (Percent) metric calculates the size of all data files used as a percent of the added allocated size of all data files.
In a typical medium-to-large-scale OLTP environment with a data file size of over 50 GB, this value slowly increases over time in a linear fashion with the population of any available history tables.
If your site experiences a sudden sharp increase in this value of over 10% in an hour, investigate the issue to fully understand the underlying causes which often lead to poor performance. Possible causes include:
DBCC SHOWCONTIG
.DBCC SHRINKDATABASE
. It is likely that the table is also fragmented because the inserts were done before the deletes so run DBCC SHOWCONTIG
. Always delete the old rows out of a table first before inserting the new rows; otherwise the tables are fragmented more quickly, databases increase in size, and the performance of the transactions is degraded due to the large number of page splits the table had to undergo.SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
|