7/11/2023 0 Comments Sql server 2016 express logsIt's best to have the trans log pre-sized to its largest size. The frequent shrinking can cause the number of VLFs within the trans log to grow and thus cause fragmentation within the log file, which can also negatively affect performance. Transaction log file growth can negatively impact performance. I would not shrink transaction logs unless space is an issue. Running more frequent trans log backups might help but they might not too, it depends on how slow the latency is between the primary and the secondary. If the reason is "Availability Replica", then it is waiting for your secondary replica to catch up. Select log_reuse_wait_desc from sys.databases where name = 'your_database' When this happens you can run the following query and see the reason the trans log did not truncate: The backup will complete successfully however, the trans log will not truncate. The transaction log growing for a database participating in an AG is a sign that the secondary replica had not caught up at the time of your trans log backup.
0 Comments
Leave a Reply. |