Determing the position of the last VLF in transaction log before shrinking the log file
sys.dm_db_log_info
Returns Virtual log file (VLF) information of the transaction log. Note all transaction log files are combined in the table output. Each row in the output represents a VLF in the transaction log and provides information…
Execute The Distributed Transaction in SQL SERVER
Implementing a distributed transaction across multiple instances of databases is one of the most commonly used items which are less known by developers and DBAs.
Here we intend to outline a method for executing distributed transactions…
Determing databases in a SQL Server instance with high number of VLFs
Transaction Log Physical Architecture
The transaction log in a database maps over one or more physical files. Conceptually, the log file is a string of log records. Physically, the sequence of log records is stored efficiently in the set…
Usage Scenarios for sys.dm_db_index_operational_stats
Returns current lower-level I/O, locking, latching, and access method activity for each partition of a table or index in the database.
Memory-optimized indexes do not appear in this DMV.
sys.dm_db_index_operational_stats (
{…
How to Monitor TempDB usage
Running out of disk space in TempDB can cause significant disruptions in the SQL Server production environment and can prevent applications that are running from completing operations. You can use the sys.dm_db_file_space_usage dynamic…