Finding Active Sessions in SQL Server

Introduction In this blog post, we will dive into the world of active sessions and requests in SQL Server. We will learn how to extract valuable information about these sessions…

Read Full
900 views 07:09 0 Comments

Find active transactions by duration

Recently frequently we faced blocking issues on our production server. The main reason that I understand, recently we merged a few SQL servers and migrated all databases to a single…

Read Full
274 views 07:31 0 Comments