I have a database with 160 VLFs. How do I determine whether the VLFs are fragmented? Further, how do I find the percentage of fragmentation?
Another thing that I want to confirm: Are the following 3 statements always true for newly added chunks in SQL server Virtual Log files?
- chunks less than 64MB and up to 64MB = 4 VLFs
- chunks larger than 64MB and up to 1GB = 8 VLFs
- chunks larger than 1GB = 16 VLFs