DBAgent Issue handling pages

Information about space reduction

Probable Causes:

• Organic growth
  It may sound obvious, but data naturally grows over time. Data is collected, generated, enriched, and retained, which results in a continuously expanding dataset.
  It is advisable to develop cleaning and archiving strategies to prevent running out of space while your data may already be outdated.
• Occasional or periodic large transactions
  Certain actions performed occasionally or periodically can generate massive transactions that significantly increase database size.
• Excessive indexing
  Indexes improve performance when properly designed. However, they come with trade-offs:
  • They require maintenance, which impacts performance.
  • They consume disk space, sometimes a significant amount.
    In some cases, the total size of indexes may exceed the size of the data itself.
• Deleted data does not automatically release disk space
  Deleting data or dropping objects does not automatically release disk space at the operating system level, depending on how SQL Server is configured.
  Although free space may become available inside the database, releasing that space back to the OS often requires performing shrink operations.
• Non-SQL-related events
  Is the server dedicated to SQL Server, or are other processes consuming disk space? Other applications, logs, or services may reduce available storage.

Links about space consumption that could be useful:

• https://blog.sqlauthority.com/2013/08/02/sql-server-disk-space-monitoring-detecting-low-disk-space-on-server/
• https://www.sqlshack.com/how-to-monitor-total-sql-server-indexes-size/
• https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-volume-stats-transact-sql

Links about shrinking that could be useful:

• https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkdatabase-transact-sql
• https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql
• https://dba.stackexchange.com/questions/41215/shrinking-the-log-file-does-not-reduce-size
• https://www.brentozar.com/archive/2017/12/whats-bad-shrinking-databases-dbcc-shrinkdatabase/
• https://www.eukhost.com/kb/how-to-reduceshrink-the-sql-server-database-size/

> Home >

updated 2018-10-16 11:04 PM