I have been so busy this week that I didn’t get a chance to blog about this yesterday when it happened, but I had a new article published on SQLPerformance.com that compares the performance impact or "observer overhead" of using SQL Trace and Extended Events. I had a lot of fun running different benchmarks for [...]
Jonathan Kehayias
The Rambling DBA
New Article on SQLPerformance.com comparing “Observer Overhead” of Trace vs Extended Events
Posted on: October 24, 2012 12:20 pm
How useful are query_hash and query_plan_hash for troubleshooting?
Posted on: October 24, 2012 12:06 pm
After my last post, I was contacted by email about the usefulness of query_hash in actual troubleshooting scenarios since the query_hash value is based on the statement and not the database in a system. It just happened that the example template from SQL Server 2012 that I showed had the query_hash included in it’s definition. [...]
