Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Server & Application Monitor (SAM) > AppInsight for SQL: Create an alert trigger based on how much available space is occupied in the database

AppInsight for SQL: Create an alert trigger based on how much available space is occupied in the database

Table of contents

Overview

This article provides steps to create an alert trigger based on how much available space is occupied by the actual data in your database.

Environment

All SAM versions

 

Steps

Measure how much of the maximum size is used.

Use a Custom SQL Alert for AppInsight for SQL: Database. Use the following as a filter in for the trigger condition:

JOIN APM_SqlBbDatabaseFileAlertsData AS dbfile
ON APM_SqlBbDatabaseAlertsData.DatabaseID = dbfile.DatabaseID

WHERE dbfile.FileType = 0 AND ((dbfile.UsedSpace * 100.0 / (dbfile.Size + dbfile.DatabaseFileFreeSpace)) > 5.0)

 

Use the following as a filter for the reset condition:

JOIN APM_SqlBbDatabaseFileAlertsData AS dbfile

ON APM_SqlBbDatabaseAlertsData.DatabaseID = dbfile.DatabaseID

WHERE dbfile.FileType = 0 AND ((dbfile.UsedSpace * 100.0 / (dbfile.Size + dbfile.DatabaseFileFreeSpace)) <= 5.0)

Note: Where the 5.0 means if more than 5.0% of the available space is being used by the data, trigger the alert.

 

 

Last modified

Tags

Classifications

Public