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