Contents

Introduction

1. Know When and How Your Storage Changes

2. Backup Times Are the Canary in the Coal Mine

3. Investigate with Performance Monitor Counters

% Disk Time

Average Disk Sec/Read and Sec/Write

Average Disk Queue Length

Average Disk Read/Sec and Write/Sec

4. Build a Relationship with the SAN Team

5. Virtualized Storage Can Be Our Worst Enemy

6. Virtualized Storage Can Be Our Best Friend

7. Shared Spindles Aren't Easily Predictable

8. Volume Alignment and Allocation Size Add Speed for Free

9. Storage Adapters Can Be Cheap Upgrades

10. Stay On Top of New SQL Server Features

11. But Wait — There's More!

Conclusion

About the Author

About Quest Software, Inc.

Contacting Quest Software

Contacting Quest Support

Oracle Whitepapers - Ten Things DBAs Need to Know About Storage Index