Printed 2017/07/21 07:31AM

Storage options available in Windows for SQL Server


There are several options available for configuring your storage media in Windows Server 2003 and Windows Server 2008. By understanding your storage options will help you to make informed decisions about SQL Server system configuration and data storage. In this blog post we will first take look at what Software and Hardware options are available for configuring your storage media in Windows 2003 Server and Windows Server 2008 and then I will be detailing the performance guidelines on how to physically distribute your database files on storage media to achieve best performance.

Software Options:

Microsoft Windows 2003 Server and Windows Server 2008 products provide you following options for configuring your storage media:

Hardware options:

You also have the option of using hardware-based disk subsystems for disk storage. Though more expensive, this solution typically provides better performance. One reason for this is that software-implemented RAID configurations place additional overhead on the system processor. You can choose from:

Remember the following about Hardware Storage options:

Performance guidelines to improve SQL Server database engine performance:

To tune database performance, you must have an understanding of your tables, indexes, and application requirements because where you place files can directly impact your server’s performance. Some recommendations for improving performance are listed as follow:

Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.