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.