Can someone please provide a DETAILED explaination on VLF's.
1. Why are they created? are they only created with Replication ?
2. what details can we find using dbcc loginfo? and what usalbe information does it provide?
3. How do they impact performance?
4. What actions can be taken with regards to VLF's and performance tuning?
View Complete Post