How to get Live Execution Plan using Extended Events
4 Comments
Introduction Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that was hammering your SQL Server? I bet you wanted…
Extended Events: Detect Implicit Conversions that affect execution plans
Implicit Conversions – Introduction In this blog post, I’ll explain and demonstrate how to use Extended Events to detect Implicit Conversions that affect execution plans on your SQL Server instance.…
JC stories – Pavel Málek
S počátkem nového roku jsme se rozhodli vypustit do světa naše příběhy. Každý jsme si svou profesní cestu vyšlápli po svém a tak se s vámi o to rádi podělíme.…
Clustered Column Store Load Pitfalls – Magic number 64 when using WHERE IN clause
The Problem During our workload we have recognized a difference in performance for queries using IN clause. We are building query dynamically, so you can have a different length of…
Watch out – new Database Level Health Detection can send your AOAG down!
Background In the past, Windows Server Failover Clustering (WSFC) cluster only monitored the health of your entire Always On Availability Groups (AO AG) primary replica. This meant that even when…
Není v JC pohovor jako “pohovor”
Slávka je náš happiness manager s velkým “H”, který je s námi už od samého počátku. Nejen, že neustále pomáhá JC budovat, ale baví jí také poznávat nové lidi z…