Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
This guide will help you address the most common questions and issues related to the Orion database performance check and configuration without using SolarWinds Database Administrator (DBA).
This guide will help you address the most common questions and issues related to the Orion database performance check and configuration without using the SolarWinds Database Administrator (DBA).
These questions include:
Before you make any changes in your environment, create a full backup of your Orion database. See the SolarWinds video Backing Up, Restoring, and Migrating Your Orion Database for details.
The following questions provide links to resources that can help you resolve your database setting and configuration issues.
SolarWinds Log & Event Manager is an optional security information and event management (SIEM) appliance for more demanding environments. The appliance uses logs for security, compliance, and troubleshooting. You can create and customize widgets to display critical events across your IT environment and monitor file activity for potential data theft.
After you complete these procedures, you must reduce your Orion Database size to reclaim free unused space in the database. This will reduce the database size and improve your database performance.
Check the location of your Orion database file directories and ensure they are not stored on a single disk.
The minimum SQL Server hardware requirement for a production environment is a 3GHz, Dual Core processor or better. This configuration is appropriate for all licenses.
Do not use less than a 2GHz processor for any Orion SQL database server.
For best practice, configure your SQL database server components in a RAID configuration, as listed below.
|Operating System||2X RAID 1 (Mirroring) disk|
|Database files|| |
4X RAID 1+0 (Striping and mirroring) with separate partitions for the data and log files
|Page file||2X RAID 1 (Mirroring) disk|
|Ad hoc components|
Orion installations on VMware Virtual Machines and Microsoft virtual servers are fully supported if the minimum configuration requirements are met for each virtual machine. See "Requirements for Virtual Machines and Servers" in the Network Performance Monitor Administrator Guide for details.
SolarWinds strongly recommends that you maintain your SQL Server database on a separate physical server.
See Plan your production deployment for additional details.