SQL Server Database Engine BasicsCommented on: 3 years ago
(February 24, 2011)
"If the log truncation process fails, the transaction log will grow until it fills up the disk it resides on." Of course only if Autogrowth is enabled for this transaction log file,...
In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....More