Is there a way to make this an alert so I actually see the message vs accidentally seeing it in the events?
Is there a way to make this an alert so I actually see the message vs accidentally seeing it in the events?
Yes, there is a way:
"To enable automatic index defragmentation on the SQL Server hosting your SolarWinds
database:
1. Using SQL Server Management Studio, log in to your SQL Server using an account with sysadmin
privileges.
2. On your SQL Server, open SQL Server Management Studio (click Start > All Programs >
Microsoft SQL Server > SQL Server Management Studio).
3. Using an account with the sysadminrole, log in to the SQL Server instance hosting your SolarWinds
database.
4. Click + to expand Databases > YourSolarWindsDatabase > Tables.
5. Click New Query.
6. Enter the following query in the query field:
UPDATE dbo.Settings SET CurrentValue = 1 WHERE SettingID LIKE 'dbm-defragmentation-enabled%'
7. Click Execute."
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.