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...
📚 ►Full course on Troubleshooting sessions: • Troubleshooting
📷 ►Follow me on Instagram - arslanov_bo...
🧑💼►Follow me on LinkedIn - / bobirmirzo-arslanov-54...
Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server- • Full course on Encrypt...
🚀 ►SQL Server replication session: • SQL Server replication
🚀 ►SQL Server Always On Availability Group: • SQL Server Always On A...
🚀 ► SQL Server internals: • SQL Internals
🚀 ► Course in On-memory OLTP: • Course on In-Memory OLTP
26 июн 2024