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

TempDB files recommendation in SQL Server

The number of tempdb data files in an SQL Server depends on several factors, including the number of logical processors on the server. As a general recommendation, it's best to…

Read Full
29 views 08:18 0 Comments