This section is intended for System Administrators. It provides information about configuration, tuning, trace flags, backup and recovery, and security issues.
The System Administrator or database owner may elect to use the server in such a way as to optimize performance or to allow use by a required number of clients. Configuration choices might involve being able to review total numbers of reads and writes for a given SQL command.
Once an application is up and running, the System Administrator should monitor performance and may choose to customize and fine-tune the system. The server provides tools for these purposes. This section explains:
Changing system parameters with the sp_configure procedure
Using update statistics to ensure that Component Integration Services makes the best use of existing indexes
Monitoring server activity with the dbcc command.
Setting trace flags
Executing ddlgen and related backup and recovery issues
Determining database size requirements