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.

Click below to register.

 https://www.clicktoattend.com/invitation.aspx?code=139182