Monitoring transaction log usage is an important part of database maintenance. High numbers of Virtual Log Files (VLFs) within a…
We’re coming up on a great time of year again, for SQL database geeks. The PASS Summit. I’ll leave off…
First, thanks to Sean McCown (t|w) and Mladen Prajdic (t|w) for their assistance with finding & confirming some of the…
In the previous post we looked at how log backups and auto growth settings can affect performance. Now let’s look…
Why does missing a few log backups matter? I was asked that question last week when one of our backup…
There are more than 1000 different ways to configure a SQL Server instance. Just to install a new SQL Server…