All Questions
2 questions
6
votes
3
answers
12k
views
Multiple Transaction Log files and performance impact
So I've gotten into an argument with several people regarding the number of transaction log files a give databases should have. I've seen several post saying you should only have 1 transaction log ...
- 177
2
votes
2
answers
704
views
Large number of VLF and shrinking the log
If there are lot number of VLF then it will effect the performance of the queries. I saw that solution is to shrink the log file. But shrinking the file is also bad. So how to take control of whole ...
- 3,131