Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Optimizing Utility and Tool Performance

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.

Community Additions

© 2015 Microsoft