Each SQL Server transaction log file is made of smaller parts called virtual log files. The number of virtual log files is not limited or fixed per transaction log file. Also, there is no fixed size of virtual log file, if one is e.g. 512 kilobytes, all other will be of the same s...
For instance, if you have started a transaction and it has to update some records in the table(s). So, SQL Server will first write the change in the Log file that it is going to update those specific records and then execute the changes in the memory. After the data has been updated...
This change was introduced in SQL Server 2022 (all editions) and included in Azure SQL Database and Azure SQL Managed Instance. Improved virtual log file (VLF) algorithms Virtual File Log (VLF) is an abstraction of the physical transaction log. Having a large number of small VLFs based on ...
Data synchronization involves the primary database sending transaction log records to the secondary database.Important An availability database is sometimes called a database replica in Transact-SQL, PowerShell, and SQL Server Management Objects (SMO) names. For example, the term "database replica"...
For information about availability groups on Linux, seeAvailability groups for SQL Server on Linux. In an HA configuration, a cluster role is created for every availability group that you create. The WSFC cluster monitors this role to evaluate the health of the primary...
As the title states, what is the ThreadID and ProcessID (under <System> tag) in the Windows event log? I have looked around and can't find any documentation that explains it at all? I am familiar with the terms but I have no idea what it means to the event log. Not sure if t...
after having some trouble with my sql server 2012 I could only fix the data inconsistencies using DBCC CHECKDB (xxx, REPAIR_ALLOW_DATA_LOSS). The option's name implies, that there will (possibly) be a data loss, when the database is repaired. What is the data that is lost and ...
There are also users who are using it assuming that the other users did not know that there is an unclosed transaction (let's just assume that the users are just inserting data on the database). What are the consequences of this action? sql-server-2012 transaction Share ...
Find out what's new for SQL Server 2017, which brings the power of SQL Server to Linux and Linux-based containers, as well as Windows.
The source of change data for change data capture is the SQL Server transaction log. As inserts, updates, and deletes are applied to tracked source tables, entries that describe those changes are added to the log. The log serves as input to the capture process. Then, it reads the log an...