Submit a ticketCall us

AnnouncementsCome see SolarWinds at VMUG Frankfurt

SolarWinds is delighted to attend the upcoming VMUG which will take place at Kap Europa in Frankfurt on June 19th, 2018.

See event details.

Home > Success Center > Network Performance Monitor (NPM) > Configuring multi-threaded database maintenance

Configuring multi-threaded database maintenance

Table of contents

Updated: 4-4-2017

Overview

Solarwinds Database Maintenance can be run with multiple threads. This article provides information to set this up.

Environment

  • Orion SQL database
  • Orion Platform

Steps

In the Orion SQL database, configure the setting in the dbo.Settings table:

 

 

You can change this value using the following query for 4 threads (max is 8):

update settings
set CurrentValue='4'
where settingid='SWNetPerfMon-Settings-MaxMaintenanceThreads'

 

Important: Too many threads can pose a performance risk for some SQL servers.

 

 

Last modified

Tags

Classifications

Public