SQL Server I/O Performance: Size Matter!

Disk I/O performance is always a critical aspect of a SQL Server system. In this meeting, Linchi will cover the key parameters and metrics you must evaluate when you review the SQL Server disk I/O performance. The focus, however, is on the fundamental principles underlying efficient disk I/Os, how SQL Server optimizes its disk I/Os on these principles, and how you can take advantages of them in your disk I/O performance tuning efforts. More specifically, Linchi will dive into discussions on random I/Os vs. sequential I/Os, and discuss why disk I/O size is a critical factor in all SQL Server disk I/O evaluation.

Linchi has been working with SQL Server since version 4.21a. He is most interested in automating database management in an enterprise environment, and enjoys troubleshooting performance issues. Linchi is a SQL Server MVP, and is active in various local and online SQL Server communites. He can also be found on sqlblog.com checking out SQL Server via empirical data points.