Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.