Enable defragmentation for SolarWinds Database

On the Solarwinds server:

Open Database Manager
Start > All Programs > Solarwinds Orion > Advanced Features > Database
Manager
Add default server
Expand your database and right-click on any table.
Execute Query.
Click on the “Enable table editing” button (Results can be edited)
Clear the existing query and enter the following:

UPDATE Settings SET CurrentValue = 1 WHERE SettingID LIKE ‘dbm-defragmentation-enabled%’

and click on Execute Query.

Run Database maintenance
Start > All Programs > SolarWinds Orion > Advanced Features > Database Maintenance, and then click Start.

打赏 赞(0)
微信
支付宝
微信二维码图片

微信扫描二维码打赏

支付宝二维码图片

支付宝扫描二维码打赏

作者: Centro Sun

Maintainer,Engineer,Fixer

发表评论