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
193 views 07:09 0 Comments

Identify and Store Active Transactions

Scenario How to Identify and Store Currently Running Queries in a Table? To retrieve information about currently executing requests on a Microsoft SQL Server database, we can use several Dynamic…

Read Full
34 views 11:01 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
40 views 07:31 0 Comments

Daily Commands for Database Administrators

As a database administrator (DBA), navigating the vast landscape of database management can be challenging and rewarding. It’s important to be able to execute the commands necessary to simplify day-to-day…

Read Full
939 views 09:49 0 Comments

Find Open Transactions on a SQL Server

Understanding DBCC OPENTRAN DBCC OPENTRAN is a SQL Server database console command (DBCC) that lets administrators to access information about the database's oldest current transaction, as well as the oldest…

Read Full
72 views 15:47 0 Comments

All About DBCC and DMV Interview Question 

What is the use of DBCC commands?  DBCC stands for Database Console Commands, a few of us also call it database consistency checker. There are many DBCC commands in SQL Server. We…

Read Full
48 views 11:55 0 Comments