Published: June 5, 2007
Writer: Mike Ruthruff
Contributors: Michael Thomassy, Prem Mehra
Technical Reviewers: Robert Dorr, Stuart Ozer, Juergen Thomas, Lindsey Allen, Burzin Patel, Bill Emmert, Bruce Worthington, Sanjay Mishra
One of the key components that affect the performance of Microsoft® SQL Server™ is the I/O subsystem. When configuring a new server for SQL Server or when adding or modifying the disk configuration of an existing system it is good practice to determine the capacity of the I/O subsystem prior to deploying SQL Server.
This paper provides guidance for validating and determining the capacity of an I/O subsystem. A number of tools are available that can be used to perform this type of testing. The focus of this paper is on the SQLIO.exe tool. However, we will contrast and compare all of the available tools. Much of the information in this white paper is in the document that is included with the download of the SQLIO tool; however, this white paper includes updates to existing information and additional information, including basic I/O configuration best practices as related to SQL Server based on recent learnings.
Included in this paper:
Link to the complete whitepaper: Predeployment I/O Best Practices.
Building and Deploying Large Scale SQL Server Reporting Services Environments—Technical Note Series Authors
Als eine meiner letzten Aufgaben während der 6 Wochen in Redmond habe ich mich etwas intensiver
Authors: Thomas Kejser, Denny Lee Contributors: Runying Mao Technical Reviewers: Burzin Patel, Kevin
Following are the links specifically relating to best practices for setting up disk I/O for SQL Server
Pingback from Top 10 SQL Server Integration Services Best Practices - .NET Explored
Die zehn besten SQL Server Integration Services-Methoden Autoren: Thomas Kejser, Denny Lee Mitwirkende
How to Specify SQL Storage Requirements to your SAN Dude
by Denny Lee As many of you know from the various blogs, whitepapers, and conferences from SQLCAT, there
Pingback from Why the obsession with random I/O within the context of SSAS? « Denny Lee
Pingback from Why the obsession with random I/O within the context of SSAS? - MSDN Blogs
Pingback from Tools for Sql server | Vinay Thakur – Sql Server DBA
Pingback from Top 10 SQL Server Integration Services Best Practices | devblogging.com