always on availability groups in sql server 2016 Enterprise edition The AlwaysOn Availability Groups feature in SQL 2016 has been improved significantly over SQL 2014, particularly in the realm of the log transport and stability (not including the new features) It should be completely unnecessary to manually configure for worker thread starvation You should of course monitor for any problems (and Microsoft PSS could even benchmark your system for you if
Scripting the Maintenance Plan Cleanup Task Hope all is well I am currently using SQL Server Maintenance Plan to backup 17 databases on the instance The plan includes the Maintenance cleanup task transformation to delete backups older than a week But due to space constraints I want to delete backups older than 1 day (I am backing databases to tape every night) but keep the backups older than a week for only 2 databases I was looking