If we were playing blackjack, the dealer would have just gone bust, and you’d have collected your winnings. Scattered amongst the pile of cash, Cumulative Update 22 includes:
Unfortunately, we no longer get full KB articles for each fix, and that’s a shame because CU 22 includes some really odd fixes like this one:
This fix enables QDS instance level memory limits by default on box edition. It prevents QDS from consuming more memory after certain limit by changing to READ ONLY mode.
I wish I could tell you more about why your Query Store will suddenly be going into read-only mode, what “box edition” is, or what the limits are, but I can’t, because Microsoft won’t tell us. Two sentences aren’t enough here.
That’s frankly unacceptable for enterprise database software that costs $7,000 per core.
I’m gonna be honest, dear reader: I’m beyond frustrated with the lack of quality documentation here. The changes are so undocumented and so big that I just don’t trust ’em anymore. I hope they turn things around and start documenting these problems, but in the meantime, you’d have to be pretty adventurous to install something like CU22 that can turn off your Query Store without warning, without telling you why.
Other updates in this CU include:
- FIX: Managed backup is not backing up the database when SQL Agent system jobs are changed to different name other than ‘sa’ in SQL Server 2017
- FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size
- FIX: Incorrect results can occur when you run linked server query with aggregates or joins on table with filtered index on a remote server in SQL Server 2017
- FIX: COMPILE blocking occurs when executing many concurrent stored procedures in SQL Server 2017
- FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server
- FIX: Concurrent inserts against tables with columnstore indexes may cause queries to hang in SQL Server
- FIX: Upgrade script fails if you use Always On Failover Cluster Instance as a secondary replica in SQL Server
- FIX: SQL Server fails to start when remote admin connections are enabled and IPV6 is disabled on the host
- FIX: INSERT EXEC doesn’t work when you insert row containing explicit identity value into table with IDENTITY column and IDENTITY_INSERT is OFF by default in SQL Server
- SQL Server AG Helper/AG monitoring application waiting more than 30 seconds with epoll and futex_wait_queue_me wait type is unable to connect to SQL Server 2017 resulting in timeout and failover.
- FIX: Access violation exception occurs in Availability Groups in SQL Server 2017 under certain conditions
Here’s Cumulative Update 22. Good luck.