In previous part of this series, you learnt about checking overall health of Sql Server. Now we will go through, real-time performance monitoring of SQL Server. When you face sudden slowdowns, high CPU usage, or unexplained bottlenecks, having a quick and efficient way to diagnose issues are essential. This is where sp_BlitzFirst, a tool from Brent Ozar’s SQL Server First Responder Kit, comes into play.
[More]
In first part of this series, we learnt briefly about First Responder Kit, its installation process and all of its stored procedures. In this part we will explore the stored procedures of First Responder Kit, sp_Blitz.
[More]