Professionally troubleshoot high CPU utilization in SQL Server

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:

Watch all my playlists here:

[arslanov]

Hello Everyone. According to requests of some of you guys, prepared this session. I hope you find this useful. Sorry for being a little late!!

[saiainala]

Great session, very useful. Thank you so much

[arslanov]

Do not forget to refer to recommended sessions to fully master this session!

[roshanjohn]

Hi,
is it possible to spool the data in a file on Windows? we often get peaks around 11-11:30 am
$serverName = $env:COMPUTERNAME
$Counters = @(
("\\$serverName" + "\Process(sqlservr*)\% User Time"), ("\\$serverName" + "\Process(sqlservr*)\% Privileged Time")
)
Get-Counter -Counter $Counters -MaxSamples 30 | ForEach {
$_.CounterSamples | ForEach {
[pscustomobject]@{
TimeStamp = $_.TimeStamp
Path = $_.Path
Value = ([Math]::Round($_.CookedValue, 3))
}
Start-Sleep -s 2
}
}

Thanks!