SQL Server Storage Engine under the hood

Speaker: Thomas Grohser

Duration: 60 minutes

Track: Admin

How SQL Server performs I/O

How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's  synchronous and what impact does that have on our queries and DML statements. SQL Server uses a series of different IO patterns depending on the workload. This session looks at them one by one and shows the difference and how to best optimize for it.
Which impact have features  like database mirroring and replication, what's different when SQL Server is starting up.
Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one.  Which files can be placed on the same volume and which should not.

Accompanying Material

Back to Top