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 is a SQL Server Consultant and Microsoft MVP. His focus and passion is to architect and deliver highly scalable database systems that are creative,simple and elegant in their design. He has worked for some of the worlds largest institutions and been responsible for project delivery across EMEA. James has worked on both OLTP and BI/data warehouse engagements and latterly has been spending a lot of time working on SQL Server reference architectures and appliances including Fast Track and PDW.
James is a keen advocate for the SQL Server community both internationally and here in the UK. He is a member of the SQLBits Organising Committee and co-founder of SQLSocial.com. Recently James was appointed as a Board Advisor to PASS. He is charged with providing an international perspective to the board across a wide variety of matters but primarily to assist the PASS community grow internationally.
You can find James on twitter @jrowlandjones
The video is not available to view online.
- Session Files Explorer
The network name cannot be found.