Microsoft went on holiday vacation, and they came back with a vengeance. There are one heck of a lot of fixes inside SP2 CU5 and SP1 CU13, including:
- Access violation when you compile a query
- Access violations and unhandled exceptions with Always On Availability Groups automatic seeding
- Dynamic Data Masking doesn’t when there’s a cursor involved
- Access violations for XML data types
- Query Store blocks transactions and log truncation
- Out of memory errors
- Non-yielding schedulers with heavy use of prepared statements
- Can’t restore compressed backups of encrypted databases
- High CPU usage when there are many batch requests (uh, duh)
- SQL Server service crashes when you cancel CHECKDB (on a “large database”, whatever the hell that is)
I could go on and on – there are a LOT of fixes in here. Go check out SP2 CU5 and SP1 CU13.
The BPE one is really nasty because SQL Server is still “running”, it’s just not doing anything. And 9 times out of 10, it halts in such a way that AG failovers don’t occur, so you’re stuck with sync secondaries in an unusable state.
You can’t stop/start the service, you have to bounce the box, at which point the AGs all fail over.
I am going to bed tonight and wake up tomorrow and I will download 2016 SP2 CU 6 instead, thx