MSSQLTips

Hi there,

I want to know that will there be any improvement in performance when the log file size  is large. 

Why do you need a large T-Log file? Do your database frequently have huge transaction, like insert\update\delete?

If not, the T-Log should have an optimum size.

Now, if your T-Log reaches the maximum then u can shrink the T-Log by having any of the below methods/::

1. Taking frequent T-log backups.

2. run DBCC Shrinkfile to reduce the file size.

Also u can attach more log files if required.

Regards

Sourav