Search results for "Active Sessions"
-
-
Identify and Store Active Transactions
10 February 2023Scenario 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
15 July 2022Recently 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
26 May 2019Introduction 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
7 February 2023Introduction 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…
-
SQL Server DBA Scenarios: A Comprehensive Guide
11 July 2024As a Level 3 SQL Server DBA, you’re expected to handle a variety of complex situations that require deep technical knowledge and problem-solving skills. This guide provides insights into advanced…
-
About Traces & System Stored procedures
15 May 2024Trace 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)
8 April 2024In 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
30 September 2023As 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
30 May 2023Understanding 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
8 May 2023What 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
17 September 2019In 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…