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.
2 Comments. Leave new
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