Applications Systems

SAM Alert: Database file is running low on space "C:\MSSQL14.SOLARWINDS\MSSQL\DATA\SolarWindsOrion_IN_MEM"

Getting an AppInsight for SQL alert for in_memory tables even though it is not low on space

First published date

6/11/2020 5:06 PM

Last published date

7/3/2025 5:11 AM

Overview

The built-in alert "AppInsight for SQL: Alert me when my database file is running low on space" is triggering for in_memory tables, for example: C:\MSSQL14.SOLARWINDS\MSSQL\DATA\SolarWindsOrion_IN_MEM

When checking the database server, there is enough memory and storage space, also the memory is not over-allocated to the said database file.

Product section

Server Application Monitor

Cause

That is a FILESTREAM data file and is expected to use the memory available, so the alert for free space should not apply for this (which the built-in alert does).

Resolution

Exclude the FILESTREAM data file in the alert:

Create a duplicate for the built-in alert "AppInsight for SQL: Alert me when my database file is running low on space"
On the Trigger Condition, add an exclusion for the FILESTREAM data. For example:
AppInsight for SQL: Database File | Name | Does not end with | IN_MEM

Save the alert.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.