Monitor Diskspaces

The procedure Monitor Diskspaces lists all disks and their free space on all monitored servers. The results are compared to the previous results from up to 30 days. With these combined results the remaining time per disk is calculated. The report contains information about how many days are left if the same growthrate holds. The following items are in the report:

LinkedServerName of the server the drive is on
DriveName of the Drive
MaxDateThe last day measured
FreeMaxFree space on the last day measured
Min8DateOldest day measured not older than 8 days
Free8Free space on the Min8Date
Days8Number of days between Min8Date and MaxDate
Grow8Growth between Min8Date and MaxDate
DaysLeft8Number of days left in the same growth rate
Min30DateOldest day measured not older than 30 days
Free30Free space on the Min30Date
Days30Number of days between Min30Date and MaxDate
Grow30Growth between Min30Date and MaxDate
DaysLeft30Number of days left in the same growth rate

How to use it

The procedure usp_Report_DiskSpaces will crawl all Linked Servers that are present on the server where your Sequenchel database resides. Information for the disks is stored in the Sequenchel database in the table tbl_DiskSpaces.

Create a scheduled job using the Settings window. This will create a job with all necessary information. If you prefer to do this manually, execute the stored procedure with the following parameters:

Execute the stored procedure with the following parameters:

DECLARE @Recipient varchar(250)
DECLARE @ExceptionList varchar(250)
DECLARE @MailStats bit
DECLARE @SqlVersion int
DECLARE @Separator nchar(1)

SET @Recipient = ‘’
SET @ExceptionList = ‘ServerNotToProcess’
SET @MailStats = 1
SET @SqlVersion = 0
SET @Separator = ‘,’

EXECUTE @RC = [dbo].[usp_Report_DiskSpaces] 

  • The recipient is the emailaddress where to send the results to.
  • The ExceptionList is a comma separated list of servers that should not be monitored. 
  • Mailstats = 1 means that you will recieve an email if there is no useful information te report, telling you exactly this. If you set this to 0 then no email is sent unless there is something to report.
  • SqlVersion = 0 means report all (possible) Sql Server Verions. If you set this to 11, then only Sql Server 2012 will be monitored and reported.
  • Seperator is the separator character for the comma separated list. You can choose any single character for this.

We recommend that you schedule this procedure on a daily basis after the Monitor Servers procedure has run. Any servers not found by the Monitor Servers will be skipped, saving time.

Collected Information

  • DriveID
  • LinkedServer
  • Drive
  • LogicalName *
  • file_system_type *
  • TotalSizeMB *
  • FreeSpaceMB
  • supports_compression *
  • supports_alternate_streams *
  • supports_sparse_files *
  • is_read_only *
  • is_compressed *
  • DateLogged

* = Only for drives that actually have database files on them.