Understanding Virtual Log Files (VLF)

Understanding Virtual Log Files (VLF)

Unmanaged Virtual Log Files are one of the most frequent issues I find on my client’s environments and since there is a lot of misconceptions around this topic, my intention with this article is to create an understanding about how and why VLFs get created, simulate a VLF count growth and demonstrate how we can monitor it and more importantly how can we fix it.

5 most common causes of SQL Server performance problems

5 most common causes of SQL Server performance problems

At WARDY IT Solutions, we’ve lived and breathed SQL Server for the past 14 years. With more than 100 years of SQL Server experience between them, we asked our Data Platform consultants to share their opinions on the most common causes of performance problems and of course, how to avoid them. Happy performance tuning!