SQLIO 관련 페이지

출처는 링크로

SAN Performance Tuning with SQLIO

• Stable page
• Draft
• Discussion
• draft source
• History

SQLIO is a free utility from Microsoft that measures storage IO performance. The name "SQLIO" is horribly misleading, because it doesn't really have anything to do with SQL Server. Contents [hide] 1 SQLIO Video Tutorial 2 Downloading and Configuring SQLIO 3 Testing Your SAN Performance 4 Importing SQLIO Results into SQL Server 4.1 Script to Create the Tables and and ETL Stored Procedure 4.2 Importing the Text File into SQL Server 2005 5 Analyzing the SQLIO Results 6 More Reading About SQLIO SQLIO Video Tutorial In this ten-minute video, Brent Ozar explains how to get started with SQLIO, how to create a batch file to test your SAN, and how to analyze the results.

http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO

Benchmarking SQL Server IO with SQLIO

Written By: Andy Novick -- 10/4/2010 -- read/post comments -- print --  

Rating:  Rate 

Win a Kindle with 5 SQL Server eBooks

Problem
During a recent SQL Server install everything seemed to go fine.  SQL Server 2008 R2 went in with no problems.  There was a local drive with a RAID 1 set for the OS and system databases and two direct attached RAID 5 sets; one for transaction log files and one for data files.  Was everything okay?  Could it be better?  How could I tell?  In this tip we look at how to maximize your IO throughput.

Solution
There are many factors that go to make up the performance of SQL Server: CPU, RAM, disk I/O performance and, most importantly, the T-SQL code and queries.   The Control Panel Device Manager tells you how fast the CPU's are, how much memory is available and the memory speed.  The performance of queries is very important, but that's the subject of numerous other articles.  It's easy to tell the size of the disk, but not so easy to understand how many I/O operations the disks are capable of achieving.  The variety of technologies, such as controllers, HBA's, SAN's, virtualization and iSCSI, that can be employed between the Windows operating system (OS) and the physical drives is numerous and clouds any analysis based on the hardware specs.  

While disk drives are often purchased to provide the right amount of space, the I/O capacity of the drives is often neglected.  This leaves SQL Server in the unfortunate position of needing more I/O operations than the disks can provide.  The least that we can do is get the most out of the drives that we have and understand their capacity.  That's done with benchmarking.

http://www.mssqltips.com/tip.asp?tip=2127&sa=Search

SQL Server Best Practices Article

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

Applies To: SQL Server 2005

Summary: The I/O system is important to the performance of SQL Server. 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 white paper discusses validating and determining the capacity of an I/O subsystem. A number of tools are available for performing this type of testing. This white paper focuses on the SQLIO.exe tool, but also compares all available tools. It also covers basic I/O configuration best practices for SQL Server 2005.

On This Page

Overview 
Determining I/O Capacity 
Disk Configuration Best Practices & Common Pitfalls 
SQLIO 
Monitoring I/O Performance Using System Monitor 
Conclusion 
Resources 

http://msdn.microsoft.com/en-us/library/cc966412.aspx

SQLIO - tool to meausure IO performance on Microsoft SQL Server

Attached is the performance testing tool from Microsoft I mentioned that will give you a test on the number of IO’s that the Fusion-io ioDrive can do on an SQL database.  You can also use it as a tool for multiple IO patterns for other types of database data patterns.

 

Unzip the attached sqlio.zip file in a directory on your hard disk drive. 

 

It will create a directory called SQL. 

http://kb.pixel.com.au/kb/index.php?View=entry&EntryID=10