Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Memory High Server - MS SQL SERVER

Hi,
I've encountered a situation where the server memory has risen to 97% on the database server.

I've seen a disolarwinds alert in the SQL Server database, indicating that memory utilization has risen above the threshold.

How do I fix this?

Here's a capture

Find more posts tagged with

microsoft sql server

memory alert

Alert

sam

Accepted answers

All comments

ahawkins72

Hi! That is generally expected behavior from SQL server, especially depending on the max memory setting. SQL Server will grab up all that memory regardless of whether it's using it or not! Mine for instance has 64GB provisioned and the max memory setting recommended by our Orion health checks is like 61GB so the server pretty consistently shows like 98% used.

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver17

ilal.ilal

Then how do I handle it? Is there a way to limit it so that the memory doesn't fill up?

If there is a setting through SQL Server, I will ask my Customer Database Administrator to do it.

Thank you.

oithim_yew

There should be a configurations on the MSSQL server which limits the usage of memory on the DB configurations.

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver17

ahawkins72

Yes, this! You can set the max memory but just make sure you're not bottlenecking your application! (In this case, Solarwinds right? :) )

oithim_yew

basically the MSSQL would basically takes up whatever the numbers memory assigned to it unless you controls it. that is how we 'control' it to makes it looks 'good' in the monitoring. i guess this is the way