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

SQL Server 2000

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 can be used to fine-tune performance.

© 2015 Microsoft