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.
Sorry, there are no downloads available for this session.
Kevin Kline is a renowned 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.
The video is not available to view online.