Stop and checked your Virtual Log Files (VLFs)

Is your transaction log over 5gb?  Have you checked to see how many Virtual Log Files (VLFs) exists in your transaction logs?  If not, I would suggest you add to your many list of high priority tasks checks to see how many VLFs exists for your transaction logs.  A large number of VLFs are result
Read More »