Database Maintenance
The primary tasks that are available for maintaining a SQL database are data
summarization and database compaction. Data summarization occurs automatically
as a part of the nightly maintenance program. You can also run database
maintenance on demand from the Windows Start menu.
See: Running Database Maintenance
Running Database Maintenance
Database maintenance performs a series of data summarizations that help you
optimize the size of your Orion Platform database. Data summarization consists of
gathering all the collected network data for a defined period of time, calculating
statistics from the data, and then discarding the data itself while retaining the
statistics. By regularly running database maintenance, you can realize significant
space savings and performance improvements.
Database maintenance can either be run directly from the Start menu, or scheduled
for a set Archive Time and initiated from the Polling Settings view in the Orion Web
Console. In either case, once started, database maintenance normally proceeds
without further attention. For more information about setting the Archive Time for
database maintenance on the Polling Settings view, see "Orion Platform Polling
Settings" The following procedure provides the steps to perform Database
Maintenance:
Note: Administrative privileges are required to run Database Maintenance.
To run the Database Maintenance utility:
1. Click Start > All Programs > SolarWindsOrion > Advanced Features > Database
Maintenance.
2. Then click Start.
323
Database Maintenance
To Next Page
Loading...