I am a heading
Over the past month (plus or minus a couple days), I’ve shown you in a series of quick posts how I use different SQL Server Community Tools that are free and open source to troubleshoot SQL …
Category: sp_HumanEvents
SQL Server Community Tools: Capturing Query Wait Stats With sp_HumanEvents
Paladin
I have sort of a love/hate relationship with wait stats scripts and analysis. Sometimes they’re great to correlate with larger performance problems or trends, and other times they’re totally useless.
When you’re looking at wait stats, some important things …
SQL Server Community Tools: Capturing Which Queries Are Recompiling And Why With sp_HumanEvents
Classic Espionage
Like query compilations, query recompilations can be annoying. The bigger difference is that even occasional recompiles can introduce a bad query plan.
If your monitoring tools or scripts are warning you about high compiles or recompiles, sp_HumanEvents can …
SQL Server Community Tools: Capturing Which Queries Are Compiling With sp_HumanEvents
Compilation Game
One thing that I have to recommend to clients on a fairly regular basis is to enable Forced Parameterization. Many vendor applications send over queries that aren’t parameterized, or without strongly typed parameters, and that can make things… …
SQL Server Community Tools: Capturing Query Performance Problems With sp_HumanEvents
Cumulative Noopdate
In yesterday’s post, I talked through how I capture blocking using sp_HumanEvents. Today I’m going to talk about a couple different ways I use it to capture query performance issues.
One thing I want to stress is …
SQL Server Community Tools: Capturing Blocking With sp_HumanEvents
Month Of Sundays
A while back, Brent blogged about using September to raise awareness about free SQL Server community tools.
I thought this was a great idea because I maintain a number of them: my own scripts, the …
Updates To sp_HumanEvents
Touchy, Touchy
I’ve made some slight tweaks to sp_HumanEvents.
One of them fixes a bug with view creation when you use a custom schema. The rest are minor tweaks and fixes that you (hopefully won’t notice one bit), but …
Updates To sp_HumanEvents, sp_QuickieStore, And More!
For Free!
Here’s some stuff I’ve been working on lately:
- Added an inline table valued function that strips characters from a string
- Added a script to create useful Alerts in SQL Server
- Added the recompile_cause column to the
How To Use sp_HumanEvents To Troubleshoot A Slow Stored Procedure In SQL Server
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
A Thing Of Things
- Added the ability to search query store wait stats for queries that generated a large amount of a specific wait category.
- Noticed a couple
TOPqueries were missingDESCfor the ordering - Increased length of