SQL Profiler or Extended Events? I compare how each one works, why SQL Trace adds overhead on a busy server, and why Extended Events is my choice.
SQL SERVER – Finding Waits For Any Session with Extended Event wait_info
It becomes a great win-win situation. Let us learn about Extended Event wait_info in this blog post. Do you think this script will be useful for you?
SQL SERVER – Extended Events to watch for using ColumnStore Index
Profiler can’t show how ColumnStore indexes work, so a DBA friend asked which extended events to watch. Here are my notes on the events worth tracking.
SQL SERVER – Why is My Query Switching to Row Processing and Not Doing Batch Processing?
Why is my query switching to row processing and not doing batch processing? Here is what to check with ColumnStore indexes in SQL Server.
SQL SERVER – XEvents to Find Cardinality Estimation Issues
Is there a way to find cardinality estimation issues? I use the query_optimizer_estimate_cardinality XEvent to see how each operator’s estimate is derived.
SQL SERVER – To Find Events Mapped to Channels in Extended Events
How exhaustive are Extended Events compared to Profiler? A DBA asked me, so here is how to find events mapped to channels in Extended Events.
SQL Server – Knowing Deprecated or Discontinued Features Using Extended Events
Find the use of deprecated or discontinued features without Profiler. Here is a step by step way to track them using Extended Events in SSMS.