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

Orion NPM Memory Leak?

My server slowly chews up memory as the day goes on. Orion NPM is the only application that is installed on the server. Has anyone else have or had this problem. Server is really slow, 2.4G processor, with 2GB RAM.

Find more posts tagged with

Accepted answers

All comments

RyanJett

bgraver,

Is the MSDE version of SQL (the version that ships with Orion) installed and running on this server also? If so, this could be what is taking all the RAM. This Knowledge Base entry explains how to limit the amount of RAM the MSDE version of SQL can use:

support.solarwinds.net/.../ProblemDetail.cfm

If SQL is not installed on this server, what process is taking all of your memory?

Ryan Jett
SolarWinds.Net
918-307-8100

CCrew

I'm not seeing it in my configuration, which is Orion on the front end talking to a MSSQL database machine behind it. Running 473 nodes at the moment, with some polling as short as 30 seconds.

Some more information on your configuration may be helpful so that others can jump in, like version, number of nodes, SQL or MSDE, etc.

Regards,
Roger

bgraver

This is what the problem was with the SolarWinds Software using up the memory on the server. The below knowledge base article is correct, but you need to type an additional command as I have shown below to enable the advanced options, otherwise you get and error message that the max server memory does not exist, or may be an advanced option.

Knowledge Base Detailed Resolution

Category:
Orion Network Performance Monitor Ver. 7.x

--------------------------------------------------------------------------------

Question:
Why does SQL Server use all available memory?

--------------------------------------------------------------------------------

Resolution:
This entry applies only to SQL installations that are on the same server as Orion.
By default, SQL utilizes all available memory. You can alter this behavior by running a query. The following query will instruct SQL to limit it's memory usage to 400MB.

use master
EXEC sp_configure 'max server memory', '400'
RECONFIGURE WITH OVERRIDE

To run the query do the following:
1. Launch the Database Manager
2. If you do not have your SQL Server listed, add it now using Windows NT Integrated Security.
3. If your SQL Server is already listed, right-click and select "Remove Server from list", then add the server again using Windows NT Integrated Security.
4. Drill into the server until you see the tables listed.
5. Double click on any table.
6. Click the Query button.
7. Replace the default text with the query above, changing 400 to meet your needs.
8. Click the Refresh button to execute the query.

If you have any questions or concerns about SQL, please refer to Microsoft.

Enable advanced options:

USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE

Set the maximum amount of memory to 64 MB:

USE master
EXEC sp_configure 'max server memory (MB)', 64
RECONFIGURE WITH OVERRIDE

Display the newly set configuration:

USE master
EXEC sp_configure 'max server memory (MB)'

Set 'show advanced options' back to default:

USE master
EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE

Thank You for the fast replies and the help!

Brian