Is your SQL Server running SLOW? Then you could have an "High Count VLF" problem! TIPS for the DBAs
Hi guys, welcome back! Today we change the subject I present you a problem happened to me last week! So, if you are a DBA then i suggest to bookmark this post! Introduction Driiiiin... On the other end of the phone a customer has a big problem. For a few days it has been increasingly difficult to work! Its management is always slower with the passage of time .. A few minute and we are already connected hunting for slowdowns ! What is a virtual log file (VLF)? When slowdowns involve all areas of your application, I personally take a look also to the transaction log. You should know that even if the physical transaction log (a file with the .ldf extension) is a single file it is divided logically in many parts that are called Virtual Log file aka VLF . Actually having too many virtual log files could rapresent a problem for performances. So how to determine how many VLF have your databases? You can count number of VLF through the qu...