cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Optimization of DB Scripts

Optimization of DB Scripts

It would be greatly appreciated if DB scripts could be optimized to not use all the available SQL memory.  Thank you.

in-memory tables like last time, the scripts need to be optimized so as not to use all available sql memory.in-memory tables like last time, the scripts need to be optimized so as not to use all available sql memory.in-memory tables like last time, the scripts need to be optimized so as not to use all available sql memory.in-memory tables like last time, the scripts need to be optimized so as not to use all available sql memory.in-memory tables like last time, the scripts need to be optimized so as not to use all available sql memory.

1 Comment
Level 9

Tell me if I'm wrong, but I disagree with this.

First because SQL Server needs memory for performance, and to get it clear: its not the scripts which are stored in the memory buffer cache, its the pages.

If the SQL Server service is taking to much memory, you can configure the maximum memory settings on the instance level.

And if you have issues with other databases in that instance, also remember that in SolarWinds Administration Guide it tells you that the SolarWindsOrion database should be on a separeted SQL Server.
(https://documentation.solarwinds.com/archive/pdf/orionplatform/OrionPlatform_AdministratorGuide.pdf)