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:

 

  • Summarizes data – Gathers all the collected network data for a defined period of time, calculate statistics from the data, and then discard the data and keep the statistics.
  • Cleans up data – Removes corrupted files, duplicate items, and data related to deleted records.
  • Discovers fragmented indexes – Identifies fragmented indexes so you can rebuild and/or defragment them.
  • Checks for security issues – Pinpoints issues that could compromise database security so you can fix them and avoid further problems.

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.