Trace – Vroom Performance Technologies

SQL Server Lock Escalation

By Josh Patterson | May 1, 2023 |

Introduction SQL Server is a powerful and flexible relational database management system (RDBMS) designed to manage and store data efficiently. One of its key features is the ability to manage concurrent access to data through its locking mechanism. When multiple users or applications access data simultaneously, SQL Server must ensure data integrity and maintain the…

Creating an Extended Events Session

By Josh Patterson | December 12, 2018 |

Creating an extended events session is pretty straight forward with SQL Server 2012 as Microsoft has finally introduced a graphical user interface. During my time as a DBA, I often needed to create a quick trace to capture query activity for a particular table. So, let’s run through how we might do this with extended…

Tracing Events in SQL Server

By Josh Patterson | November 16, 2018 |

When you want to trace or instrument SQL Server activity, whether it be for performance purposes, security, auditing, etc. – you really have two baked in methods. Well, there are a few others – but they are not all that robust. Tracing with SQL Profiler Tracing with SQL Server profile is the good ol’ way…