Storage Resource Manager Enterprise Edition Installation Guide

Storage Resource Manager Enterprise Edition A–3
Database Concepts
• Managed Directories: The number of directories that you designate as managed.
The history for these directories is kept in addition to what is kept for the user and
domain history settings. The default is 100.
• Days of User History: The maximum number of daily records of user group
history you want to store in the database. The default is 180.
NOTE: This number correlates to the setting you specify in the User Level History Depth
Setting field of the History Depth Report Setting using SRM’s Reports Summary option. Setting
this value in the database sizing tool does not set this value in the Reports Summary option.
You must set that value separately.
• Days of Domain History: The maximum number of daily records of domain
history you want stored in the database. The default is 180.
NOTE: This number correlates to the setting you can specify in the Domain Level History
Depth Setting field of the History Depth Report Setting using SRM’s Reports Summary option.
Setting this value in the database sizing tool does not set this value in the Reports Summary
option. You must set that value separately.
• File System Report Size: The maximum number of files you want to keep track
of for the File System Report Size settings. The default is 20.
NOTE: This number correlates to the three File System Level Settings you can specify in the
Report Size Report Setting using SRM’s Reports Summary option. Setting this value in the
database sizing tool does not set the values in the Reports Summary option. You must set those
values separately.
• SRM Size: The estimated maximum size, in MB, of your initial SRM SQL
database. This value represents only your SRM data. The default is 198.
• Calculated Database Size: The estimated maximum size, in MB, of your initial
SRM SQL database. This number is calculated based on the values you entered in
the fields above, and changes dynamically as you make changes in those fields.
The default, calculated from the default values, is 198.
Database Maintenance
You can configure your SQL Server SRM database before installing SRM, or you can
use the SRM installation’s default maintenance configuration. Whichever option you
use, you can always reconfigure your SRM database maintenance task any time after
installation using the SQL Server Database Maintenance Wizard.
Using the SQL Server Database Maintenance Wizard creates two new maintenance
tasks. You must first delete the existing SRM maintenance tasks and then create the
new ones. Although you can give your new maintenance tasks any name, if you do not
name them SRM Maint SRMDB_SRM server computer name and
SRM MaintS SRMDB_SRM server computer name, SRM’s Uninstall utility cannot
locate them for deletion.