Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
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