Search results for "Active Sessions"

  • Finding Active Sessions in SQL Server

    Finding Active Sessions in SQL Server

    30 July 2023

    Active Sessions in SQL Server

  • Identify and Store Active Transactions

    Identify and Store Active Transactions

    10 February 2023

    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…

  • Find active transactions by duration

    Find active transactions by duration

    15 July 2022

    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…

  • Monitoring and Analyzing SQL Server Sessions with T-SQL

    Monitoring and Analyzing SQL Server Sessions with T-SQL

    26 May 2019

    Introduction SQL Server is a powerful relational database management system used by organizations to store and manage their data. As an administrator or developer, it’s crucial to have visibility into…

  • Shrinking TempDB in SQL Server: A Step-by-Step Guide

    Shrinking TempDB in SQL Server: A Step-by-Step Guide

    7 February 2023

    Introduction In SQL Server, TempDB is a system database used to store temporary objects, intermediate results of queries, and other temporary data. Over time, TempDB can grow significantly, leading to…

  • About Traces & System Stored procedures

    About Traces & System Stored procedures

    15 May 2024

    Trace Flags What are trace flags? Trace flags are used to temporarily set specific server characteristics or to switch on/off a particular behavior. They are frequently used to diagnose performance…

  • Essential Database Management Views (DMVs)

    Essential Database Management Views (DMVs)

    8 April 2024

    In the intricate world of database management, optimizing performance is paramount. Whether you’re overseeing a bustling enterprise database or managing a small-scale system, understanding the underlying performance metrics is key…

  • Daily Commands for Database Administrators

    Daily Commands for Database Administrators

    30 September 2023

    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…

  • Find Open Transactions on a SQL Server

    Find Open Transactions on a SQL Server

    30 May 2023

    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…

  • All About DBCC and DMV Interview Question 

    All About DBCC and DMV Interview Question 

    8 May 2023

    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…

  • TSQL Queries Used by SQL DBA in day to day

    TSQL Queries Used by SQL DBA in day to day

    17 September 2019

    In this article, we’ll explore some of the most commonly used TSQL queries for DBAs, how to use them effectively, and the benefits they offer. Whether you’re a beginner or…