General IO characteristics of common scenarios:
Note: If you buy something from our links, we might earn a commission. See our disclosure statement.
Table of Contents There is no one single “right” way to configure storage for optimal performanceGeneral Performance Considerations:Performance – RAID LevelDesigning Storage Design for Optimal PerformanceDesigning Database Files/Groups for PerformanceManaging File Growth: There is no one single “right” way to configure storage for optimal performance
Table of Contents
SQL ConsiderationsBackup/restore – 1 thread per volumeFile initialization – 1 thread per volume
Backup/restore – 1 thread per volume
File initialization – 1 thread per volume
Two types of GROWTH
Comments are closed.