Think you’re too busy to regularly maintain your database? You might want to think about that again. As different users access the database, files can become fragmented, misplaced, and degraded. Security may become an issue. As a result, the database can become painfully slow or even corrupted.
Running maintenance on your database does the following:
All of these actions help your database run more efficiently. Summarizing and cleaning up data make your database smaller. Highly fragmented indexes really degrade database performance, so when you know you’ve got a fragmented index, you can defragment it. And knowing that you’ve got security issues means that you can tighten up your security settings.
To find out more about Orion database maintenance, check out the SolarWinds Product Blog and the SolarWinds Technical Reference: Best Practices for Managing the Orion Platform Database. For answers to specific issues, see the SolarWinds Knowledge Base, for articles like NetFlow Database Maintenance or Critical Index Fragmentation Detected During Database Maintenance.