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

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.

Find more posts tagged with

Status: None

Comments

stek0

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)