Part 2: SQL Server I/O system performance and troubleshooting PAGEIOLATCH

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 - Troubleshooting scope 2:36 - Step 1: Investigate waits in SQL Server and confirm I/O related waits 5:28 - Step 2: Run performance monitor and check I/O related metrics 12:17 - Step 3: Run storport traces and check performance 🚀►Source code: https://github.com/Bobirmirzo/IOTroubleshoot/blob/main/pres.txt 📚 ►Part 1: https://youtu.be/AievhIhGBdY?si=svKy7pRo5dV4Jfsx 📚 ►Full course on Troubleshooting sessions: https://youtube.com/playlist?list=PLxuuX6jGq7kmlUblaWyfIh-iT5r0EWrJX&si=gC5FAhH9i6_b0waY 📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_boburmirzo?igsh=OGQ5ZDc2ODk2ZA%3D%3D&utm_source=qr 🧑‍💼►Follow me on LinkedIn - https://www.linkedin.com/in/bobirmirzo-arslanov-548960173 Watch all my playlists here: 🚀►Full course on Encrypting connections to SQL Server- https://youtube.com/playlist?list=PLxuuX6jGq7kmqOCqYa1lFxQOKFgTfb8j8&si=bBwHhLsu6m5CjFft 🚀 ►SQL Server replication session: https://youtube.com/playlist?list=PLxuuX6jGq7km5E54qm0zc7REGXw6WD4C8&si=fQ_PVoGQ1S8SeI6X 🚀 ►SQL Server Always On Availability Group: https://youtube.com/playlist?list=PLxuuX6jGq7klnjr9OIGt8R1SN76pQzuEB&si=zZVr_sJnc7I9H8d3 🚀 ► SQL Server internals: https://youtube.com/playlist?list=PLxuuX6jGq7kk5_OkxbZ8QDZ2HFBDy2XZ2&si=U2rRfgS2y87t5SU4 🚀 ► Course in On-memory OLTP: https://youtube.com/playlist?list=PLxuuX6jGq7kmt6gfHUW5KhfXGaoSiDXOB&si=fVS1s2L6If36Zg-r