Part 1: SQL Server I/O system performance and troubleshooting
These two sessions are dedicated to sharing how to troubleshoot I/O issues when you face slow performance due to slow I/O subsystem in SQL Server.
In part 1, I will share how I/O system is built in Windows. This works as a fundamental knowledge required for troubleshooting I/O performance in SQL Server.
In part 2, I will share how to troubleshoot I/O issues in SQL Server with real examples.
Chapters:
0:00 - Introduction
1:20 - I/O system components in Windows (high level)
2:36 - I/O system components in Windows (more detailed)
Windows I/O related API functions
Windows I/O related NtDLL functions
I/O manager and IRP
Drivers
7:53 - I/O components in SQL Server
📚 ►Part 2: • Part 2: SQL Server I/O system perform...
📚 ►Full course on Troubleshooting sessions: • Troubleshooting
📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_bo...
🧑💼►Follow me on LinkedIn - / bobirmirzo-arslanov-548960173
Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server- • Full course on Encrypting connections...
🚀 ►SQL Server replication session: • SQL Server replication
🚀 ►SQL Server Always On Availability Group: • SQL Server Always On Availability Gro...
🚀 ► SQL Server internals: • SQL Internals
🚀 ► Course in On-memory OLTP: • Course on In-Memory OLTP