January 2008
Intermediate to advanced
575 pages
16h 10m
English
book
Professional SQL Server® 2005 Performance Tuning
by Steven Wort, Christian Bolton, Justin Langford, Michael Cape, Joshua J. Jin, Douglas Hinson, Haidong Ji, Paul A. Mestemaker, Arindam Sen
Content preview from Professional SQL Server® 2005 Performance Tuning
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
12.3. Storage Reliability
To help build your confidence in the robustness and reliability of your storage subsystem you need to run a stress test. There are a number of tools you can use for this. LoadSim and JetStress are I/O stress tools optimized for Exchange I/O patterns. IOMeter is another highly configurable open source I/O stress tool. This chapter focuses on the latest I/O stress test tool from Microsoft: SQLIOSim.
SQLIOStress is a tool written by the SQL Server support team. It was the preferred tool for stress testing SQL Server I/O, but has since been replaced by SQLIOSim.
12.3.1. SQLIOSim
SQLIOSim is a new I/O stress tool that simulates SQL Server 2005 I/O patterns. It was written by the SQL Server engine team and is based upon the same code that SQL Server uses for its I/O. Like SQLIOStress, SQLIOSim doesn't require SQL Server to be installed to run and is a standalone stress test tool.
SQLIOSim is the I/O stress test tool of preference for stress testing an I/O subsystem that's going to be used with SQL Server.
12.3.2. Using SQLIOSim
The first step is to download the tool from the Microsoft download center. The starting point for this is to find the related KB article. Currently this is 231619 and is located at http://support.microsoft.com/kb/231619.
After downloading the appropriate msi and installing it to your favorite location (here: c:\tools\sqliosim) the next step is to figure out how to run it, and how to get it to test the disks you want tested.
There are ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.