https://www.simple-talk.com/sql/database-administration/sql-server-transaction-log-fragmentation-a-primer/
Blog đang chỉnh sửa
https://www.simple-talk.com/sql/database-administration/sql-server-transaction-log-fragmentation-a-primer/
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...
CREATE TABLE #VLF_temp (FileID varchar(3), FileSize numeric(20,0), StartOffset bigint, FSeqNo bigint, S...
http://blog.sqlxdetails.com/transaction-log-myths/ Đọc thêm: http://technet.microsoft.com/en-us/library/ms189085(v=sql.105).aspx BACKUP...
http://blog.sqlxdetails.com/transaction-log-truncate-why-it-didnt-shrink-my-log/
We can use the following SQL Statement: DBCC LOGINFO Each record represent one VLF 2 means Active, 0 is inactive. Please notice t...
We can monitor the transaction log for all databases in an SQL Server Instance based on the SQL Statement: DBCC SQLPERF (LOGSPACE) Follo...
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 ...
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 ...
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 involves logging only the information that is required to recover a transaction without supporting point-in-time recovery.Mi...
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...
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...
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...
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*...