This stored procedure generates an HTML-report about logical drives that either have free disk space less than 15%, or free space decreases over 5% a day. The latter shows a strange activity of records which means that someone stores too much information on this disk very often. It might happen for the following reasons:

  1. It is a time to extend a disk;
  2. It is necessary to delete unused files on a logical drive;
  3. Erase and reduce log files, as well as files of information and other tables.

#database #automatic data collection #ms sql server

Automatic Data Collection: Database Files and Logical Drives in MS SQL Server
1.05 GEEK