The ca_dbmgr maintenance options allow you to tune and maintain the database in an efficient state and a manageable size. By periodically performing these maintenance tasks you can improve the overall performance of the CA ARCserve Backup database.
The results of the maintenance tasks will be saved to a special maintenance log called SQLMaint.log, which is located in the CA ARCserve Backup LOG directory.
The ca_dbmgr command includes the following maintenance options:
ca_dbmgr [-cahost <host>]
-maintenance
[UpdateStatistics] [ReBuildIndex] [CheckIntegrity] [ReduceDBSize]
Updates the statistics on all the tables and indexes in your database.
SQL Server collects statistics about the distribution of data in tables and indexes and uses these statistics to determine which indexes to use during a query process. If the statistics are outdated, SQL Server might not be able to properly evaluate which indexes to use when executing a query and as a result, might choose to perform a time-consuming scan of a complete table instead of just scanning an index. Having up-to-date statistics is important to ensure effective use of indexes.
Recommended: daily
Rebuilds all indexes in your database to ensure that the data is not fragmented.
When you perform any data modification operations (insert, update, delete) table fragmentation can occur. When this data modification affects the index, index fragmentation can also occur and information in the index can get scattered in the database. Fragmented data can cause SQL Server to perform unnecessary data reads during a query process and result in slow and inefficient performance. The greater the fragmentation, the less effective the index will be. Periodically rebuilding the index will remove fragmentation, reclaim disk space, and improve overall performance during a database query.
Recommended: weekly
Checks the integrity of all objects in the CA ARCserve Backup database.
Databases can be corrupted by unusual events such as hardware failures, sudden loss of power, operating system failure, or improper operator action. It is important to periodically check the allocation, structural, and logical integrity of all objects in the CA ARCserve Backup database. Performing a database integrity check on a regular basis will detect and report any changes in the database that occurred since the last integrity check. Depending upon the size of your database, this can be a time-consuming task.
Recommended: weekly
Reduces the size of the data and log files in the CA ARCserve Backup database and releases them back to the operating system.
Over time, your log files and data files can grow rapidly to a very large size and reduce the effectiveness of your database. When you control database size, performance will often improve and more users can access the database.
When you run ReduceDBSize you will need to enter the name of the database you want to shrink, along with the percentage of free space to leave in each file of the database. For example, if you've used 60 MB of a 100-MB database file, you can specify a shrink percentage of 25 percent. SQL Server will then shrink the file to a size of 80 MB, and you'll have 20 MB of free space.
Recommended: as needed
| Copyright © 2010 CA. All rights reserved. | Email CA about this topic |