Databases Reference
In-Depth Information
Best Practice for Storage Configuration
BEFORE starting any performance or stress testing, you should always ensure you
have the very latest firmware and drivers for every component in your storage stack.
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 perfor-
mance, 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.
Search WWH ::
Custom Search