12.4. Summary
This chapter started by discussing the importance of measuring storage performance. You looked at the different metrics you might want to monitor, looked at different tools available to measure I/O performance, then looked in detail at measuring performance using SQLIO. Then you looked at SQLIOSim and how you can use this tool to measure storage robustness and reliability. Finally, you recapped the best practices introduced through the chapter.
In the next chapter, you will look at the SQL Performance Dashboard, and see how to use this exciting new tool to capture key performance information.
Get Professional SQL Server® 2005 Performance Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
