Disk IO Tuning for Microsoft SQL Server Newbie

Tuning disk subsystems for optimal SQL Server performance is typically the domain of very experienced, enterprise DBAs.  It normally requires years of experience the hard disk subsystem to learn exactly what configurations perform best, provide the greatest fault tolerance, and allow for the most scalability.  This session removes the need for those years of experience by answering questions like:


-       How does RAID compare to SAN, hard disk to SSD?

-       What is needed to properly monitor and tune the performance of my disk subsystem?

-       How do I tune my SQL Server for improved IO performance?


Configuring hardware can be very intimidating, especially when the application needs to scale. Learning the best practices, tips and techniques described in this session will help you avoid costly mistakes and serve as the foundation for the long-term success of your SQL Server environment.


Prerequisites: Basic understanding of hardware. Knowledge of Windows operating systems and SQL Server file concepts.

Presented by Kevin Kline at SQLBits IX
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO

    Kevin Kline is a noted database expert and software industry veteran currently serving as the Director of Engineering Services at SQL Sentry, a leading vendor of database and business intelligence tools. A Microsoft SQL Server MVP since 2003, Kevin was a founding board member and former president of PASS. He has written or co-written twelve books including the best-selling SQL in a Nutshell. Kevin contributes monthly column to DBTA magazines. Kevin is a top-rated speaker at conferences worldwide. He is on Twitter, Facebook, and LinkedIn at @kekline and blogs at Blogs.SQLSentry.Com

    http://KevinEKline.com http://feeds.feedburner.com/KevinEKline
  • Video
    The video is not available to view online.