ananda.murugesan (7/22/2014)
Ok, Many thanks form experties suggestions.server side 800 GB freespace available at log file partition, so I am not executed that command let it be gorw that file.
Pls. confirm,
Does it any performance issues happend if it is huge VLF created in LDF file?
Thanks
ananda
Yes. You've either been shrinking and growing it over and over, and/or, your growth increment is really tiny (probably the default 1mb) and you've grown it thousands of times. That scatters things across the disk and can cause performance issues primarily in startup and backup and recovery.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning