Is the backup maintenance task in use? It pauses SMS_EXECUTIVE among other things and is the most likely culprit in my mind. I recommend not using it all. All of the things it does can easily be done (and done better) by native SQL backup and a simple script to include any extra odds and ends.
J -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jason Wallace Sent: Friday, June 19, 2015 4:59 PM To: jaswall/edarkosarwa/magzparmenter/<Unnamed>/pradeepe <[email protected]> Subject: [mssms] Maintenance Tasks hitting hard Hi folks I wanted to run something by folks and ask for some advice. Have a customer with replication issues - mainly degradation but sometimes failed. DRS itself checks out and it almost always recovers but we see degradation almost every day and then it takes a while to recover. We are pinning this down to maintenance jobs running overnight - we see SQL reporting timeouts in logs and we see DNF unloading. So to help out does anyone have some insight as to which of the maintenance tasks load the server in such a way that would cause it to croak like this? Jason
