Tìm hiểu thêm về transaction log fragmentation

https://www.simple-talk.com/sql/database-administration/sql-server-transaction-log-fragmentation-a-primer/

Why fragmentation transaction log is problematic

SQL Server transaction log files have an internal structure called the Virtual Log File or VLF. When the number of VLFs grow out of control...

Check VLF cho mỗi transaction log file mỗi database

CREATE TABLE #VLF_temp (FileID varchar(3), FileSize numeric(20,0), StartOffset bigint, FSeqNo bigint, S...

Những điều cần biết về transaction log

http://blog.sqlxdetails.com/transaction-log-myths/ Đọc thêm:  http://technet.microsoft.com/en-us/library/ms189085(v=sql.105).aspx BACKUP...

Transaction Log truncate vs shrink

http://blog.sqlxdetails.com/transaction-log-truncate-why-it-didnt-shrink-my-log/

Check how many VLFs in Transaction Log File

We can use the following SQL Statement: DBCC LOGINFO Each record represent one VLF 2 means Active, 0 is inactive. Please notice t...

Monitor transaction log

We can monitor the transaction log for all databases in an SQL Server Instance based on the SQL Statement: DBCC SQLPERF (LOGSPACE) Follo...

Tuning transaction log?

The fact that writes are always sequential also means that SQL Server will only ever write to one transaction log file at a time. There is ...

Restarting a log backup chain requires a full database backup

A very useful knowledge about restarting a log backup chain. There are many reasons that force the dba have to restart the log backup chain ...

Restart Log Backups

My sales database had a problem with log backups failing and the log file grew large. I do the following: ALTER DATABASE sales SET RECOV...

Minimal Logging in SQL Server

Minimal logging involves logging only the information that is required to recover a transaction without supporting point-in-time recovery.Mi...

Lỗi khi attach SQL database file: "The log cannot be rebuilt when the primary file is read-only"

Hôm nay tôi cần attach database AdventureWorkDW2012 để thực hành SQL Server thì cứ gặp lỗi " The log cannot be rebuilt when the primary...

Check writing transaction log on SQL Server

1 task cần load nhiều file txt vào 1 database trong sql server. Cần check xem tiến trình này có ghi log nhiều không. Đơn giản là chỉ cần d...

Trimming the Transaction Log Fat

Các hoạt động giải phân mảnh index cũng sinh ra log record. http://www.sqlperformance.com/2012/12/io-subsystem/trimming-t-log-fat Ở một b...

Truncate Transaction log cho Database

Trước hết, kiểm tra dung lượng các file hiện tại: SELECT DB_NAME(database_id) AS DatabaseName, Name AS Logical_Name, Physical_Name, (size*...