Storage Resource Manager Enterprise Edition Installation Guide

A–4 Storage Resource Manager Enterprise Edition
Database Concepts
Setup configures the SRM SQL Server database maintenance task as follows:
• Backup — Daily full backup of the SRM database to the default MSSQL backup
directory (for example, Mssql\Backup).
— No transaction log backups
— Truncate log on checkpoint option set
— Backups are retained for one week
• Statistics Update — Daily statistics update.
• Database Consistency Checking — Daily database consistency checking.
• Rebuilding Indexes
— Daily rebuild of indexes using original FILLFACTOR specification
— The maintenance task is named SRM Maint SRMDB_SRM server computer
name and by default runs daily at 1:15 a.m.
By default, SRM runs detailed file scans at 2:00 a.m. Because it is difficult to predict
how long a detailed file scan will take to complete, make sure to schedule the
maintenance task to run before the detailed file scan if you alter the file scan or
maintenance task run-time. This ensures that the database backup will not interfere
with the file scan.
A second task called SRM MaintS SRMDB_SRM server computer name is created to
refresh the optimizer statistics hourly at 20 minutes before the hour. SRM’s query
optimizer determines the quickest way to run each query based on an estimated
number of Input/Output calls.
Database Configuration
Read this information only if you must manually create a database for SRM to use.
Creating an SQL Server database prior to SRM installation is optional. SRM
installation creates and configures a default database that you can later modify using
the SQL Server Enterprise Manager.
If you are unfamiliar with creating and configuring SQL Server databases, consult
your Microsoft SQL Server documentation or your database administrator. This
section contains SRM SQL Server database configuration requirements and
guidelines that are applicable to SQL Server 7.0 databases; it does not explain how to
create the database.