I/O! I/O! It’s off to disk we go... - SQLBits goes Forth - 28 Mar 2009

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. Or, if your browser does not support JavaScript, click here.

Session Details - I/O! I/O! It’s off to disk we go...

You’ve issued your select query – the data isn’t in memory and so you’ve got to go to disk to get it. There are no dwarves to help you so the question is - How is this satisfied? What exactly is read-ahead? Does the edition you have installed affect how this is performed? Does partitioning alter anything? That’s just the half of it – there’s writes to talk about too. Understand the fundamentals of SQL Server I/O in this one hour practical session.

James Rowland-Jones

James is an Advisory Consultant at EMC Consulting. His focus has been the development and technical direction of major, mission-critical, pan-European projects in the enterprise. His experience includes data and system architecture, information analysis, logical and physical database modelling and design, highly available implementations, ETL process architecture and client tools implementations including a number of major bespoke applications. He has worked in IT since 1998 and with SQL Server since 6.5.