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:
| LinkedServer | Name of the server the drive is on |
| Drive | Name of the Drive |
| MaxDate | The last day measured |
| FreeMax | Free space on the last day measured |
| Min8Date | Oldest day measured not older than 8 days |
| Free8 | Free space on the Min8Date |
| Days8 | Number of days between Min8Date and MaxDate |
| Grow8 | Growth between Min8Date and MaxDate |
| DaysLeft8 | Number of days left in the same growth rate |
| Min30Date | Oldest day measured not older than 30 days |
| Free30 | Free space on the Min30Date |
| Days30 | Number of days between Min30Date and MaxDate |
| Grow30 | Growth between Min30Date and MaxDate |
| DaysLeft30 | Number 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 @RC int
DECLARE @Recipient varchar(250)
DECLARE @ExceptionList varchar(250)
DECLARE @MailStats bit
DECLARE @SqlVersion int
DECLARE @Separator nchar(1)
SET @Recipient = ‘yourname@yourdomain.com’
SET @ExceptionList = ‘ServerNotToProcess’
SET @MailStats = 1
SET @SqlVersion = 0
SET @Separator = ‘,’
EXECUTE @RC = [dbo].[usp_Report_DiskSpaces]
@Recipient
,@ExceptionList
,@MailStats
,@SqlVersion
,@Separator
;
- 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.