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 FullSearch Results for: Active Sessions
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 FullFind 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
Monitoring and Analyzing SQL Server Sessions with T-SQL
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…
Read Full
Shrinking TempDB in SQL Server: A Step-by-Step Guide
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…
Read Full
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
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
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
TSQL Queries Used by SQL DBA in day to day
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…
Read Full