Sunday, March 1, 2009

Microsoft SQL Server on SAN Best Practices from SQL CAT


Disk I/O: Microsoft SQL Server on SAN Best Practices from SQL CAT's Mike Ruthruff (& Prem Mehra)

While at the PASS Community Summit in November 2008, I had the pleasure of attending a handful of excellent presentations.  One of the best was one delivered by Mike Ruthruff (& not just because he shilled for my presentation on disk partition alignment later that day—though I suspect he contributed to my session being SRO).

Mike is a member of the SQL Server Customer Advisory Team (SQL CAT).  He authored the deck with contributions from SQL CAT patriarch Prem Mehra.

Most of you probably know Mike because he is the primary author of the landmark white paper we all know-&-love & have read over-&-over again because we know how unbelievably valuable it is:

SQL Server Predeployment Best Practices

Mike has provided a copy of his latest-&-greatest deck for publication here:

Microsoft SQL Server on SAN Best Practices

The deck includes the following:

  • Characteristics of SQL Server I/O operations
  • Best practices
    • SQL Server Design Practices
    • Storage Configuration
    • Common Pitfalls
  • Monitoring performance of SQL Server on SAN
  • Emerging Storage Technologies
  • Additional Material In Appendix Section (not covered during session)
    • How to validate a configuration using I/O load generation tools
    • General SQL Server I/O characteristics
    • How to diagnose I/O bottlenecks 
    • Sample Configurations

I think you'll enjoy this deck—one of the best, perhaps the best of its kind ever assembled.  ¡Yo!  Why would a bother posting a second-rated presentation?  Besides which, SQL CAT does nothing but the best.  Get ready to be wowed by 50 slides of geekly goodness. 


Senior Performance Consultant: SQL Server
A.C.E.: Assessment Consulting & Engineering Services
Microsoft: Change the world or go home.

This post was written with the plugin for Windows Live Writer

Published 01 March 09 11:44 by Jimmy May

Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, Productivity, etc. : Disk I/O: Microsoft SQL Server on SAN Best Practices from SQL CAT's Mike Ruthruff (& Prem Mehra)

1 comment:

daspeac said...

I think you have already heard about the access data repair tool

Blog Archive