Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Orion Platform > Orion Documentation > Optimization Guide > Optimization checklist for the Orion Platform

Optimization checklist for the Orion Platform

Created by Magdalena.Markova, last modified by Verwin Ubana on Oct 11, 2018

Views: 975 Votes: 1 Revisions: 5

Updated: December 4, 2018

This topic applies to all Orion Platform products.

The number of things to check is rather long, and so the items are divided into the following sections:

Check requirements

  What to check?
checkbox.gif

Does your Orion Platform server meet the hardware and software requirements?

Check the hardware of your Orion Platform server. To verify the Orion Server software, you can also click Settings > All Settings > Orion Platform Details in the Orion Web Console.

If you are running multiple Orion Platform products, make sure your environment meets the requirements for your environment size.

» Learn more

checkbox.gif

Does your SolarWinds Orion database server meet the hardware and software requirements?

For the Orion SQL Database details, click Settings > All Settings > Database Details.

» Learn more

checkbox.gif

Do the deployed Orion Platform products require an additional database?

If deployed Orion Platform products require an additional database, for example NTA, make sure the server hosting the database meets software and hardware requirements.

» Learn more

checkbox.gif

Do you have scalability engines, such as additional polling engines and additional web servers deployed?

Make sure your environment meets the requirements for your environment size.

» Learn more

checkbox.gif

Do you run multiple Orion Platform products?

If you are running multiple Orion Platform products, make sure your environment meets the requirements for your environment size.

» Learn more

checkbox.gif

Make sure you haven't overlooked any requirements, including:

Optimize the performance of polling engines

  What to check?
checkbox.gif

Are your polling engines healthy?

Click Settings > All Settings > Polling Engines, and review the values for polling completion and rate.

Polling completion should be 100% and polling rate should not exceed 85%.

If the general polling rate exceeds 85%, change polling intervals or distribute the polled nodes between your polling engines.

» Learn more

checkbox.gif

How many elements do you poll per polling engine?

Each polling engine can monitor up to 12,000 elements. If you reach 10,000 elements per polling limit, consider the following measures:

To troubleshoot:

  1. Find out how many polling engines you have deployed.
    1. Click Settings > All Settings > Polling Engines.
    2. Check the polling rate and polling completion for each polling engine.
      If the polling engine is getting overloaded, adjust polling settings.
  2. Check the number of elements in your license.
    1. Click Settings > All Settings > License Details.
    2. See how many elements you are monitoring and how many you still have in your license.
      If you're getting close to the license limit, upgrade the license.

» Learn more

checkbox.gif

Have you changed the default polling settings?

Click Settings > All Settings > Polling Settings and make sure you are using the default polling intervals:

  • 10 minutes for nodes
  • 9 minutes for interfaces
  • 15 minutes for volumes

You can also decrease the polling intervals to poll data less frequently or stop collecting data for some nodes.

» Learn more

checkbox.gif

Do you use agents as the polling method?

Check the agents: Click Settings > All Settings > Manage Agents.

You can have up to 1,000 agents per polling engine. If you have over 1,000 agents per polling engine:

» Learn more

checkbox.gif

Are you polling hardware health?

Verify the polling rate: Click Settings > Polling Settings > Polling Engines.

Ensure the hardware health polling rate is below 85% to ensure optimal performance of your system. If the polling rate is close to 85%, reduce the Default statistics polling interval for Hardware Health Polling to 10 minutes (default) or less.

» Learn more

checkbox.gif

Are you using Orion Maps?

Maps require collecting topology data. Topology data does not change very often.

  1. Set the interval for polling topology data to the default value. In Orion Platform 2017.3 and later, this is 120 minutes.
    Click Settings > All Settings > Polling Engines, and set Default node topology poll interval to 120.
  2. Decrease the frequency for calculating topology.
    1. In your web browser address line, paste /Orion/Admin/AdvancedConfiguration/Global.aspx after the hostname or IP address of your Orion Platform server.

      On the Global tab, type 20:00:00 as the TopologyCalculationFrequency.Topology data is now calculated every 20 hours.

» Learn more

checkbox.gif

Are you using Syslogs?

Orion Platform products can handle approximately 2-4 million syslog messages per hour, which is 555 - 1111 messages/second.

To monitor up to 1000 events/second, you can use Log Manager for Orion.

  • Be aware of the devices that send syslog messages:

    Click Reports > All Reports > Devices sending Syslog or SNMP Traps to Orion, and run the report.

  • Reduce how long syslogs are kept in the database:

    1. Click Settings > All Settings > Polling Settings.
    2. Set Syslog messages retention to 7 days or less.
    3. Run the Database maintenance. In case of big changes (such as from 90 to 7 days), Database Maintenance might affect the performance of your server.
  • Delete all syslogs:
    1. Back up your database.
    2. Run the following SQL query: Truncate Table Syslog
  • If you are not using Syslog rules, consider discarding them.

» Learn more

checkbox.gif

Are you using SNMP Traps?

