How database log file effects our application performance???
If database log file is very heavy like 150gb .Can it effects our application performance??
Need suggestion.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Sep 6, 2013, 4:38 AM
hi,
SQL server transaction log file has internal structure called VLF(virtual log file). when increase no of VLFs and they go to out of controls then log can become fragmented and cause delay.
Please refer
http://www.mssqltips.com/sqlservertip/2107/performance-issue-with-large-number-of-virtual-log-files-in-sql-server-transaction-log/
http://blog.sqlauthority.com/2010/09/20/sql-server-how-to-stop-growing-log-file-too-big/
hope this will help you.