configuration

Target Recovery Interval and Indirect Checkpoint - New Default of 60 Seconds in SQL Server 2016

Target Recovery Interval and Indirect Checkpoint - New Default of 60 Seconds in SQL Server 2016

Update, 6/21/2016: Be careful using indirect checkpoint with failover clusters if your SQL Server 2014 instance is not fully patched. See KB 3166902. This bug was fixed in SQL Server 2016 prior to RTM.

SQL Server 2016 introduces big new features, but it also includes small improvements as well. Many of these features are described in the “It Just Runs Faster” series of blog posts by Bob Ward and Bob Dorr.

Why To Do Some of the Grunt Work, Even If You Don't Have To

Why To Do Some of the Grunt Work, Even If You Don't Have To

Part of this past week I’ve spent doing a new SQL Server 2008 R2 installation and configuration on a Windows 2008 R2 cluster. I  haven’t done an install end-to-end in quite a while– I have teammates who take care of it while following our installation checklist document.

Error Configuring DataCollector: A collection set cannot start without a schedule

Error Configuring DataCollector: A collection set cannot start without a schedule

When setting up data collection using the GUI, configuration failed halfway through setup. At the point  of failure I found there were SQL Agent jobs for collections visible, but nothing appearing  in Management Studio under Management\Data Collection. The Data Collection icon still had the ‘off’ down red arrow. (I manually refreshed it for good measure to make sure.)