sp_AskBrent

When your SQL Server is slow right now, you can run sp_BlitzFirst® to find out what’s going on. It checks for things like long-running queries, backups, blocking, files growing, and will tell you the top wait stats right now. You can use the @Seconds parameter to control the sample length – by default, it samples…

When I ask you how fast your car is, there’s a two common metrics for answers: How fast it can go How much horsepower or torque its engine can deliver If I ask you how hard your car is working right now, you’d probably answer with: Its current speed (in MPH or KPH) Its current engine workload…

When your SQL Server is having performance problems, sp_BlitzFirst® checks a bunch of common trouble spots. In this week’s new version, it also checks sys.dm_os_ring_buffers for the most recent CPU utilization report from SQL Server and returns it. Here’s what it looks like when the server isn’t under load – note that “No Problems Found” means…

When someone tells you the SQL Server is slow, what do you do? Run sp_who looking for queries that might be blocking someone Check the SQL Agent jobs to see if there’s a backup job running Fire up Activity Monitor looking for problems Remote desktop into the server to look at CPU use Open Perfmon…