Probable dumb newbie question

Although I have used SQL servers a fair bit, I have never had to manage a server before. I have a VM with windows server 2019 running only as an MSSQL server, only for solarwinds. For a while now I keep getting alerts about 90% or more memory usage. I think I started with 32GB, then increased to 48 and now 56. Still getting these alerts. All I am using is NPM with less than 500 nodes.

My question is: is there general maintenance that needs to be done from time to time on the SQL server? Clear old data, compress, clean up? Anything like that? Would that cause high memory usage?

Or is this even an issue worth looking into? In other words, MSSQL will use all memory available to it?

Bob

Find more posts tagged with

Accepted answers

All comments

chad.every

@LegalAid , MSSQL is designed to consume all available memory on the server. So on a good note, it isn't an issue. There are several 3rd party links that walk through setting a max memory used setting in MSSQL. I bet you could drop things back to 32 GB and set the MSSQL memory max at minus 4-6 GB for the OS and you'd be fine with 500 nodes.

lynchnigel

If you can run the database on a separate server even better and just use the server as a application server. So basically are you monitoring the infrastructure that the VM is sitting on? so if that infrastructure goes belly up?

romeo-donca

please check this official SOlarwinds documentation regarding SQL server
SQL Server configuration best practices for SolarWinds Platform products

Regarding how to configure Memory, please check this link
The SolarWinds SQL Server shows all the Server's RAM being used by the SQL service

Regarding your question about DB maintenance, here you will get all needed details
Database maintenance in the SolarWinds Platform

Best regards

Romeo