Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

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