Category: sp_HumanEvents

Updates To sp_HumanEvents, sp_QuickieStore, And More!

Posted on by Erik Darling

For Free!

Here’s some stuff I’ve been working on lately:

sp_HumanEvents:

  • Added the recompile_cause column to the
…

How To Use sp_HumanEvents To Troubleshoot A Slow Stored Procedure In SQL Server

Posted on by Erik Darling

Number One Record

You’ve got a stored procedure that runs slowly, but the problem is that it’s… long. It’s really hard to tell which part is slow, sometimes.

With shorter procs you can probably just collect actual execution plans and …

Updates to sp_QuickieStore, sp_PressureDetector, and sp_HumanEvents

Posted on by Erik Darling

A Thing Of Things

sp_QuickieStore:

  • Added the ability to search query store wait stats for queries that generated a large amount of a specific wait category.
  • Noticed a couple TOP queries were missing DESC for the ordering
  • Increased length of
…

Stressing tempdb and Observing Contention In SQL Server

Posted on by Erik Darling

Pssst!

If you landed here from Brent’s weekly links, use this link to get my training for 90% off.

The access is for life, but this coupon code isn’t! Get it while it lasts.

Discount applies at checkout, and you …

The Forced Parameterization Extended Events That Don’t Work In SQL Server

Posted on by Erik Darling

Busted Up

There are a couple Extended Events that I was really excited about adding to sp_HumanEvents, but try as I might they wouldn’t fire off anything. Ever.

Why was I excited? Because they would tell us why forced parameterization …

Updates To sp_HumanEvents and sp_PressureDetector And More!

Posted on by Erik Darling

Ain’t Nothing To Do

I’ve made some changes to my scripts! Exciting. Sorta. Kinda.

sp_PressureDetector

Got a name change. The code hasn’t changed at all. I started getting annoyed by the formatting and the underscore between pressure and detector.

Now …