It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

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.

Kevin Kline is a noted database expert and software industry veteran currently serving is the Director of Engineering Services at SQL Sentry, a leading vendor of database and business intelligence tools. A Microsoft SQL Server MVP since 2004, Kevin was a founding board member and former president of PASS. He has written or co-written tweleve books including the best-selling SQL in a Nutshell. Kevin contributes monthly columns to SQL Server Pro and DBTA magazines. Kevin is a noted trainer and thought leader on IT leadership skills, database management technology and practices, and SQL Server performance tuning and optimization. Kevin is a top-rated speaker at conferences worldwide. He is on Twitter, Facebook, and LinkedIn at @kekline and blogs at http://KevinEKline.com.