Optimizing Utility and Tool Performance

Three operations performed on a production database that can benefit from optimal performance include:

• Backup and restore operations.
• Bulk copying data into a table.
• Performing Database Console Command (DBCC) operations.

Generally, these operations do not need to be optimized. However, in situations where performance is critical, techniques exist to fine-tune performance of each operation.

See Also

Concepts

Optimizing Backup and Restore Performance in SQL Server
Optimizing Bulk Import Performance
Optimizing DBCC CHECKDB Performance

Help and Information

Getting SQL Server 2005 Assistance