Microsoft KB Archive/196911

= INF: Database Creation and Backup Operations Use Parallelism =

Article ID: 196911

Article Last Modified on 2/23/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q196911



SUMMARY
The ALTER DATABASE statement uses parallelism to extend each file on a distinct logical drive. Likewise, the BACKUP DATABASE statement uses a separate thread per logical drive. Although this is a useful performance feature in certain circumstances, it does not mean that creating many logical drives is generally preferred over combining those drives in a RAID array. SQL Server uses asynchronous I/O and can usually leverage all available I/O capacity in a multi-disk RAID array. Combining most available drive spindles to a large RAID array (of the appropriate type) often provides the best performance over the broadest circumstances.

Additional query words: box machine drv seperate

Keywords: kbinfo KB196911

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.