Back to Browse

Professionally troubleshoot high CPU utilization in SQL Server

7.7K views
Premiered Jun 3, 2024
25:11

Sudden CPU spikes often cause performance issues in SQL Server. In this session, I share some effective troubleshooting techniques to troubleshoot high CPU utilization by SQL Server. Chapters 0:00 - Recommended sessions 1:00 - Troubleshooting Step 1 3:05 - Troubleshooting Step 2 5:41 - Troubleshooting Step 3 7:50 - Live demo: Case 1 8:40 - Live demo: Case 2 10:44- Live demo: Case 3 14:33-Live demo: Case 4 18:20-Live demo: Case 5 📚 ►Previous recommended sessions: 1. https://youtu.be/zN8VyLZvhQc 2. https://youtu.be/3mGq9AJUFiA 3. https://youtu.be/7i6ZVgqAEAs 📚 ►Queries used: https://github.com/Bobirmirzo/highCPU/blob/main/Commands.sql 📚 ►Full course on Troubleshooting CPU Spike in SQL Server: https://youtube.com/playlist?list=PLxuuX6jGq7kmDoqafhow70kQH2l8Z_Xm0&si=lIrrZo_cqj-YYQBy 🧑‍💼►Follow me on LinkedIn - https://www.linkedin.com/in/bobirmirzo-arslanov-548960173 Watch all my playlists here: 🚀►Full course on Troubleshooting sessions: https://youtube.com/playlist?list=PLxuuX6jGq7kmlUblaWyfIh-iT5r0EWrJX&si=gC5FAhH9i6_b0waY 🚀►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

Download

1 formats

Video Formats

360pmp432.9 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Professionally troubleshoot high CPU utilization in SQL Server | NatokHD