CPU running at 100% – SQL in sixty seconds 185
Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
How can you identify troublemakers when the CPU is at 100% capacity?
Scripts used in the video: https://blog.sqlauthority.com/2021/09/20/sql-server-troubleshooting-high-cpu/
Subscribe to free performance tuning scripts: https://go.sqlauthority.com/
0:00 Introduction
0:14 Real world scenario
0:54 Endless loop for CPU
1:16 Script 1 – SQL Server vs. Operating System
2:30 Script 2 – List of CPU-damaging queries
3:45 Script 3 – History of CPU-damaging queries
4:24 Next steps
5:15 Guess the game
#SQLServer #PerformanceOptimization #SQLAuthority
Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.