pijacek.io |

26 Aug Query Performance Tuning with Filtered Statistics

Posted at 12:05h in Database, Datawarehouse, Performance, SQL Server Central by admin 0 Comments

0 Likes

Introduction I recently got a call from our DBA telling me that the CPU usage is hitting 100% on the DB server and the ETL process runs for more than 24 hours, but still has not finished. You know that feeling, right? So, I connected to the...

19 Feb How to get Live Execution Plan using Extended Events

Posted at 12:04h in Database, Performance, SQL Server Central by admin 0 Comments

0 Likes

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 to get and analyse the actual runtime execution plan of this query. In this blog post, I...

15 Jan Extended Events: Detect Implicit Conversions that affect execution plans

Posted at 10:29h in Database, Datawarehouse, Performance, SQL Server Central by admin 0 Comments

0 Likes

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. But before we even start with Extended Events, let’s briefly recall what an implicit conversion is,...