Orion Platform products can handle approximately 1-2 million SNMP trap messages per hour, which is approximately 280-555 messages per second.

  • Be aware of the devices sending trap messages:

    Click Reports > All Reports > Devices sending Syslog or SNMP Traps to Orion, and run the report.

  • Find out which device is sending the most traps:

    1. Open the Database Manager, and run the following query to see 24 hours of traps data by host, traptype, and count.
       select hostname, Traptype, COUNT(trapid) as total from Traps
       where DateTime>DATEADD(day, -1, GETDATE() )
       group by hostname, traptype
       order by total desc, hostname, traptype
  • Disable traps

    If you are not using SNMP traps, disable them on devices or in Orion Platform products.

    Disable traps in Orion Platform products:

    1. Open Services, right-click the SolarWinds Trap Service, and stop it.
    2. Right-click the service, select Properties, and select the Startup type Disabled.
  • Reduce how long traps are kept in the database:

    1. Click Settings > All Settings > Polling Settings.
    2. Set Trap messages retention to 7 days or less.
  • Set up Alert/Filter rules to discard traps:

    1. Open the Trap Viewer and add a rule specifying traps to be discarded.
  • Delete all SNMP traps:

    1. Back up your database.
    2. Run the following SQL queries:
      Truncate Table Traps
      Truncate Table TrapVarbinds

» Learn more

checkbox.gif

Are you using Universal Device Pollers (NPM)?

NPM supports up to 10,000 UnDPs per polling engine.

  1. Check the number of UnDPs per polling engine: Click Settings > All Settings > Database Details.
  2. Click the Total elements per poller, and review custom node and interface pollers per polling engine.
  3. If there are more than 10,000 UnDPs per polling engine, scale your environment, or increase polling intervals to keep data for a shorter time.
    1. Click Settings > All Settings > Polling Settings, and make sure UnDP statistic retention settings are default or less (3 days for detailed, 14 days for hourly, and 180 days for daily statistics)

» Learn more

checkbox.gif

Are you using NetPath™?

You can add up to 100 paths per polling engine.

You can add 10-20 paths per probe.

  1. Check the number of probes per polling engine: Click Settings > All Settings > Database Details.
  2. Click the Total elements per poller, and review probes per polling engine.

To optimize:

  • Verify that your deployment meets NetPath requirements.
  • Distribute NetPath probes among polling engines.
  • Add additional polling engines.

» Learn more

Optimize the database performance

Database optimization tips

  • Retain the default polling and retention settings. Default settings are suggested so that new data are polled often enough and are kept long enough in the database to draw conclusions on issues in your network.
  • When configuring your SQL database, use the SIMPLE recovery model.
  • Store the data files and log files on different drives.
  • Do not allocate 100% of memory to MS SQL Server services. Allocating 75% should leave enough breathing room for the operating system.
  What to check?
checkbox.gif

Do you have enough space in the database?

Check the database size and the requirements!

» Learn more

checkbox.gif

What tables take most space in your database?

The largest tables are using the most resources and could be slowing your performance. Retaining data longer than necessary could slow down the database performance, the responsiveness of your Orion Platform products, and reports.

  1. Click Settings > All Settings > Database Details, and scroll down to Database Statistics.
  2. Check the polling and retention settings for the largest tables, make sure you are using default values.

If the largest tables are syslogs or traps, consider optimizing them.

» Learn more

checkbox.gif

Do you use default polling settings for all metrics?

Click Settings > All Settings > Polling Settings, and make sure the polling intervals and intervals for polling statistics are set to default values.

Metric Default detailed retention Default hourly retention Default daily retention
Node statistics 7 days 30 days 365 days
Container stats 7 days 30 days 365 days
Hardware health 7 days 30 days 365 days
Interface availability 7 days 30 days 365 days
Wireless 3 days 14 days 180 days
UnDP 3 days 14 days 180 days
Events 30 days
Syslogs and Traps 7 days

» Learn more

checkbox.gif

Is your database maintenance healthy?

  1. Make sure that the database runs outside of office hours.
    1. Click Settings > All Settings > Polling Settings.
    2. Set the Archive Time in the Database Settings section to be outside of your office hours.
  2. Find out how long the maintenance takes and troubleshoot tables that take long to maintain.

    The maintenance of a healthy database should take 5-30 minutes.

    1. Open the swdebugMaintenance.log at C:\ProgramData\Solarwinds\Logs\Orion\swdebugMaintenance.log.
    2. Compare the start and end time stamp, and search for tables where the maintenance gets stuck or takes a long time.

» Learn more

checkbox.gif

Aren't log files taking up too much space in your database?

Before you clean up log files, contact other teams in your organization that use Orion Platform products and get their approval.

  1. Clean up the orphaned log files:
    Run the following commands:
    del /f /q /s C:\programdata\solarwinds\*.log
    del /f /q /s C:\programdata\solarwinds\*.log.*
  2. Reset logging to default levels:
    Run the Orion Log Adjuster, click Reset to defaults, and click Apply.

» Learn more

Optimize the performance of your Orion Web Console

  What to check?
checkbox.gif

How many users are logged in the Orion Web Console at the same time?

If the number of users logged in simultaneously is close to 50, add an additional web server.

Run the following query in the Database Manager:

SELECT accountid, accountenabled, lastlogin
From [dbo].[Accounts]
order by lastlogin desc

» Learn more

checkbox.gif

What is the current performance of your Orion Web Console?

If the memory usage of yourOrion Web Console is close to or more than 650 MB, add an additional polling web server to distribute the load.

» Learn more

checkbox.gif

Is it just one Orion Web Console page that is slow?

  1. Find out which page is slow.
  2. Are there any charts with changed display settings on the page?
    1. Click Edit on the widget, and revert to the defaults.
  3. Do you have the AppStack widget on the page?
    1. Remove the AppStack widget from the view.
    2. Add AppStack to a new view.
    3. Add the AppStack view to My Dashboards.

» Learn more

checkbox.gif

Are you using custom queries in alerts and reports?

Be aware that each custom query represents an interaction with the database and should be as efficient as possible. If you use customized queries, consult your database administrator to find out possible impact on your system.

Last modified

Tags

Classifications

Public