KB | Description | Fix area | Platform | Learn More |
The AlwaysOn_Health extended event doesn't set STARTUP_STATE to ON after installing a SQL Server Cumulative Update. | High Availability | Windows | ||
The function sys.fn_hadr_backup_is_preferred_replica returns different results on primary or secondary replicas of read-scale availability groups (Cluster_Type=None) when running on standalone machines or cluster nodes | High Availability | Windows | ||
The database recovery process is chosen as the deadlock victim on Availability Group (AG) failover under certain circumstances. The following error message is generated: | High Availability | Windows | ||
An "Out of memory" error occurs when you take a log backup frequently and Stolen Server Memory grows at an synchronous secondary in Availability Groups. | High Availability | Windows | ||
Resolves stalled I/O completion port (IOCP) issues when a heavily used service broker is configured on an availability group database. | High Availability | Windows | ||
SQL Server 2019 using XTP UserDB for staging tables has a steady growing trend for "VARHEAP\Storage internal heap" in dm_db_xtp_memory_consumers that leads to OOM/41805 errors over time and requires proactive restart/failover to retain stability. | In-Memory OLTP | Windows | ||
Improves the dynamic management view (DMV) to help debug the out-of-memory (OOM) issues. | In-Memory OLTP | Windows | ||
Memory-Optimized TempDB Metadata keeps consuming memory under VARHEAP: LOB Page Allocator, which causes out-of-memory (OOM) exceptions like error 701 or FAIL_PAGE_ALLOCATION. | In-Memory OLTP | Windows | ||
Lets more flexible cleanup and merge operations enable by changing In-Memory during restore operations. | In-Memory OLTP | Windows | ||
Improves the response time of the Sqldumpr.exe utility when in-memory objects are used in SQL Server or once existed. | In-Memory OLTP | Windows | ||
An assertion failure occurs in tempdb during the rollback of transactions, and triggers a server shutdown. The following dump file is generated: | In-Memory OLTP | Windows | ||
A memory dump and assertion failure "Dependencies.CommitDepCountOut >= 1" may occur after a transaction rolls back if in-memory tempdb is enabled. | In-Memory OLTP | Windows | ||
The sqlcmd utility crashes when the batch_terminator parameter "-c" is set to ";" in SQL Server 2019. | Management Tools | Windows | ||
The bulk insert is blocked when the lock of the target table is held by another session, and the session of the bulk insert will remain in SQL Server until its lock is released even if the client application disconnects or exits. This issue causes the session to leak and other requests to be blocked if the leaked sessions are accumulated too many. | SQL Connectivity | Windows | ||
5012964 | Improvement: Add an XEvent for tracking manual user plan forcing and unforcing | SQL Engine | Windows | |
5014047 | Improvement: Make the change tracking table lock escalation policy be the same as the base table’s | SQL Engine | Windows | |
5014136 | Improvement: Ship the EO-compliant ML service CAB packages for SQL Server 2019 | SQL Engine | Windows | |
5014137 | Improvement: Ship the EO-compliant Microsoft Extensibility SDK for Java for SQL Server 2019 | SQL Engine | Windows | |
4538688 | FIX: Severe spinlock contention occurs in SQL Server 2019 | SQL Engine | Windows | |
Restoring transaction logs from a compressed backup of a TDE-enabled database may cause a "misaligned I/O" message to be logged in the SQL Server error log: | SQL Engine | Windows | ||
A database freezes its I/O during a VSS backup but never thaws the I/O. This can lead to latch timeouts | SQL Engine | Windows | ||
An offline, piecemeal restore sequence of restoring individual file groups fails when you use the WITH NO_LOG statement. Here are the error messages: Msg 3241, Level 16, State 18, Line The media family on device '' is incorrectly formed. SQL Server cannot process this media family. Msg 3013, Level 16, State 1, Line RESTORE DATABASE is terminating abnormally. Note Transparent Data Encryption (TDE)-compressed backups that are made by using previous CU versions of SQL Server 2019 can be restored by using SQL Server 2019 CU 16 and later versions. However, TDE-compressed backups that are made by using SQL Server 2019 CU 16 and later cannot be restored to previous CU versions of SQL Server 2019. | SQL Engine | Windows | ||
An access violation dump occurs when the query runs for a long time in parallel and tries to determine the version of the rowgroup for the particular transactions to read. | SQL Engine | Windows | ||
The logon trigger may fail unexpectedly for the pooled connections even when the criteria are not met during the connection reset, and causes the following error: Error:17892, Severity: 20, State: 1. Logon failed for login ' | SQL Engine | Windows | ||
Dropping temp tables in some rare cases causes an unresolved deadlock and dump. | SQL Engine | Windows | ||
An access violation occurs if a query on sys.database_scoped_configurations is waiting for a shared lock on the database while another thread holds the exclusive lock to drop the same database. | SQL Engine | Windows | ||
Running DBCC CHECKDB will report "corruption" errors when you use SQL Server graph databases that have edge constraints. | SQL Engine | Windows | ||
An assertion failure, lck_sufficient (lckMode, LCK_M_IX) || lck_sufficient (lckMode, LCK_M_BU), occurs when you use Accelerated Database Recovery (ADR). | SQL Engine | Windows | ||
Restoring from a compressed backup that contains filestream objects randomly fails if the process is run through the Virtual Device Interface (VDI) client. Here are the error messages: Msg 3241, Level 16, State 18, Line The media family on device '' is incorrectly formed. SQL Server cannot process this media family. Unexpected termination: x80770004 | SQL Engine | Windows | ||
Calling CMEDScan::EvaluateCmpResult to evaluate filter predicates for the current metadata scan misses the "NE" predicate, which causes an "INVALID_SWITCH_VALUE" exception. | SQL Engine | Windows | ||
Assume that you have tables with data on the peers and then you set a peer-to-peer publication by using a last-writer conflict detection policy. The distribution agent occurs the following conflict if you delete a row that was present before the publication was created: A conflict of type 'Delete-Update' was detected at peer 1 between peer 100 (incoming), transaction id | SQL Engine | Windows | ||
A "Non-yielding Scheduler" issue and dump occur during a backup operation because of concurrent Page Free Space (PFS) updates. | SQL Engine | Windows | ||
Adds two new Extended Events, iam_page_range_cache_invalidation and iam_page_range_cache_population, to respectively capture Index Allocation Map (IAM) page range cache invalidation and population. | SQL Engine | Windows | ||
4538581 | FIX: Scalar UDF Inlining issues in SQL Server 2019 | SQL Performance | Windows | |
SQL Server disconnects a session when it gets an attention and INTERLEAVED_EXECUTION_TVF is enabled. | SQL Performance | Windows | ||
The query processor can't produce a query plan if the USE PLAN hint specifies a query plan that has a left outer join and an inner join. | SQL Performance | Windows | ||
Executing a query where the plan contains an adaptive join may fail together with the following error: Msg 8624, Level 16, State 21, Procedure ProcedureName, Line LineNumber [Batch Start Line 0] Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services. | SQL Performance | Windows |
KB | Description | Fix area | Platform | Learn More |
5010555 | Improvement: Add the usage of signed certificates with multiple DNS names | High Availability | All | |
Adds improvement to capture sp_server_diagnostics XEvent in an AlwaysOn_health XEvent session when STATE is 3 (ERROR) to diagnose HADR Health Events | High Availability | Windows | ||
Adds the Reverting progress to SQL Server error logs in SQL Server 2019 just like the Recovery progress | High Availability | Windows | ||
Fixes an issue where assertion failure on secondary replica when you use Always On availability groups in high-latency networks in SQL Server 2019 | High Availability | Windows | ||
Fixes an error that occurs after a failover of a Distributed Availability Group that attempts to connect to the secondary AG listener with application intent set to READ ONLY | High Availability | Windows | ||
Fixes the following insufficient memory error that occurs during In-Memory Online Transactional Processing (OLTP) if application native procedures update tables that have Large Object (LOB) columns and do not specify the LOB column in the UPDATE list: Disallowing page allocations for database 'Retail' due to insufficient memory in the resource pool 'IMOLTP'. XTP failed page allocation due to memory pressure: FAIL_PAGE_ALLOCATION 8 | In-Memory OLTP | All | ||
Fixes an issue where Distributed Replay Client may fail with an unhandled exception. This fix is for the Distributed Replay Client that shipped with SQL Server 2019. The following is the error you may observe in the output/log file: DateTime OPERATIONAL [Common] Unhandled exception is encountered. [Exception Code = 3221225477] DateTime OPERATIONAL [Common] Invoking dump. DateTime OPERATIONAL [Common] Service terminating. | Management Tools | Windows | ||
Fixes an issue where Cumulative Update (CU) patching fails with the following message when you set default data directory to Azure Blob Storage URL: The given path's format is not supported. Exception Type "System.NotSupportedException" Note To work around the issue, you can change the data default directory to a local directory and rerun the SQL patch. | Setup & Install | Windows | ||
5010246 | Improvement: Add 1 (true) and 0 (false) as valid values to mssql-conf Boolean settings | SQL Engine | Linux | |
5008647 | Improvement: Add mssql-conf and adutil utilities to SQL Server 2019 | SQL Engine | Linux | |
5008648 | Improvement: Add a setting for the machine key location on Linux | SQL Engine | Linux | |
5010234 | FIX: Buffer overruns when data buffer spans multiple SNI packets | SQL Engine | Windows | |
5010653 | FIX: Database corruption after creating an external library in SQL Server 2019 | SQL Engine | All | |
Adds improvement in capturing memory dumps on unexpected crashes in SQL Server 2019 on Linux | SQL Engine | Linux | ||
Fixes an issue where different conversion results are displayed in publisher and subscriber database tables when using the ASCII function to convert a column. For more information, see ASCII function returns different results in Publisher and Subscriber database tables. | SQL Engine | Windows | ||
Fixes an issue where the default trace on Linux rolls over before the limit size of 20 MB | SQL Engine | Linux | ||
Fixes an issue where a filtered index becomes corrupt after you drop a computed column on the same table, and the filtered index corruptions are reported as 8951 and 8955 errors when you run DBCC CHECKTABLE WITH EXTENDED_LOGICAL_CHECKS | SQL Engine | Windows | ||
Fixes an issue where java.nio.BufferOverflowException error occurs when using PolyBase external tables to query data from Hadoop. Note This error occurs when querying from a file that has columns of type varchar or nvarchar with a width greater than 256 characters. | SQL Engine | All | ||
Fixes the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all the memory available is taken | SQL Engine | Windows | ||
Fixes an issue where the dm_db_page_info function may record spurious corrupted pages entries in the suspect_pages table when calling the function against the transaction log file | SQL Engine | Windows | ||
Fixes an issue where the output of sp_pkeys KEY_SEQ column doesn't conform to the ordering of columns defined in the Primary Key | SQL Engine | Windows | ||
Fixes a committed memory accounting issue, which under some circumstances, FAIL_PAGE_ALLOCATION error could occur a few days after starting SQL Server services on Linux | SQL Engine | Linux | ||
Fixes an access violation that occurs when you use FileTable in SQL Server 2019 | SQL Engine | Windows | ||
Fixes the access violation sqldk!StringVPrintfWorkerW that occurs during the compilation of the query for Dynamic Management Views (DMVs) sys.dm_os_ring_buffers | SQL Engine | Windows | ||
Fixes a system-wide low memory issue that occurs when SQL Server commits memory above the maximum server memory | SQL Engine | Windows | ||
Fixes the following error that occurs when you back up a database by using virtual device interface (VDI) on ubuntu docker container installed SQL Server 2019: Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: ClientBufferAreaManager::SyncWithGlobalTable: Open(hBufferMemory): error 2Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: TriggerAbort: invoked: error 0Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: TriggerAbort: ChannelSem: error 2Features returned by SQL Server: 0x10000 Opening the device. VDS::OpenDevice fails: x80770004 Msg 18210, Level 16, State 1, Server , Line BackupVirtualDeviceSet::AllocateBuffer: failure on backup device '515697bb-6009-4018-b373-50c871ed736c'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). Msg 3013, Level 16, State 1, Server , Line BACKUP DATABASE is terminating abnormally. | SQL Engine | Linux | ||
5009753 | FIX: Physical reads are counted twice for read-ahead | SQL performance | All | |
Fixes the following error 104 that occurs when you use scalar User-Defined Function (UDF) lnlining in the ORDER BY clause during the query compilation that has a UNION operator: Msg 104, Level 16, State 1, Line ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operato | SQL performance | All | ||
Fixes an assertion in CQPOnDemandTask::ExecuteQPJob if auto async update statistics is enabled | SQL performance | Windows | ||
Fixes an issue where the specific statement for compilation in stored procedures seems "stuck" and shows sqlsource_transform until manual intervention | SQL performance | Windows | ||
Fixes an access violation that occurs in CXPort::Close after you use SQL Server 2019 Cumulative Update 14 (CU14) | SQL performance | Windows |
KB | Description | Fix area | Platform | Learn More |
Fixes the following error that occurs when you restore a database file (.mdf) that is larger than 15 GB on SQL Server 2019 Big Data Cluster (BDC) with high availability (HA) configuration: Msg 42019, Level 16, State 4, Line RESTORE MANAGED DATABASE operation failed. Internal service error. Msg 3013, Level 16, State 1, Line RESTORE DATABASE is terminating abnormally. | High Availability | Linux | ||
Fixes an assert dump "pwchId && cwchId 0" during Always On availability group (AG) Virtual Device Interface (VDI) seeding. | High Availability | Windows | ||
Fixes an access violation exception that may occur when sp_server_diagnostics is executed. | High Availability | Windows | ||
Fixes an issue where Last_sent_time and Last_received_time columns in DMV dm_hadr_database_replica_states does not get updated | High Availability | Windows | ||
Fixes an issue where you encounter an "ex_terminator - Last chance exception handling" memory dump. The memory dump is associated with a lease timeout while the recovery of an Always On availability groups (AG) database is in progress. | High Availability | Windows | ||
5008107 | Improvement: Cardinality estimation in Spatial TVF functions in SQL Server 2019 | SQL Engine | All | |
4538688 | FIX: Severe spinlock contention occurs in SQL Server 2019 | SQL Engine | All | |
5004936 | FIX: Error when you use column store indexes and run versioned scans if all rows in a compressed row group are deleted in SQL Server 2017 and 2019 | SQL Engine | All | |
5007794 | FIX: Non-yielding scheduler dumps during the recovery of a secondary availability database with a database snapshot | SQL Engine | All | |
5007719 | FIX: Creating a resumable clustered index on a table with LOB causes corruption in SQL Server 2019 | SQL Engine | All | |
5007744 | FIX: Add checkpoint handling for the first row in Non Optimized Get And Insert Rows | SQL Engine | All | |
5008114 | FIX: The built-in SESSION_CONTEXT returns wrong results in parallel plans | SQL Engine | All | |
5008184 | FIX: ForceLastGoodPlan doesn't account for aborted and timed out queries in regression detection logic | SQL Engine | All | |
5008296 | FIX: Missing change data capture cleanup execution isn't identified because of a deadlock without an error message | SQL Engine | Windows | |
Fixes an issue where the CollectPageLatchFields can cause an access violation (AV) under certain timing conditions when the latch_suspend_end XEvent is turned on. The underlying reason is that this method assumes the Buffer is stable under the latch, which isn't true if the Buffer isn't in the Hashtable anymore. This hotfix avoids the AV by checking whether the Buffer is still in the Hashtable before accessing its underlying fields. | SQL Engine | All | ||
Fixes an Access Violation (AV) at RbpEarlyFilter::TinyBitmapFilterSIMD that occurs when you run queries on CLUSTERED COLUMNSTORE INDEX (CCI) tables. Here is the dump file: Stack Dump being sent to SqlDumpExceptionHandler: Process 247 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. BEGIN STACK DUMP: Exception Address = Module(sqlmin+) Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION Access Violation occurred reading address | SQL Engine | All | ||
Fixes the EXCEPTION_INVALID_CRT_PARAMETER dump that is generated on insert or update of wide replicated table. | SQL Engine | Windows | ||
Fixes the failed assertion that occurs due to implicit conversion where predicate's precision is greater than the value. Msg 3624, Level 20, State 1, Line A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agree to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support. Msg 596, Level 21, State 1, Line Cannot continue the execution because the session is in the kill state. Msg 0, Level 20, State 0, Line A severe error occurred on the current command. The results, if any, should be discarded. | SQL Engine | Windows | ||
Fixes the following runtime error that occurs when you build a 32-bit application where Microsoft.SqlServer.Rmo.dll is referenced from C:\Program Files (x86)\Microsoft SQL Server\150\SDK\Assemblies\ but Microsoft.SqlServer.Replication.dll isn’t cached in GAC_32 folder (C:\Windows\Microsoft.NET\assembly\GAC_32) with SQL Server 2019: System.IO.FileNotFoundException HResult=0x80070002 Message= Could not load file or assembly 'Microsoft.SqlServer.Replication, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. | SQL Engine | Windows | ||
Fixes an issue where SQL Server 2019 stops responding and crashes due to "ex_terminator - Last chance exception handling" when you use SQL Server Service Broker. | SQL Engine | Windows | ||
Fixes an Access Violation (AV) that can occur when you run dynamic management views (DMVs) queries. | SQL Engine | Windows | ||
5007842 | FIX: An assertion occurs when Compute Scalar operator operates on computed, temporary lobs with batch mode | SQL performance | Windows | |
Fixes an issue where executing a query with BATCH_MODE_ON_ROWSTORE = ON causes the following error and a dump occurs during compilation of the execution plan: Msg 596, Level 21, State 1, Line Cannot continue the execution because the session is in the kill state. Msg 0, Level 20, State 0, Line A severe error occurred on the current command. The results, if any, should be discarded. | SQL performance | All | ||
Fixes a non-yielding scheduler dump in sqldk!SOS_MemoryWorkSpace::Lookup. | SQL performance | All | ||
Fixes an issue in which the query processor can’t produce a query plan if the USE PLAN hint specifies a query plan that has a left outer join and an inner join. | SQL performance | Windows | ||
Fixes a self-deadlock issue where thread always waits for HASH_TABLE_DELETE (HTDELETE) when you run parallel query in batch mode. | SQL performance | Windows | ||
Fixes an issue causing the assertion fNoReaderWriterConflict. | SQL performance | Windows | ||
Fixes an issue where the following warning message occurs during the snapshot creation when you run the DBCC CHECKDB against a database that has a memory optimized filegroup: [WARNING] Unable to create PerfCounter instance for DB xx (xxx): 0x800700b7. | In-Memory OLTP | Windows |
KB | Description | Fix area | Platform | Learn More |
5006359 | FIX: A dump occurs if you use the same synonym for a user-defined function in the view definition | SQL Engine | All | |
Fixes an issue where 22836 error occurs when you add CDC job again after deleting CDC capture and removing jobs in SQL Server Agent | SQL Engine | All | ||
Fixes an issue where Polybase is not generating the partition predicates for pushdown which generates the following error when you do cross-database joins in the backend where one or more of the tables is partitioned: Msg 7320, Level LineNumber, State 110, Line LineNumber Cannot execute the query "Remote Query" against OLE DB provider "MSOLEDBSQL" for linked server "(null)". 105082;Generic ODBC error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name '$partition.PF_Polybase' | SQL Engine | All | ||
Adds improvement to enable distributed availability group and service broker connections with Azure SQL Managed Instance | High Availability | All | ||
Adds improvement to certificate-based authentication between endpoints for database mirroring and service broker connections, facilitating rotation and management of certificates issued by a certificate authority | High Availability | All | ||
Fix an issue where AD Authentication in SQL Server BDC encounters an error "enctype aes256-cts found in keytab but cannot decrypt ticket" if support for 128-bit and 256-bit Kerberos AES encryption is enabled | SQL Engine | Linux | ||
Adds improvement to enable timezone configuration as a Big Data Cluster (BDC) cluster-level setting | SQL BDC | Linux | ||
Fixes an issue where you cannot edit jobs by using SQL Server Management Studio (SSMS) if SQLAgent permissions are granted at AD group level | SQL Engine | Linux | ||
4530907 | Improvement: Corrupted statistics can be detected by using extended_logical_checks in SQL Server 2016, 2017, and 2019 | SQL Engine | Windows | |
5005788 | FIX: Access violation occurs when you use FileTable feature with Windows Defender enabled | SQL Engine | Windows | |
5005832 | FIX: Cannot fetch a row by using OPENROWSET or OPENDATASOURCE and "MSOLEDBSQL" OLE DB driver for SQL Server in batch mode | SQL Performance | Windows | |
5006632 | FIX: An assertion dump occurs many times in SQL Server 2019 | SQL Engine | Windows | |
5006665 | Improvement: Last Writer Wins and support for P2P database in Availability Group | SQL Engine | Windows | |
Fixes an intra-query deadlock that occurs with certain queries when verbose truncation feature is enabled | SQL Engine | Windows | ||
Fixes an Access Violation that occurs in SQL Server 2019 when you attempt to add file to database that has backup in progress | SQL Engine | Windows | ||
Adds pOwnerSess to the error message to find the owner session Id that runs the Log Reader Agent or log - related procedure in SQL Server 2017 | SQL Engine | Windows | ||
Fixes an issue where an incorrect name entry in sys.servers can result in Always On Availability Group (AG) replica being removed when the server name does not match Windows hostname | High Availability | Windows | ||
Fixes an issue where Memory Optimized TempDB Metadata keeps consuming memory under VARHEAP: LOB Page Allocator | In-Memory OLTP | Windows | ||
Fixes an issue where the assertion results in system suspend of asynchronous secondary replica: DateTime spid36s SQL Server Assertion: File: , line=LineNumber Failed Assertion = 'curr->VlfSeqNo == prev->VlfSeqNo + 1'. This error may be timing-related. restart the server to ensure in-memory data structures are not corrupted | High Availability | Windows | ||
Fixes an issue where you cannot complete image because the prepared instance is grayed out if you select [Database Engine Services] along with [Machine Learning Services and Language Extensions]- [Java] in Prepare Image | Setup & Install | Windows | ||
Fixes an issue about extended event version in Alwayson_health session is not changed automatically during Cumulative Update upgrade and downgrade | High Availability | Windows | ||
Fixed an issue where resumable clustered index creation may sometimes fail if a table has lots of LOB columns | SQL Engine | Windows |
KB | Description | Fix area | Platform | Learn More |
5001045 | FIX: Memory grant wait times out when you run many Columnstore bulk inserts concurrently in SQL Server 2017 and 2019 | SQL Engine | All | |
5004733 | FIX: Debug assert when a lock is acquired by the ParNested Transaction and attempts to get logged in sLog for the parent transaction | SQL Engine | All | |
5004734 | FIX: Persisted computed columns not being consistently blocked for Columnstore index | SQL Engine | All | |
5004936 | FIX: Error when you use columnstore indexes and run versioned scans if all rows in a compressed rowgroup are deleted in SQL Server 2019 | SQL Engine | All | |
Fixes an issue that causes the SQL Server to terminate. ex_terminator - Last chance exception handling | SQL Engine | All | ||
Fixes an issue where optimizer doesn't push down constant parameters to remote query via linked server | SQL performance | All | ||
Ensures that the correct error is returned, when an invalid table name is referenced inside a SHORTEST_PATH query on graph tables in SQL Server | SQL performance | All | ||
Fixes an issue where you see USERSTORE_SCHEMAMGR grow uncontrollably and eventually leading to memory contention issues when you use graph queries in SQL Server 2019 | SQL performance | All | ||
5004750 | FIX: SQL Server often crashes when network.forceencryption property is set to '1' | SQL Engine | All | |
Fixes an issue in SQL Server 2019, if IPv6 is disabled on Linux in the bootloader (GRUB), PolyBase will fail to start | SQL Engine | All | ||
5004560 | FIX: Wrong results during Clustered Columnstore Index alter "index reorganize" in versioned scans in SQL Server 2017 and 2019 | SQL Engine | Windows | |
5004573 | FIX: SQL Server affinity settings are reset after applying CU for SQL Server 2019 | SQL Engine | Windows | |
5004649 | FIX: Parallel redo failure on secondary replica in SQL Server 2019 | High Availability | Windows | |
5005321 | FIX: Dropping an index from the view on the primary may cause access violation on readable secondary | SQL performance | Windows | |
Fixes an issue where running a Full Database Backup on a read-only database containing memory optimized objects fails with the error 3906 "Failed to update database "" because the database is read-only." | SQL Engine | Windows | ||
Fixes a second exception that occurs when trying to generate a dump on a latch timeout issue and crashes the SQL service entirely | High Availability | Windows | ||
Fixed the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all the memory available is taken | SQL Engine | Windows | ||
Fixes an issue in SQL Server 2019 where you may encounter an Access Violation or Assertion when using the sys.dm_exec_query_statistics_xml Dynamic Management View | SQL performance | Windows | ||
Fixes an issue where frozen I/O leads to latch timeout on database boot page (1:9) and leads to suspended availability group database REDO thread | SQL Engine | Windows | ||
Fixes an issue where creating an availability group with automatic seeding fails with the error: "Error: 4353 - Conflicting file relocations have been specified for file ''. Only a single WITH MOVE clause should be specified for any logical file name." due to a database where some files have been created, deleted several times with the same logical filename. | High Availability | Windows | ||
Fixes the access violation that occurs when you use graph shortest path expressions with LIKE predicates | SQL performance | Windows | ||
Adds improvement to report SQL Server native error 35217 in the AlwaysOn_health XEvent log: DateSpid Error: 35217, Severity: 16, State: 1. DateSpid The thread pool for Always On Availability Groups was unable to start a new worker thread because there are not enough available worker threads. This may degrade Always On Availability Groups performance. Use the "max worker threads" configuration option to increase number of allowable threads. | High Availability | Windows | ||
Fixes missing data in the Change Data Capture (CDC) side table and adds additional error handling to prevent data loss | SQL Engine | Windows | ||
Fixes an issue where NULL values are populated for the $from_id, $to_id columns in a graph edge table when batch mode execution is chosen in SQL Server 2019 | SQL performance | Windows | ||
Adds improvement to replace High Availability Disaster Recovery (HADR) related logs output by Trace Flag (TF) 3605 to the errorlog to a new extended event hadr_trace_message which is written to the alwayson_health session | High Availability | Windows | ||
Fixes the access violation that occurs at sqllang!srv_nameinfo::SkipOptionalTransportProvider in SQL Server 2019 | SQL connectivity | Windows |
KB | Description | Fix area | Platform | Learn More |
4535851 | FIX: Scalar UDF Inlining issues in SQL Server 2019 | SQL Engine | All | |
5003525 | Improvement: ADLS Gen2 support for External Tables | SQL Engine | All | |
5003589 | FIX: Error 19432 occurs when Log Writer thread fails to send a log back and stop log capture on Log Writer threads in SQL Server 2019 | High Availability | All | |
5003596 | FIX: Log line is extremely high when Always On Availability Group has many databases in SQL Server 2019 | High Availability | All | |
5003870 | SQL Engine | All | ||
FIX: Support using the PolyBase SQL Server connector to create external table with remote database name containing a period | ||||
Fixes an issue where executing a PolyBase related query encounters error "Invocation of TransactionStateCreate resulted in -1" and causes PolyBase Data Movement service memory dump | SQL Engine | All | ||
Fixes failures in PolyBase queries involving date/time literals or integer divisions that may occur when the Microsoft Spark ODBC driver is used to connect to a generic ODBC external data source | SQL Engine | All | ||
Fixes the high SOS_SUSPEND_QUEUE spinlock contention with parallel window aggregate | SQL Engine | All | ||
Fixes an issue where the JVM will eventually crash with an out of memory error after a certain number of queries due to threads not being properly cleaned up in certain scenarios when you use PolyBase Hadoop bridge data sources in SQL Server 2019 on Linux | SQL Engine | Linux | ||
Fixes an issue which leads to the impossibility of creating JAVA dumps and thus hampers debuggability and supportability when a PolyBase JAVA HadoopBridge process is started under Linux, an invalid -XX:HeapDumpPath JVM option is passed to the JVM | SQL Engine | Linux | ||
4023170 | FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014 | SQL Engine | Windows | |
5003342 | SQL Engine | Windows | ||
FIX: SQL Server Express LocalDB can't start or connect to shared instances of SQL Server Express LocalDB 2019 or 2017 | ||||
5003750 | FIX: Performance issues occur when metadata is scanned to find keys to be sent to the AE enclave in SQL Server 2019 | SQL security | Windows | |
5003869 | FIX: Support schema reflection stored procedures for the Polybase generic ODBC connector | SQL Engine | Windows | |
5003937 | Improvement: New XEvents temp_table_cache_trace and temp_table_destroy_list_trace are created in SQL Server 2019 | SQL Engine | Windows | |
Prevents ghost cleanup from triggering a memory dump during latch time-out in SQL Server 2019 | SQL Engine | Windows | ||
Fixes the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all the memory available is taken | ||||
Fixes an issue where sp_hadr_verify_replication_publisher displays wrong distribution database name in error | SQL Engine | Windows | ||
Fixes an issue where an availability group database restart process is blocked when the database is transitioned to a new state because of an availability group failover or lease timeout on the primary replica | High Availability | Windows | ||
Fixes the error 3628 that occurs frequently when In-Memory OLTP is enabled in SQL Server 2019 and you may receive an error message as shown below: DateTime Error: 3628, Severity: 16, State: 1. | SQL Engine | Windows | ||
DateTime The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator. | ||||
Fixes an issue where Setup Account Privileges check may not performed when installing CU or Security Update | Setup & Install | Windows | ||
Adds improvement to increase the default size and file retention on AlwaysOn_health. | High Availability | Windows | ||
Note The current definition for the AlwaysOn_health XEvent session has a maximum file size of 5 megabytes (MB) and maximum number of files of 4, for a maximum of 20 MB of AlwaysOn_health XEvent data. On a busy system, you can roll over this limitation quickly and miss important information in the event of an issue that affects the system. In order to keep more troubleshooting data available on the system, the default file size is changed from 5 MB to 100 MB and the default number of files is changed from 4 to 10, for a maximum of 1 GB of AlwaysOn_health XEvent data, in this update. If the definition of the AlwaysOn_health session has already been modified from the default values, this improvement will not overwrite the existing settings. | ||||
Fixes a potential issue that causes error 5511 when performing a log backup on a database that has filestream data | SQL Engine | Windows | ||
Fixes an issue that causes database log_reuse_wait_desc to change to AVAILABILITY_REPLICA when a database is removed from Availability Group | High Availability | Windows | ||
When published database is part of availability group and listener is on a non-default port, replication monitor doesn’t display publication and subscription information. This CU fixes that issue. | SQL Engine | Windows | ||
Fixes the performance issues that occur with concurrent executions of stored procedures on CHANGETABLE and syscommittab by enforcing index seek on change tracking side tables in SQL Server 2019 | SQL performance | Windows | ||
Fixes an issues that causes query to be stuck in BATCH_MODE_SORT in SQL Server 2019 | SQL performance | Windows |
KB | Description | Fix Area | Platform | Learn More |
4548523 | FIX: Database creation to Azure blob storage from SQL Server 2017 or 2019 on Linux may fail with error | SQL Engine | All | |
5000649 | FIX: Wrong results due to undetected concatenation parameters from scalar expression | SQL performance | All | |
5001044 | FIX: Wrong results occur when you run a query on In-memory optimized tables in SQL Server | In-Memory OLTP | All | |
5001260 | Improvement: Performance improvements of several spatial built-in properties and methods in SQL Server | SQL Engine | All | |
5001266 | FIX: Access Violation occurs when hybrid buffer pool is enabled in SQL Server 2019 | SQL Engine | All | |
5001517 | FIX: Metadata deadlock causes availability issues when changing auditing properties in SQL Server 2019 | SQL security | All | |
5001526 | FIX: Access violation occurs when Dynamic Data Masking and nested UDFs are used in SQL Server 2019 | SQL security | All | |
Fixes an issue that enables Block Caching for MMLarge memory model in SQL Server 2019 | SQL Engine | All | ||
Fixes an Access Violation (AV) that occurs when error is being collected for Availability Group (AG) DB Failover while there is an AG failover undergoing | High Availability | All | ||
Improvement: Records stage of failure and error during stack copy for better diagnostics | SQL Engine | All | ||
Fixes an issue where you notice that spurious CAST operations in PolyBase external pushdown queries can dramatically affect the performance with some backends | SQL Engine | All | ||
Disables FQDNs in AD usernames when creating/modifying SQL Logins/users for SQL Server 2019 on Linux | SQL Engine | Linux | ||
Fixes an issue where a failed network connection results in a socket leak | SQL Engine | Linux | ||
Improves AD keytab rotation by properly handling the keytab entries with future KVNOs when SSSD is disabled | SQL Engine | Linux | ||
Fixes a high HADR_SYNC_COMMIT waits which may show on SQL Server with heavy workload after you apply CU7 | SQL Engine | Linux | ||
SQL Server Service is not starting and failing with core dump after applying SQL Server 2019 CU8 | Big Data Cluster (BDC) | Linux | ||
SQL Server Service is not starting and failing with core dump after applying SQL Server 2019 CU8 | SQL Engine | Linux | ||
Fixes an issue in SQL Server 2019 where kubeadm-prod install hangs on compute/master pods when netbios name and ouDistinguishedName have mismatch | Big Data Cluster (BDC) | Linux | ||
4486936 | FIX: "Login failed for user" error occurs when you run Maintenance plan with SQL login account in SQL Server | SQL Engine | Windows | |
4589350 | FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server | SQL performance | Windows | |
5000650 | FIX: Incorrect results occur when you run query on In-memory optimized table that has clustered columnstore index in SQL Server 2016 or 2019 | In-Memory OLTP | Windows | |
5000715 | FIX: Failures with log reader agent occurs when you create and drop publication on CDC enabled database in SQL Server 2016 and 2019 | SQL Engine | Windows | |
5001159 | FIX: Assertion failure occurs when Online Clustered Columnstore Index Rebuild reuses truncated hobt instead of new hobt in SQL Server 2019 | SQL Engine | Windows | |
When a VSS backup tries to back up SQL Server databases that are hosted on the forwarder replica of a Distributed Availability Group, the backup operation fails. This BACKUP or RESTORE command is not supported on a database mirror or secondary replica. BACKUP DATABASE is terminating abnormally. In the error log, you may see the following error: DateTime Backup Error: 3041, Severity: 16, State: 1.. DateTime Backup BACKUP failed to complete the command BACKUP DATABASE DatabaseName. Check the backup application log for detailed messages. | SQL Engine | Windows | ||
Allows pushdown of filter predicate for PolyBase query that utilizes FORMAT or TRIM functions in the SELECT clause if the query is otherwise qualified for pushdown | SQL Engine | Windows | ||
Query execution may experience an intra-query deadlock if the query plan is using a single threaded batch mode sort operator before a Repartition Streams Parallelism operator | SQL Engine | Windows | ||
Fixes to keep 'PERSIST_SAMPLE_PERCENT' value for statistics on an indexed column after index rebuild | SQL performance | Windows | ||
Fixes an issue where synchronizeSecurity setting of AMO method 'Microsoft.AnalysisServices.Tabular.Server.Synchronize' shown in Server.Synchronize Method is ignored | Analysis services | Windows | ||
Fixes an issue with performance when tabular queries in SSAS 2019 take more time to execute compared to SSAS 2016 | Analysis services | Windows | ||
Fixes an issue with the Foreign Key added to a table that is referencing a table's column which is part of a unique index with included columns. When the table's ALTER command is replicated, Distribution Agent fails with the following error message Number of referencing columns in foreign key differs from number of referenced columns, table 'TableName'. (Source: MSSQLServer, Error number: 8139) | SQL Engine | Windows | ||
Fixes an issue where the query based on full-text indexes is not returning the expected values | SQL Engine | Windows | ||
Fixes an Access Violation error that can occur when you import large amount of data to Windows Azure Blob storage. This can occur if PolyBase Data Movement Service encounters out-of-memory condition during large data insert transaction. | SQL Engine | Windows | ||
Fixes an issue where out of memory occurs when you take a log backup frequently and Stolen Server Memory grows at an synchronous secondary in Availability Groups | High Availability | Windows | ||
Fixes an issue where DBCC PAGE with option 3 generates access violation dumps after dropping a unique identifier column from the table in SQL Server 2019 Msg 596, Level 21, State 1, Line LineNumber Cannot continue the execution because the session is in the kill state. Cannot continue the execution because the session is in the kill state. Msg 0, Level 20, State 0, Line LineNumber A severe error occurred on the current command. The results, if any, should be discarded. | SQL Engine | Windows | ||
Fixes an issue where query compilation that involves auto create statistics fails with the following error log: Datetime spidId Error: 3628, Severity: 16, State: 1. Datetime spidId The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator. | SQL performance | Windows | ||
Fixes an issue where performance counter Data File(s) Size (KB) doesn’t report the correct total size of database files if one file is created with initial size > 4 TB or grown by more than 4TB | SQL Engine | Windows | ||
Adds a new option to free the LogPool cache only: DBCC FREESYSTEMCACHE('LogPool') | SQL Engine | Windows | ||
Fixes the unexpected date conversion on some special date format | Data Quality Services (DQS) | Windows | ||
Fixes the following dump exception after login failures in SQL Server 2019: ex_raise2: Unhandled exception raised, major=36, minor=2, state=52, severity=25 | High Availability | Windows |
KB | Description | Fix area | Platform | Learn More |
4538581 | FIX: Scalar UDF Inlining issues in SQL Server 2019 | SQL Engine | All | |
4588980 | FIX: Higher than expected number of single row Columnstore rowgroups may be generated for Columnstore bulk insert when both large page allocator and scalable Columnstore bulk insert features are turned on | SQL Engine | All | |
4588983 | FIX: CREATE STATISTICS WITH SAMPLE PERCENT command fails with error when Oracle data source has partitioned table | SQL Engine | All | |
5000649 | FIX: Wrong results due to undetected concatenation parameters from scalar expression | SQL performance | All | |
5000655 | FIX: Memory leak may occur when SQL Server auditing feature is used on an instance of SQL Server 2019 | SQL Security | All | |
5000656 | FIX: Incorrect type of data mask is applied when DDM is used with queries that have UDFs in SQL Server 2019 | SQL Security | All | |
5000670 | FIX: Error occurs when you map an Oracle NUMBER type to a T-SQL DECIMAL/NUMERIC type | SQL Engine | All | |
5000671 | FIX: Error occurs when casting non-Unicode string column using a Unicode-only UTF8 collation in SQL Server 2019 | SQL Engine | All | |
5000672 | FIX: Fixes reading of NULL Time fields for non-sqlserver backends | SQL Engine | All | |
Fixes Graph LAST_NODE =LAST_NODE predicate issue by including a second pass for LAST_NODE expressions and to include an appropriate predicate in the query tree | SQL performance | All | ||
Fixes an Access violation that occurs when showplan xml Xevent is enabled, and an in-memory procedure containing a 'select without FROM clause' is executed | SQL performance | All | ||
Fixes the Assertion failure that occurs when group properties for CLeafOp children are derived | SQL performance | All | ||
Enables async path for PolyBase remote query and add cleanups for timeout/abort in SQL Server 2019 | SQL Engine | All | ||
Fixes the query hang issue that occurs in SQL Server 2019 when querying an external table through PDW | SQL Engine | All | ||
Adds a randomization logic when mapping writers to pods in SQL Server 2019 | SQL Engine | All | ||
New logging and XEvents to help troubleshoot long-running Buffer Pool scans | SQL Engine | All | ||
Fixes Query Store scalability improvement for ad-hoc workloads. Query Store now imposes internal limits to the amount of memory it can use, and automatically changes the operation mode to read-only until enough memory has been returned to the Database Engine, preventing performance issues | SQL Engine | All | ||
This fix makes sure that when the "EXECUTE ('sql query') AT DATA_SOURCE [mydatasource]" query is executed, the connection options of [mydatasource] will be used when connecting to that data source | SQL Engine | All | ||
Fixes an issue with PolyBase SQL dump hash computation that uses MD5 which is not FIPS compliant | SQL Engine | All | ||
Fixes an issue where PolyBase fails when it is deployed on a platform (Windows or Linux) and the control node hostname resolves to an IPv6 | SQL Engine | All | ||
Fixes an issue where an online index operation using when_supported will fail on LOBs if in a transaction that has already done an update | SQL Engine | All | ||
Fixes an issue where the PolyBase query against the backend may result in a dump of the PolyBase engine process when you try to resolve partitioning information and the connection to an external database backend is unreliable or interrupted | SQL Engine | All | ||
When you use EXECUTE with AT DATA_SOURCE in SQL Server 2019, the query gets truncated at 8000 byte length and may cause errors or wrong results | SQL Engine | All | ||
Adds improvement to increase the default size and file retention on AlwaysOn_health. NoteThe current definition for the AlwaysOn_health XEvent session has a maximum file size of 5 megabytes (MB) and maximum number of files of 4, for a maximum of 20 MB of AlwaysOn_health XEvent data. On a busy system, you can roll over this limitation quickly and miss important information in the event of an issue that affects the system. In order to keep more troubleshooting data available on the system, the default file size is changed from 5 MB to 100 MB and the default number of files is changed from 4 to 10, for a maximum of 1 GB of AlwaysOn_health XEvent data, in this update. If the definition of the AlwaysOn_health session has already been modified from the default values, this improvement will not overwrite the existing settings. | SQL Engine | All | ||
4588977 | FIX: SQL Server crashes when Afd!DbCreateSocketOperation process fails | SQL connectivity | Linux | |
4588979 | FIX: Fail to create AG on top of FCI in SQL Server 2019 | High Availability | Linux | |
5000663 | FIX: Database mail doesn't send e-mail messages when IP address is specified in mssql-conf | SQL Engine | Linux | |
5000669 | Improvement: Adds a new external generic query builder in SQL Server 2019 | SQL Engine | Linux | |
Fixes an error that occurs when you execute a query by using sp_send_dbmail inside a SQL Agent Job to send mails with attachments | SQL Engine | Linux | ||
Fixes the non-yielding scheduler condition that occurs when AG listener is created with invalid IP address in SQL Server 2019 on Linux | SQL Engine | Linux | ||
Fixes an issue where deployment is stuck in 'WaitingForControlPlaneFilesDownload' state with ObjectDisposedException in controller | Big Data Cluster (BDC) | Linux | ||
Fixes infinite loop in VDI due to improper initialization of errno variable | SQL Engine | Linux | ||
Fixes an issue where SQL process is not killed properly resulting in subsequent start of SQL Server fails when the AG-Helper send the KILL 9 command to terminate the SQL Server process | High Availability | Linux | ||
Updates the Zulu JRE version to mssql-zulu-jre-11.43.56-1 and mssql-zulu-jre-8-8.50.0.52-1 | SQL Engine | Linux | ||
4538688 | FIX: Severe spinlock contention occurs in SQL Server 2019 | SQL Engine | Windows | |
4547890 | FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server | Integration services | Windows | |
4565944 | Improvement: A manual method to set maximum group commit time in SQL Server 2017 and 2019 | High Availability | Windows | |
4568447 | FIX: Automatic seeding failure occurs for a secondary replica in SQL Server 2016 and 2019 | High Availability | Windows | |
4569837 | FIX: Intermittent connection error occurs when an expression is used for both connection string and password of a connection manager | Integration services | Windows | |
4575689 | 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 | SQL Performance | Windows | |
4575939 | FIX: Log reader agent generates access violation exception for P2P or transactional replication with partitioning tables in SQL Server 2016 and 2019 | SQL Engine | Windows | |
4575940 | FIX: Newly added articles' snapshot doesn't get applied to subscriber in SQL Server 2016 and 2019 | SQL Engine | Windows | |
4577932 | FIX: Access Violation exception occurs in Availability Groups in SQL Server 2017 under certain conditions | High Availability | Windows | |
4577933 | FIX: Cascade delete on key values outside of leading table histogram bounds causes index scan in SQL Server 2017 and 2019 | SQL Performance | Windows | |
4577976 | FIX: COMPILE blocking occurs when executing many concurrent stored procedures in SQL Server 2017 and 2019 | SQL Performance | Windows | |
4580397 | FIX: Incorrect results occur when you run INSERT INTO SELECT statement on memory-optimized table variables in SQL Server | In-memory OLTP | Windows | |
4585971 | FIX: User session is in rollback state indefinitely after it is killed in SQL Server 2016 | SQL Engine | Windows | |
4588978 | FIX: Statistics are ignored when a query is run on PolyBase external table in SQL Server 2019 | SQL Engine | Windows | |
4588981 | FIX: "LogConsumer::StartScan failed to get the control lock" error occurs and the log writer activity stops completely in SQL Server 2019 | High Availability | Windows | |
4588982 | FIX: sys.dm_exec_requests returns transaction_id as "0" in certain scenarios in SQL Server 2019 | SQL Engine | Windows | |
4588984 | FIX: Contention on XVB_List spinlock in highly concurrent workloads when using RCSI | SQL Engine | Windows | |
4589170 | FIX: Indefinite hang occurs during cube processing after applying SSAS 2016 SP2 CU7 | Analysis services | Windows | |
4589171 | FIX: Unexpected error occurs when a query is run on an instance of SSAS | Analysis services | Windows | |
4589345 | FIX: Error 3625 occurs during query execution when batch mode on rowstore is enabled in SQL Server 2019 | SQL performance | Windows | |
4589350 | FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server | SQL performance | Windows | |
4594016 | FIX: Assertion failure error occurs on sqlmin.dll!XdesRMBase::StartStmtSnapshot in SQL Server 2019 | SQL Engine | Windows | |
5000895 | Improvement: New trace Flags for better maintenance of deleted rows in Clustered Columnstore Index | SQL Engine | Windows | |
Improves SSISDB performance by adding indexes to event_message_context and execution_property_override_values tables in SQL Server 2019 | Integration services | |||
FIX: Query returns different result set when run on In-memory optimized tables and disk-based tables in SQL Server 2019 | SQL performance | Windows | ||
Fixes an issue where selecting from sys.databases when there are a large number of databases in SQL Server 2019 take longer time to execute when compared to earlier versions of SQL Server | High Availability | Windows | ||
Fixes an Access violation error that occurs whenever 'sp_refreshsqlmodule' function is executed quickly several times in a row causing a stack dump to be generated | SQL Engine | Windows | ||
FIX: SSIS ScaleOut Execution intermittently reports "Unexpected Termination" in the execution status but all tasks gets completed successfully | Integration services | Windows | ||
Fixes Monitor and Sync replication agentjob error that occurs when a job runs on the new secondary replica after failover of the Availability Group that hosts the distribution database for transactional replication. | SQL Engine | Windows | ||
DBCC SHRINKFLE or SHRINKDATABASE can cause an assertion exception error when executed against database or files containing system-versioned temporal tables | SQL Engine | Windows | ||
Fixes Recursive hierarchy in explore page that is not working properly in MDS version 2019 | Data Quality Services (DQS) | Windows | ||
Fixes an access violation exception that occurs while querying sys.dm_db_stats_properties for a table with a spatial index in SQL Server 2019 | SQL performance | Windows | ||
Fixes deadlocks that occur in [catalog].[set_execution_property_override_value] | Integration Services | Windows | ||
Fixes an issue where the session gets killed when you run DBCC CHECKTABLE with PHYSICAL_ONLY due to disk full. The session remains in KILLED\ROLLBACK state and threads are waiting on CHECK_TABLES_THREAD_BARRIER wait type with increasing wait time | SQL Engine | Windows | ||
Unable to connect to primary database replica after failing over the Availability Group in SQL Server | High Availability | Windows | ||
When running a RESTORE HEADERONLY of a SQL Server 2016 backup you may notice error 3285 even if the correct block size has been specified. If the error persists after applying this fix, specify the proper block size or contact Microsoft Support for assistance | SQL Engine | Windows | ||
FIX: When you try to restore from a compressed or encrypted backup over an existing TDE enabled database, you may notice that the restore operation may take longer time than expected | SQL Engine | Windows | ||
FIX: VERIFY_CLONEDB prints message 'Clone database verification has failed' for the database if the database name starts with a number | SQL Engine | Windows | ||
Fixes SQL Server Assertion that occurs when the availability group is failed over manually to another replica. The failover succeeds however, the databases from the earlier primary (now the secondary) where the AG was failed from, does not come online and generates the assertion dumps. File: , line=LineNumber Failed Assertion = 'inCorrectOrder' | SQL Engine | Windows | ||
Fixes Non-yielding Scheduler error that may occur when Query Store tries to grow its memory structure during heavy workload | SQL Engine | Windows | ||
Fixes the issue of sending done token before sending the session kill state when session got killed. This fixes the issue of incorrect session state that occurs when a session is killed on SQL Server external data source instance | SQL connectivity | Windows | ||
Fixes an error that occurs when a change tracking function is called in MSTVF. Msg 443, Level 16, State 1, Procedure ProcedureName, Line LineNumber [Batch Start Line LineNumber] Invalid use of a side-effecting operator 'change_tracking_current_version' within a function. | SQL Engine | Windows | ||
Forwarder is unable to reconnect to global primary following Global primary planned failover if the LISTENER_URL is modified | High Availability | Windows | ||
Fixes an error where you may receive the following error when you restore a TDE enabled database from a backup with compression option and "with file =" option is greater than 1 Msg 3241, Level 16, State 40, Line LineNumber The media family on device 'FilePath\FileName' is incorrectly formed. SQL Server cannot process this media family. | SQL Engine | Windows | ||
When the full-text service fdhost is attempting to index a column with the content of type .eml using the filter c:\windows\system32\mimefilt.dll version 2008.0.19041.1, the fdhost.exe process stops with 0xc0000409 STATUS_STACK_BUFFER_OVERRUN. | SQL Engine | Windows | ||
Fixes an access violation dump that occurs after you run a query by using OUTER APPLY on sys.dm_db_index_operational_stats | SQL Engine | Windows | ||
Fixes an issue where stack dumps may be generated frequently due to failed assertions and access violations when you enable Memory-Optimized tempdb Metadata (HkTempdb) | SQL Engine | Windows | ||
FIX: SQL Agent job fails with a sharing violation when writing to step output file in SQL 2019 | Management Tools | Windows | ||
Fixes an issue where a database restore fails with an error 3257 (insufficient free space error) when the database is larger than 2TB. The issue happens when the TotalAllocationUnits on the target volume is more than 4,294,967,295 units, for example when the target volume is larger than 16TB and uses an allocation unit size = 512 bytes and a single sector per cluster. | SQL Engine | Windows | ||
Fixes an issue where an access violation exception may occur when you execute queries in read uncommitted mode with high concurrent read or write pattern over XML data types. | SQL Engine | Windows | ||
Updates the Zulu JRE version to mssql-zulu-jre-11.43.56 | SQL Engine | Windows | ||
FIX: When the master SSIS package calls multiple child packages and their connection managers are parameterized, the SSIS package execution fails with UNEXPECTED TERMINATION or INVALID CONNECTION STRING ATTRIBUTE error while updating connection strings. | Integration services | Windows | ||
Adds a new option to free the LogPool cache only: DBCC FREESYSTEMCACHE('LogPool') | SQL Engine | Windows | ||
FIX: Assertion or RaiseInconsistencyError occurs when you use VersionStoreTableAccess::PopulateRowData on SQL 2019 Always On Availability Group Readable replica, but actually there is no corruption | High Availability | Windows | ||
Fixes the assertion failure that occurs at FAILED_ASSERTION_42ac_sqlmin.dll!LogLockCollectionVerify::Callback in SQL Server 2019 | SQL Engine | Windows |
KB | Description | Fix Area | Platform | Learn More |
Fixed an issue that reduced throughput and caused higher CPU when you run workloads that frequently allocate and release memory, such as XML related functions. | SQL Engine | All | ||
PATINDEX returns wrong result for non-Latin input string when you use Latin1_General_100_BIN2_UTF8 collation. | SQL Engine | All | ||
Python and R CAB files for SQL Server Machine Learning Services on Windows and mssql-mlservices packages on Linux are updated to version 9.4.7.958. On Windows, it fixes "Cannot resume session with terminated pooled process" error while launching Python/R runtimes. On Linux, it enables successful installation of mssql-mlservices-mlm-r package on RHEL8. | SQL Engine | All | ||
Query Store scalability improvement for adhoc workloads. Query Store now imposes internal limits to the amount of memory it can use and automatically changes the operation mode to READ-ONLY until enough memory has been returned to the Database Engine, preventing performance issues. | SQL Engine | All | ||
Updated error messages to remove inconsistent use of word SQL. | SQL Engine | All | ||
4579223 | FIX: PolyBase processes will be started to avoid dump during provisioning in SQL Server 2019 | SQL Engine | All | |
4580648 | FIX: Errors may occur or PolyBase services fail to start when you run PolyBase queries on a non-English OS | SQL Engine | All | |
4580413 | FIX: Deadlock occurs between Availability Group Configuration and Replica Transport State Lock in SQL Server 2019 | High Availability | All | |
This change improves external lease renew time for external cluster type in SQL Server 2019. | High Availability | All | ||
4580639 | FIX: PolyBase queries can now be run with EXECUTE AS impersonation context in SQL Server 2019 | SQL Engine | All | |
Fixed issue where ALTER AVAILABILITY GROUP SET (ROLE=SECONDARY) raises an error 41104. However, it doesn't impact the Always On Availability Group health. | High Availability | All | ||
Fixed an issue with excessive number of informational messages in the Error log when Accelerated Database Recovery (ADR) is disabled for a database. | SQL Engine | All | ||
4581882 | FIX: Restoring database fails due to backup command timeout in SQL Server 2019 | High Availability | Linux | |
4582558 | FIX: SQL Server 2019 service fails to start in Linux operating system | SQL Engine | Linux | |
4577837 | FIX: Queries may fail when storage pool caching is enabled by default in SQL Server 2019 Big Data Cluster | SQL Engine | Linux | |
4578292 | FIX: Error occurs when you try to deploy CU5 or CU6 for SQL Server 2019 BDC irrespective of the azdata version | Big Data Cluster (BDC) | Linux | |
4580949 | FIX: Snapshot agent fails when you create Transactional Publication with all tables and UDFs in SQL Server 2019 | SQL Engine | Windows | |
Fixed long package execution time involving SSIS task of type TransferSqlServerObjectsTask when database contains tens of thousands of tables and the db user is not db_owner. | Integration Services | Windows | ||
4578267 | FIX: Different result set for the same query using dm_sql_referenced_entities in SQL Server 2019 | SQL Engine | Windows | |
Fixed Web UI Explorer display issue in SQL Server 2019 Master Data Services (MDS) in which the column width remains constant irrespective of any display width configured at attribute level. | Data Quality service (DQS) | Windows | ||
4581886 | FIX: Joins not getting pushed down for PolyBase query that joins multiple external tables | SQL Engine | Windows | |
XEvent sqlsni.sni_trace does not fire unless sqlsni.trace is enabled in SQL Server 2019. | SQL connectivity | Windows | ||
Fixed issue where a plan does not get cached (no SP:CacheInsert in trace) when the Interleaved Execution for MSTVFs feature is used and the MSTVF contains a LOB parameter that requires a conversion. | SQL Engine | Windows | ||
4578579 | Improvement: Availability Group listener without the load balancer in SQL Server 2019 | High Availability | Windows | |
Fixed an unexpected error that occurs when you deploy a 1500 compatibility mode model with relationship and Direct Query mode ON. An unexpected error occurred (file 'FileName', line LineNumber, function 'FunctionName') | Analysis services | Windows | ||
4538688 | FIX: Severe spinlock contention occurs in SQL Server 2019 | SQL Engine | Windows | |
When an extended event that outputs a query plan is enabled, execution of a natively compiled stored procedure incorrectly included actual execution plan information in the output, which could cause errors if the client application does not expect such output. | In-memory OLTP | Windows | ||
SSAS Multidimensional deployment mode may encounter Access Violation (AV) upon Excel grouping with Create Session cube followed by MDSCHEMA_MEMBERS. AV exception may occur many times that SSAS may reach the maximum exception limit and eventually terminate. | Analysis services | Windows | ||
Fixed Master Data Services (MDS) Filter for Business Rule Validation which doesn’t show a reason for failure after 'x' number of records. | Data Quality Service (DQS) | Windows | ||
4580397 | FIX: Incorrect results occur when you run INSERT INTO SELECT statement on memory-optimized table variables in SQL Server 2016 | In-memory OLTP | Windows | |
4580915 | FIX: SQL Server error log receives several ADR enabled/disabled messages even when ADR isn't explicitly enabled/disabled | SQL Engine | Windows | |
Fixed an issue in SQL Server Analysis Services to allow users to use AVERAGE function with extension columns. | Analysis services | Windows | ||
4561305 | FIX: Concurrent inserts against tables with columnstore indexes may cause queries to hang in SQL Server 2016 and 2019 | SQL Engine | All | |
When you run a SELECT query in Read Committed Snapshot Isolation (RCSI) on Clustered Columnstore Index (CCI) on a table in SQL Server 2019, the query may return incorrect number of rows under rare conditions. | SQL Engine | All | ||
Fixes an assertion exception that occurs when you query the DMV sys.dm_hadr_automatic_seeding. | High Availability | All | ||
This update fixes an issue with sys.dm_db_stats_histogram not showing NULL value histogram step. | SQL performance | All | ||
4574801 | FIX: Incorrect results occur when you run PolyBase query to read text files from Hadoop in SQL Server 2019 | SQL Engine | All | |
4578395 | FIX: Error occurs when using DBCC operations while TDE key change happens in SQL Server 2019 | SQL security | All | |
4034376 | FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature of SQL Server | SQL Engine | All | |
4538581 | FIX: Scalar UDF Inlining issues in SQL Server 2019 | SQL Engine | All | |
Fixes failure of SQL Server Extensibility Runtimes Setup on FIPS compliant servers. | SQL Engine | All | ||
4577594 | FIX: Add language and extension directories to the PATH environment variable in SQL Server 2019 | SQL Engine | All | |
4576778 | FIX: Table Variable Deferred Compilation feature on SQL Server 2019 database remains enabled when database compatibility level is 140 or lower | SQL Engine | All | |
4577836 | FIX: Inconsistency occurs when ghost rows are inserted into mapping index rowset | SQL Engine | All | |
4578011 | FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size | SQL Engine | Linux | |
4575453 | FIX: SQL Server fails to start when remote admin connections are enabled and IPV6 is disabled on the host | SQL Engine | Linux | |
Improvement: Enables RLS feature for PolyBase by default in SQL Server 2019. | SQL Engine | Linux | ||
This updates adds detailed error information to the pacemaker log when pacemaker agent fails to connect to SQL Server resource to obtain health status. | High Availability | Linux | ||
4569424 | FIX: Intermittent Availability Group failover occurs as AG helper connection times out while connecting to SQL Server | High Availability | Linux | |
4577591 | FIX: Widerow insert to an external table is not supported when the row width is more than 32K in SQL Server 2019 | SQL Engine | Linux | |
4577590 | FIX: Error occurs when row width is less than DMS buffer size of 32K and an incorrect return path is chosen in SQL Server 2019 | SQL Engine | Linux | |
Fixes an issue to reduce parallel redo thread shutdown and startup thread messages in error log on servers with fewer cores and more idle databases. | High Availability | Windows | ||
4577561 | FIX: Error occurs when you try to filter the members of an entity for numeric values less than or greater than '0' in MDS 2019 | Master Data Services | Windows | |
Fixes intermittent connection issue with SSIS package executions when expression is used for both connection string and password of a connection manager. | Integration services | Windows | ||
4578110 | FIX: Error 8992 occurs when you run DBCC CHECKDB on cloned database in SQL Server 2019 | SQL Engine | Windows | |
DBCC CHECKDB reports corruption on spatial index incorrectly if base table has a column called ID. | SQL Engine | Windows | ||
SSRS 2016 URLs are case-sensitive after applying Security update GDRs: KB4532097 and KB4535706. | SQL Engine | Windows | ||
When you concurrently create sub directories in a FileTable directory, a deadlock may occur internally in the SQL Server Engine and all subsequent requests to FileTable directories and files may not respond. | SQL Engine | Windows | ||
When a replication error such as deadlock occurs, random id is inserted in MSRepl_Errors table while it should be just incremented by 1 from the previous id value. This cumulative update (CU) fixes the issue and the MSRepl_Errors will insert entries with row id incremented by 1 instead of using some random value. | SQL Engine | Windows | ||
When you run an ALTER command WITH ROLLBACK IMMEDIATE, the rollback can trigger before the command is processed, thus rolling back transactions even if the ALTER itself fails due to lack of permissions. This fix makes sure that the rollback is processed only after the ALTER command completes. | SQL Engine | Windows | ||
4511771 | FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server | SQL Engine | Windows | |
4563115 | FIX: Upgrade script may fail if you use Always On Failover Cluster Instance as a secondary replica in SQL Server 2016 and 2019 | SQL Engine | Windows | |
When DBCC CHECKTABLE, CHECKFILEGROUP and CHECKDB commands are issued against a database with table that contains columnstore index located on read-only non-primary filegroup, you may receive the following error: Msg 8921, Level 16, State 1, Line LineNumber Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors. | SQL Engine | Windows | ||
4560183 | FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server 2016 and 2019 | SQL Engine | Windows | |
FIX: Assertion error occurs on the mirror server during redo process hitting. Assertion: File: FilePath\FileName, line = LineNumber Failed Assertion = 'result == LCK_OK' | High Availability | Windows | ||
Access violation exception occurs when a query that references a non-exsting partition function is executed. | SQL performance | Windows | ||
Fixes the Japanese translation for "State" in SQL Configuration Manager. | SQL Engine | Windows | ||
Unable to change the DateTime/Number attributed to NULL in Master Data Services (MDS). | Data Quality Services (DQS) | Windows | ||
4569425 | FIX: Transactional replication publications can support URL type device to initialize subscriptions from backups in Azure Blob Storage in SQL Server 2017 | SQL Engine | Windows | |
4567166 | FIX: Assertion failure occurs when you try to insert record into a page in fully logged mode in SQL Server 2017 and 2019 | SQL Engine | Windows | |
Error occurs when mashup is used to import from Active Directory (AD) using the default M query generated from the connection wizard. Key Expression Error: The key didn't match any rows in the table | Analysis services | Windows | ||
DELETE statement returns Foreign Key check constraint error even when REFERENCE table has no matching rows. Msg 547, Level 16, State 0, Line LineNumber The DELETE statement conflicted with the REFERENCE constraint "ConstraintName". The conflict occurred in database "DatabaseName", table "TableName", column 'ColumnName'. The statement has been terminated. | SQL performance | Windows | ||
Fixes long duration for Integration Services Project deployment through powershell by improving search of operation messages in deployment process. | Integration services | Windows | ||
Fixes an error that occurs when a session cube is created on a database and you try to query from that session cube. The following error is received when you query the session cube: Server: The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine | Analysis services | Windows | ||
Column description disappears after exporting/importing models through MDSModelDeploy for an approval required entity in SQL Server 2019. | Data Quality Services (DQS) | Windows | ||
Fixes a performance issue when a query outputs NULL values following a semi join in SQL Server 2019 for a database with UTF8. | SQL performance | Windows | ||
Updates RSetup with the updated FWLINK version 3.5.2.777. | SQL Engine | Windows | ||
Fixes an issue in MDS Filtered results where the user is not returned to page 1 and the page count is not updated until returning to page 1. | Data Quality Services (DQS) | Windows | ||
Updates the Zulu JRE version to zulu11.37.18-sa-jre11.0.6.101. | SQL Engine | Windows | ||
Fixes an issue in Master Data Services 2019 where you cannot input multiline content in text attributes. | Data Quality Services (DQS) | Windows | ||
Under (rare) certain circumstances, memory grant re-calculation can cause an access violation. | SQL performance | Windows |
KB | Description | Fix Area | Platform | Learn More |
4561305 | FIX: Concurrent inserts against tables with columnstore indexes may cause queries to hang in SQL Server 2016 and 2019 | All | ||
When you run a SELECT query in Read Committed Snapshot Isolation (RCSI) on Clustered Columnstore Index (CCI) on a table in SQL Server 2019, the query may return incorrect number of rows under rare conditions. | SQL Engine | All | ||
Fixes an assertion exception that occurs when you query the DMV sys.dm_hadr_automatic_seeding. | High Availability | All | ||
This update fixes an issue with sys.dm_db_stats_histogram not showing NULL value histogram step. | SQL performance | All | ||
4574801 | FIX: Incorrect results occur when you run PolyBase query to read text files from Hadoop in SQL Server 2019 | SQL Engine | All | |
4578395 | FIX: Error occurs when using DBCC operations while TDE key change happens in SQL Server 2019 | SQL security | All | |
4034376 | FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature of SQL Server | SQL Engine | All | |
4538581 | FIX: Scalar UDF Inlining issues in SQL Server 2019 | SQL Engine | All | |
Fixes failure of SQL Server Extensibility Runtimes Setup on FIPS compliant servers. | SQL Engine | All | ||
4577594 | FIX: Add language and extension directories to the PATH environment variable in SQL Server 2019 | SQL Engine | All | |
4576778 | FIX: Table Variable Deferred Compilation feature on SQL Server 2019 database remains enabled when database compatibility level is 140 or lower | SQL Engine | All | |
Python and R CAB files for SQL Server Machine Learning Services on Windows and mssql-mlservices packages on Linux are updated to version 9.4.7.958. On Windows, "Cannot resume session with terminated pooled proccess" error is fixed while launching Python/R runtimes. On Linux, this update enables successful installation of mssql-mlservices-mlm-r package on RHEL8. | SQL Engine | All | ||
4577836 | FIX: Inconsistency occurs when ghost rows are inserted into mapping index rowset | SQL Engine | All | |
4578011 | FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size | SQL Engine | Linux | |
4575453 | FIX: SQL Server fails to start when remote admin connections are enabled and IPV6 is disabled on the host | SQL Engine | Linux | |
Improvement: Enables RLS feature for PolyBase by default in SQL Server 2019 | SQL Engine | Linux | ||
This updates adds detailed error information to the pacemaker log when pacemaker agent fails to connect to SQL Server resource to obtain health status. | High Availability | Linux | ||
4569424 | FIX: Intermittent Availability Group failover occurs as AG helper connection times out while connecting to SQL Server | High Availability | Linux | |
4581882 | FIX: Restoring database fails due to backup command timeout in SQL Server 2019 . | High Availability | Linux | |
4577591 | FIX: Widerow insert to an external table is not supported when the row width is more than 32K in SQL Server 2019 | SQL Engine | Linux | |
4577590 | FIX: Error occurs when row width is less than DMS buffer size of 32K and an incorrect return path is chosen in SQL Server 2019 | SQL Engine | Linux | |
4577837 | FIX: Queries may fail when storage pool caching is enabled by default in SQL Server 2019 Big Data Cluster | SQL Engine | Linux | |
4578292 | FIX: Error occurs when you try to deploy CU5 or CU6 for SQL Server 2019 BDC by using azdata client 20.0.0 on RHEL host OS | SQL BDC | Linux | |
Fixes an issue to reduce parallel redo thread shutdown and startup thread messages in error log on servers with fewer cores and more idle databases. | High Availability | Windows | ||
4577561 | FIX: Error occurs when you try to filter the members of an entity for numeric values less than or greater than '0' in MDS 2019 | Master Data Services | Windows | |
Fixes intermittent connection issue with SSIS package executions when expression is used for both connection string and password of a connection manager. | Integration services | Windows | ||
4578110 | FIX: Error 8992 occurs when you run DBCC CHECKDB on cloned database in SQL Server 2019 | SQL Engine | Windows | |
DBCC CHECKDB reports corruption on spatial index incorrectly if base table has a column called ID. | SQL Engine | Windows | ||
SSRS 2016 URLs are case-sensitive after applying Security update GDRs: KB4532097 and KB4535706. | SQL Engine | Windows | ||
When you concurrently create sub directories in a FileTable directory, a deadlock may occur internally in the SQL Server Engine and all subsequent requests to FileTable directories and files may not respond. | SQL Engine | Windows | ||
When a replication error such as deadlock occurs, random id is inserted in MSRepl_Errors table while it should be just incremented by 1 from the previous id value. This cumulative update (CU) fixes the issue and the MSRepl_Errors will insert entries with row id incremented by 1 instead of using some random value | SQL Engine | Windows | ||
When you run an ALTER command WITH ROLLBACK IMMEDIATE, the rollback can trigger before the command is processed, thus rolling back transactions even if the ALTER itself fails due to lack of permissions. This fix makes sure that the rollback is processed only after the ALTER command completes. | SQL Engine | Windows | ||
4511771 | FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server | SQL Engine | Windows | |
4563115 | FIX: Upgrade script may fail if you use Always On Failover Cluster Instance as a secondary replica in SQL Server 2016 and 2019 | SQL Engine | Windows | |
When DBCC CHECKTABLE, CHECKFILEGROUP and CHECKDB commands are issued against a database with table that contains columnstore index located on read-only non-primary filegroup, you may receive the following error: Msg 8921, Level 16, State 1, Line LineNumber Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors. | SQL Engine | Windows | ||
4560183 | FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server 2016 and 2019 | SQL Engine | Windows | |
FIX: Assertion error occurs on the mirror server during redo process hitting. | High Availability | Windows | ||
Access violation exception occurs when a query that references a non-exsting partition function is executed. | SQL performance | Windows | ||
Fixes the Japanese translation for "State" in SQL Configuration Manager. | SQL Engine | Windows | ||
Unable to change the DateTime/Number attributed to NULL in Master Data Services (MDS). | Data Quality Services (DQS) | Windows | ||
4569425 | FIX: Transactional replication publications can support URL type device to initialize subscriptions from backups in Azure Blob Storage in SQL Server 2017 | SQL Engine | Windows | |
4567166 | FIX: Assertion failure occurs when you try to insert record into a page in fully logged mode in SQL Server 2017 and 2019 | SQL Engine | Windows | |
Error occurs when mashup is used to import from Active Directory (AD) using the default M query generated from the connection wizard. Key Expression Error: The key didn't match any rows in the table | Analysis services | Windows | ||
DELETE statement returns Foreign Key check constraint error even when REFERENCE table has no matching rows. Msg 547, Level 16, State 0, Line LineNumber The DELETE statement conflicted with the REFERENCE constraint "ConstraintName". The conflict occurred in database "DatabaseName", table "TableName", column 'ColumnName'. The statement has been terminated. | SQL performance | Windows | ||
Fixes long duration for Integration Services Project deployment through powershell by improving search of operation messages in deployment process. | Integration services | Windows | ||
Fixes an error that occurs when a session cube is created on a database and you try to query from that session cube. The following error is received when you query the session cube: Server: The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine. | Analysis services | Windows | ||
Column description disappears after exporting/importing models through MDSModelDeploy for an approval required entity in SQL Server 2019. | Data Quality Services (DQS) | Windows | ||
Fixes a performance issue when a query outputs NULL values following a semi join in SQL Server 2019 for a database with UTF8. | SQL performance | Windows | ||
Updates RSetup with the updated FWLINK version 3.5.2.777. | SQL Engine | Windows | ||
Fixes an issue in MDS Filtered results where the user is not returned to page 1 and the page count is not updated until returning to page 1. | Data Quality Services (DQS) | Windows | ||
Updates the Zulu JRE version to zulu11.37.18-sa-jre11.0.6.101. | SQL Engine | Windows | ||
Fixes an issue in Master Data Services 2019 where you cannot input multiline content in text attributes. | Data Quality Services (DQS) | Windows | ||
Under (rare) certain circumstances, memory grant re-calculation can cause an access violation. | SQL performance | Windows |
KB | Description | Fix Area | Platform | Learn More |
This improvement changes the behavior of Availability Group informational messages to not be printed to the log by default: UpdateHadronTruncationLsn(X) (force=Y): Primary: Z:Z:Z Secondary: A:A:A Partial Quorum : B:B:B Aggregation: C:C:C Persistent: D:D:D | High Availability | All | ||
This update contains an improvement for object level lock optimization on secondary replicas of Always On Availability Groups. This improvement addresses the schema lock contention on secondary replica redo, especially when the number of logical processors is large. | High Availability | All | ||
Fixes high CPU consumption on Availability Group secondary database when using multiple redo threads and uninitialized LSN, leading to extra reads under some rare scenarios | High Availability | All | ||
Fixes access violation exception that occurs when plan cache involves sys.dm_hadr_ag_threads and sys.dm_hadr_db_threads DMVs | High Availability | All | ||
Fixes race condition where a PolyBase query might hang when the corresponding execution plan involves a query against a external data source that fails right after submission | SQL BDC | All | ||
Fixes the following numeric overflow error when you attempt to create a PolyBase external table targeting a Teradata table with more than 2,147,483,647 rows, the Teradata system’s default session mode is ‘Teradata’, and you didn’t change the session mode of the PolyBase connection by including ‘SessionMode=ANSI’ in the CONNECTION_OPTIONS of the external data source that is used in the CREATE EXTERNAL TABLE statement. Error: 105082;Generic ODBC error: [Microsoft][ODBC Teradata Driver][Teradata Database](-2616)Numeric overflow occurred during computation. | SQL Engine | All | ||
When you execute a select query against a PolyBase external data source and the query contains columns whose names only differ by case (such as ID and Id), you notice that PDW engine may generate an incorrect landing table schema which results in following error: Msg 7320: Cannot execute the query "Remote Query" against OLE DB provider "MSOLEDBSQL" for linked server "(null)". Column names in each table must be unique. Column name 'ID' in table 'TableName' is specified more than once. | SQL Engine | All | ||
4568448 | FIX: Support for REJECT_ROW_LOCATION parameter in CREATE EXTERNAL TABLE in SQL Server 2019 box product | SQL Engine | All | |
4568653 | 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 2019 | SQL Engine | All | |
4538581 | FIX: Scalar UDF Inlining issues in SQL Server 2019 | SQL Engine | All | |
Adds support to communicate with a private network from sp_execute_external_script query in SQL Server 2019 "OSError: [WinError 10013] An attempt was made to access a socket in a way forbidden by its access permissions" | SQL Engine | All | ||
Fixes a case where an error for a failed PolyBase query may not always get propagated to the user, instead returning the partial result set | SQL Engine | All | ||
Fixes error "Field not found in the applicable tables" when you query external table with DATE/TIMESTAMP literals in WHERE clause and the external data source ODBC driver does support not ANSI format | SQL Engine | All | ||
This update fixes a rare race condition in PolyBase query cancellation | SQL Engine | All | ||
4551220 | FIX: Assertion error occurs when you run resumable index build statement in SQL Server | SQL performance | All | |
Fixes an access violation error that might occur when auditing commands that require password masking | SQL security | All | ||
Fixes an issue in agent join during deployment due to pod IP address mismatch in SQL Server 2019 | SQL BDC | Linux | ||
Fixes an issue with an orphaned spinlock due to access violation and results in the repeatedly printed in messages log: "getspinlock pre-Sleep() after AV" | SQL Engine | Linux | ||
4570355 | FIX: Error occurs when you insert data from one replicated BDC data pool table to another in SQL Server 2019 | SQL Engine | Linux | |
Adds a new dsqlplan XEvent in PDW to collect dsql plan | SQL Engine | Linux | ||
This update allows PolyBase external tables for Teradata database to map ByteInt data type to TinyInt data type | SQL Engine | Linux | ||
Removes unrelated warning message that is generated during PolyBase engine start or when PolyBase XEvent config environment variable is not set "is not a rooted path. Expect a rooted path for XE config file from envrionment variable." | SQL Engine | Linux | ||
Fixes issue with access violation exception when you execute query with UDF and multiple grouping. After applying this update, SQL Server blocks UDF inlining if group by includes multiple groupings. | SQL performance | Linux | ||
4570679 | FIX: Remote Hadoop bridge fails when using Hadoop connectivity levels other than seven in SQL Server 2019 on Linux | SQL Engine | Linux | |
4577562 | FIX: Istio proxy fails as automountServiceAccountToken is set to FALSE in CU5 for SQL Server 2019 | SQL BDC | Linux | |
Excel MDX queries running against an SSAS Tabular instance may return incorrect result when you convert PivotTable Filters to formulas. | Analysis Services | Windows | ||
DMV query $system.DISCOVER_STORAGE_TABLES can execute slowly against in-memory model which contains many tables and large table row counts in SQL Server 2019 | Analysis Services | Windows | ||
Corrects a regression to allow Recursive Hierarchies to display child items correctly. | Data Quality Services (DQS) | Windows | ||
4538849 | FIX: Transaction commit delay time is higher under low usage workloads in SQL Server 2017 and 2019 | High Availability | Windows | |
4551221 | FIX: Error occurs when you try to create a differential backup on secondary replica in SQL Server | High Availability | Windows | |
4570571 | FIX: Query slowness occurs when CPU-intensive SQL Server system tasks run in SQL Server 2019 | High Availability | Windows | |
This update contains an improvement for XML Validation in SSIS XML Tasks. This improvement allows validation of INCLUDED schemas in XML task. | Integration Services | Windows | ||
4547890 | FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server 2019 | Integration Services | Windows | |
When using FileTables in SQL Server, you may notice dumps being generated periodically that contain an assertion in function FFtFileObject::ProcessPostCreate. In some environments, these dumps may trigger a failover FtFileObject::ProcessPostCreate file = fftfo.cpp line = LineNumber expression = FALSE | SQL Engine | Windows | ||
4563597 | FIX: Assertion dump occurs when Implicit Transactions are enabled in SQL Server 2016, 2017, and 2019 | SQL Engine | Windows | |
4570433 | FIX: "Culture is not supported" error occurs when you execute PolyBase query in SQL Server 2019 | SQL Engine | Windows | |
This improvement can force the Query Store option to be turned off by specifying the additional option FORCED in the ALTER DB command. FORCED option allows you to turn off Query Store immediately by aborting all background tasks. ALTER DATABASE {0} SET QUERY_STORE = OFF (FORCED) | SQL Engine | Windows | ||
4575275 | FIX: Access violation occurs when MSTVF references an In-Memory OLTP large-value data type with interleaved execution enabled in SQL Server 2019 | SQL Engine | Windows | |
Assertion exception occurs when the system function sys.fn_xe_file_target_read_file is executed in SQL Server 2019 Assert reference (Location: FileName:LineNumber, Expression: pvb->FInUse ()) or (Location: FileName:LineNumber, Expression: !"No exceptions should be raised by this code") | SQL Engine | Windows | ||
Updates the Zulu JRE version to zulu11.37.18-sa-jre11.0.6.101 | SQL Engine | Windows | ||
Fixes errors that occur in SCOM 2019, when you upgrade from SQL Server 2016 or 2017 to SQL Server 2019 CU5 with UDF inlining ON | SQL Engine | Windows | ||
Fixes an unexpected result issue for variables when you use multiple variable assignments from select statement that has scalar UDF inlining. After you apply this update, SQL Server blocks UDF inlining in special cases of select-with-assignment queries. | SQL performance | Windows | ||
The external satellite processes in SQL Server have a restriction to not use more than 8 cores on the system for satellite worker threads, but in case of highly parallel execution all the process are restricted to same set of 8 cores on the machine and don’t use the other cores available on the system. This issue only happens on Windows and slows down highly parallel queries. The fix is to allow the processes to use 8 cores rather than the fixed set of cores on the system | SQL Extensibility | Windows | ||
Fixes an access violation that occurs when executing system function sys.fn_get_audit_file to read Audit file in SQL Server 2019 | SQL security | Windows |
KB | Description | Fix Area | Platform | Learn More |
SQL Server may block renaming a database when the database consists of one or more external data pool tables. If you attempt to rename the database in the scenario, you may get the following error: Alter database name is not supported in Big Data Cluster if the database contains external data pool tables. Drop the external data pool tables to perform the operation. | SQL BDC | All | ||
4538581 | FIX: Scalar UDF Inlining issues in SQL Server 2019 | SQL Engine | All | |
4555232 | FIX: Blocking may occur when Reduce Recompilations feature is enabled by default in SQL Server 2019 | SQL Engine | All | |
4561915 | Improvement: MAXTRANSFERSIZE no longer required to enable backup compression on TDE encrypted databases | SQL Engine | All | |
You can retrieve the SQL Server Big Data Cluster controller endpoint by querying the new property SELECT SERVERPROPERTY ('ControllerEndpoint'). | SQL Engine | All | ||
When shrinking a database, you may receive a database consistency error if the shrinking process encounters an IAM page that is the first and only IAM page. The symptoms may include assertions errors involving heapdataset. Confirm that you do not have any inconsistencies by executing DBCC CHECKDB after shrink operations. Applying this update will prevent future occurrence of this issue and not clean up past inconsistencies. | SQL Engine | All | ||
When PolyBase queries are cancelled shortly after being scheduled, the cancellation may timeout after one hour (and fail to cancel the execution) and generate a dump of Data Movement service. | SQL Engine | All | ||
When 32 or more PolyBase queries are scheduled concurrently, deadlock may occur and current and subsequent PolyBase queries may stall and may not be cancellable. | SQL Engine | All | ||
When inserting into PolyBase external tables from SQL Server head data or tables, query may fail (instead of waiting for resources) if 32 PolyBase queries are currently running. | SQL Engine | All | ||
Access violation exception occurs when querying sys.dm_cluster_endpoints in SQL Server 2019 on Big Data Cluster | SQL Engine | All | ||
When using INSERT INTO … VALUES (…) or INSERT INTO SELECT… statement to populate Data Pool external table and if user specifies the target table columns, the list of target table column names must have the same order as the source table columns and must be the full list. Starting this cumulative update, you will get detailed new errors outlining these conditions: "Source column count must match the # of columns in the destination table" "Order of source columns must match the order of columns in the destination table" | SQL Engine | All | ||
Encrypt keyword is missing from externalaccessconfig in SQL Server 2019 | SQL Engine | All | ||
When you deploy SQL Server Big Data Clusters in Active Directory mode, SQL Server uses domain DNS name to create user in sql server. When the DNS name and realm name are different, failures may occur. After installing this update, SQL Server will use realm name to create user in sql server. | SQL Engine | All | ||
When you use Accelerated Database Recovery feature on a database in SQL Server 2019, which is part of an Availability Group or Transactional Replication, an assertion error occurs. (Location: recovery.cpp:LineNumber, Expression: (!!lp->IsFlagOn (LogRec::LOG_TO_SLOG)) == recXdes->DoesXactSupportCTR () || lp->GetOpCode () == LOP_CTR_NEST_ABORT) | SQL Engine | All | ||
SQL Agent jobs that require access to credentials stored in master database may not be executed when you use Always On availability group in SQL Big Data Cluster. | SQL BDC | Linux | ||
4556244 | FIX: Credential update frequency option is added to mssql-conf option in SQL Server 2019 on Linux | SQL Engine | Linux | |
4563007 | FIX: VDI backup fails with error after applying SQL Server 2019 CU2/CU3/CU4 | SQL Engine | Linux | |
4561725 | Improvement: Enables custom event configuration for XEVENT Session EngineService in SQL Server 2019 | SQL Engine | Linux | |
If trace flag 6424 is enabled, this fix will dump PolyBase processes if SQL Server dumps. | SQL Engine | Linux | ||
For SQL Server 2019 on Linux or Big Data Cluster configured to use AD auth, you may notice a reduction in size of core dumps generated after installing the update. | SQL Engine | Linux | ||
When you attempt to enable Log Shipping feature in SQL Server on Linux, you may receive an error message that resembles the following: Msg 32018, Level 16, State 3, Server mssql02, Procedure master.dbo.sp_add_log_shipping_secondary_primary, Line LineNumber Log shipping is not installed on this instance. RegQueryValueEx() returned error 2, 'The system cannot find the file specified.' | SQL Engine | Linux | ||
Enable SQL Server Big Data Clusters Active Directory (AD) deployments when domain controllers are not acting as DNS servers. | SQL Engine | Linux | ||
Deployment gets blocked when domain DNS name and realm name are different in SQL Server 2019 BDC | SQL Engine | Linux | ||
Memory may be increased and not be released when a SQL Server outbound connect like Linked Servers fails. This may happen because a socket structure is not deallocated properly | SQL Engine | Linux | ||
AD access to SQL Server 2019 BDC endpoints fails when domain DNS name and endpoint DNS names do not match | SQL Engine | Linux | ||
4539023 | FIX: Analysis Services Execute DDL task may fail to impersonate the user context to the remote Analysis services instance in SQL Server 2017 and 2019 | Analysis Services | Windows | |
This will fix a functional results issue with the usage of NOT IN operator in DAX when OPTIMIZEDNOTINOPERATOR optimization is enabled. | Analysis Services | Windows | ||
This will fix the functional issues with initial performance fix for dense measures evaluation in SuperDAXMD mode | Analysis Services | Windows | ||
This will fix performance problems in PBI and Multidimensional models user scenario | Analysis Services | Windows | ||
This improves MDX query execution performance against a dimension user hierarchy which is a ragged hierarchy (HideMemberIf property set ) and has deep hierarchy level in SSAS Multidimensional instance. | Analysis Services | Windows | ||
When you try to build relationship on a model that contains many measures with USERELATIONSHIP function, this fix can improve the processing performance and also reduce the time of "sequence point algorithm" step. | Analysis Services | Windows | ||
In explore page, you may not be able to revert the changes in changeset. | Data Quality Services (DQS) | Windows | ||
"Show More Members" functionality for Explicit Hierarchies do not show more than 50 members in Master Data Services (MDS) 2019. | Data Quality Services (DQS) | Windows | ||
4560051 | FIX: SQL Server may still read data from secondary replica when ALLOW_CONNECTIONS is set to NO | High Availability | Windows | |
4562173 | FIX: Availability Group failover generates lot of dumps as DTC support is toggled between PER_DB and NONE multiple times | High Availability | Windows | |
Fix the issue that when using ODBC components in Foreach Loop component, the ODBC component will meet "Function sequence error" in the second loop during package execution. | Integration Services | Windows | ||
4556233 | FIX: Setup is unable to extract product update when it is executed as LOCAL SYSTEM with UPDATE SOURCE option specified in SQL Server 2019 | Setup & Install | Windows | |
4540896 | FIX: Access violation may occur when enumerating files in a FileTable in SQL Server | SQL Engine | Windows | |
4552478 | FIX: Distribution Agent "Parameterized values for above command" log message missing after SQL Server 2017 and 2019 upgrade | SQL Engine | Windows | |
4562618 | FIX: Changes to firewall rules created when you install PolyBase in scale-out group configuration in SQL Server 2019 | SQL Engine | Windows | |
4563044 | FIX: Allow external resource pool to use more than one processor group in SQL Server 2019 on Windows | SQL Engine | Windows | |
4563195 | FIX: sp_execute_external_script may fail to run R scripts that use the RxLocalParallel compute context or the doParallel R package in SQL Server 2019 | SQL Engine | Windows | |
4563348 | After upgrading SQL Server 2017 Distributor to SQL Server 2019, transactional push replication fails when subscriber is using non-default port | SQL Engine | Windows | |
4564868 | FIX: Assertion exception occurs when you query the DMV sys.dm_db_file_space_usage in SQL Server 2019 | SQL Engine | Windows | |
4564876 | FIX: Unable to reconfigure Database mirroring when ADR is enabled and disabled in SQL Server 2019 | SQL Engine | Windows | |
When FIPS is enabled on the server (using MSKB article 811833), you may not be able to use Managed Backup on a SQL Server 2019 instance and you may encounter the following error: Msg 45207, Level 17, State 17, Line 102 The operation failed because of an internal error. Exception has been thrown by the target of an invocation. Please retry later. | SQL Engine | Windows | ||
Msg 3628 (The Database Engine may receive a floating point exception from the operating system while processing a user request) may occur during a clustered columnstore index rebuild. | SQL Engine | Windows | ||
When a Windows principal that is not mapped to a specific database user accesses a database by using membership in a windows group or AAD group, a user id of 0 may be assigned to the user. When the user tries to use libraries that are installed by other dbo/sysadmin user, the user may not see any external libraries. After applying this update, a user id of 0 would have access to external libraries installed by the dbo (libraries in public scope). Since there is no database user that is mapped to the Windows principal, the user with user id 0 cannot create or install external libraries. | SQL Engine | Windows | ||
You can access configurations that ship with PolyBase when specifying a DSN in the CONNECTION_OPTIONS of a Generic ODBC External Data Source definition. The options are picked up by matching the driver name used in the DSN definition. This currently applies to the following drivers: • IBM DB2 ODBC DRIVER • HDBODBC • Microsoft Spark ODBC Driver | SQL Engine | Windows | ||
sys.key_constraints reports two rows for an index if the XML component id is same as the "object_id" of a primary key | SQL Engine | Windows | ||
Spatial data types (Geometry and Geography) are implemented as CLR data types in SQL Server. When the application domain hosting the spatial data type structures is unloaded, the engine treats this as a schema change to the underlying objects referenced in the cursor. As a result, spatial query may fail with related error message when the schema change is detected. | SQL Engine | Windows | ||
Access violation may occur when a cursor is used to retrieve data from scalar UDF and the underlying table contains primary key. | SQL Engine | Windows | ||
When you have external tables on a database in SQL Server 2019 and try to publish different tables from the same database, you may receive the following error message in SSMS: New Publication Wizard encountered one or more errors while retrieving the list of articles on 'database name'. The list of articles may not be complete. Additional Information: Data is Null. This method or property cannot be called on Null values. | SQL Engine | Windows | ||
Disables PolyBase Generic ODBC External Data Sources' default behavior of pushing down the TOP operator and calling the SQLRowCount function | SQL Engine | Windows | ||
Enables the following keys to be specified in the CONNECTION_OPTIONS of a PolyBase Generic ODBC External Data Source: PolyBaseOdbcSupportsRowCount, PolyBaseOdbcSupportsMetadataIdAttributes, PolyBaseOdbcSupportsBindOffset, PolyBaseQoTopPushdownSyntax | SQL Engine | Windows | ||
Script "system_xevents_modification.sql" downgraded failed with error 935 which causes master database not able to recover with error 3417 and then SQL Server is unable to start | SQL Engine | Windows | ||
When you use DELETE statement on a table in SQL Server, you may receive the following error message as no matching rows exists in the referenced tables. Msg 547, Level 16, State 0, Line LineNumber The DELETE statement conflicted with the REFERENCE constraint "constraint name". The conflict occurred in database "database name", table "table name", column 'column name'. The statement has been terminated. | SQL performance | Windows | ||
Access violation occurs when a query is executed against a filtered index in SQL Server 201 | SQL performance | Windows |
KB | Description | Fix Area | Platform | Learn More |
Adds new SERVERPROPERTY "IsBigDataCluster" to retrieve a boolean value that describes whether the instance is BDC or not. | Big Data Cluster (BDC) | All | ||
4538581 | FIX: Scalar UDF Inlining issues in SQL Server 2019 | SQL Engine | All | |
4552159 | FIX: Error occurs when you apply a security policy on PolyBase external table in SQL Server 2019 | SQL Engine | All | |
4552205 | FIX: Error occurs when you try to create external table in PolyBase with database_default as collation in SQL Server 2019 | SQL Engine | All | |
4538688 | FIX: Severe spinlock contention occurs in SQL Server 2019 | SQL Engine | All | |
Access violation error occurs when you cancel queries against Big Data Cluster (BDC) storage pool or any OPENROWSET query on an instance of SQL Server 2019. | SQL Engine | All | ||
4538268 | FIX: "Expired BLOB handle" error occurs when cross-database transaction involves communication with MSDTC in SQL Server 2017 and 2019 | SQL performance | All | |
4541096 | FIX: Access Violation occurs when you run query on computed columns in SQL Server | SQL performance | All | |
4543027 | FIX: Parallel sampled filtered statistics may cause incorrect histogram scaling in SQL Server 2016 and 2019 | SQL performance | All | |
Starting from Cumulative Update 4 (CU4) for SQL Server 2019, when auditing DMVs and DBCC commands to get query optimization statistics and if sensitive data is revealed, the 'data_sensitivity_information' column of the audit record will be populated. | SQL security | All | ||
Improved error message is returned when you try to link the base and history tables on which data classification is already defined. | SQL security | All | ||
4532432 | Mssql-conf tool fails if IPV6 is disabled on the Linux system | SQL Engine | Linux | |
Assume that the Format String Expression property of a Calculation Item from a Calculation Group is set. The performance degradation occurs when you run MDX queries generated by MDX based client tools and may also occur when MDX queries do not refer to the calculation item with Format String Expression set. However, the performance degradation is not so evident on equivalent DAX queries generated by Power BI Desktop visuals | Analysis Services | Windows | ||
4541300 | FIX: Fix incorrect values in auto seeding XEvents in SQL Server | High Availability | Windows | |
4541303 | FIX: Non-yielding Scheduler error may occur with Always On availability group in Microsoft SQL Server | High Availability | Windows | |
4541309 | FIX: Missing log block may occur when you use Always On availability group in SQL Server | High Availability | Windows | |
4541724 | FIX: Intermittent non-yielding scheduler occurs when memory-optimized database running under heavy I/O activities in SQL Server 2016 and 2019 | In-Memory OLTP | Windows | |
In the Service Accounts interface of SQL Server Setup, password validation may fail if only username is entered before the correct password is entered. This failed validation may lock out the domain service account if you do this repeatedly and domain policy set to lock accounts after few unsuccessful attempts. | Setup & Install | Windows | ||
4538365 | FIX: Change Tracking cleanup does not work when invalid cleanup and hardened cleanup version are negative in SQL Server 2017 and 2019 | SQL Engine | Windows | |
4539815 | FIX: Access violation occurs when change tracking auto cleanup tries to clean up side tables in SQL Server | SQL Engine | Windows | |
4540107 | FIX: System or background task may fail when number of sessions reaches the maximum limit in SQL Server 2016 and 2019 | SQL Engine | Windows | |
4540121 | FIX: sp_execute_external_script doesn't run when you install SQL Server 2019 with Machine Learning Services and a customized Shared feature directory | SQL Engine | Windows | |
4540342 | FIX: Non-yielding scheduler condition occurs with CONNECTION_MANAGER spinlock in SQL Server | SQL Engine | Windows | |
4540903 | FIX: Non-yielding scheduler dump occurs in InterlockedCompareExchangePointer and SOS_RWLock in SQL Server 2016 and 2019 | SQL Engine | Windows | |
4541435 | FIX: Error occurs when you rename a column on temporal current table in SQL Server | SQL Engine | Windows | |
4541520 | FIX: Assertion occurs when you process a malformed XML message sent as message in Service Broker queue in SQL Server | SQL Engine | Windows | |
4541762 | FIX: Management Data Warehouse Server Activity Collection Set may fail in SQL Server 2016 and 2019 | SQL Engine | Windows | |
4541770 | FIX: Assertion failure occurs when persistent log buffer is used in SQL Server 2016 and 2019 | SQL Engine | Windows | |
4548103 | FIX: Performance degradation occurs on PMEM devices with Hybrid Buffer Pool enabled in SQL Server 2019 | SQL Engine | Windows | |
When an application performs bulk copy operations and a subsequent select in the same transaction against a database with simple or bulk-logged recovery model, SQL Server Access Violations may occur and repeat until the service is restarted. | SQL Engine | Windows | ||
SQL Writer will add its version and log tracing parameters to the log header when the service starts. | SQL Engine | Windows | ||
Improves SQL Writer for better handling of COPY_ONLY backup messages in SQL Server 2019. | SQL Engine | Windows | ||
4538497 | FIX: Slow query performance when using query predicates with UPPER, LOWER or RTRIM with default CE in SQL Server 2017 and 2019 | SQL Engine | Windows | |
4539880 | FIX: Access violation occurs with wait_info XEvent on busy SQL Server | SQL performance | Windows | |
4540346 | FIX: MERGE statement fails with assert “Attempt to access expired blob handle (1)” in SQL Server 2016 and 2019 | SQL performance | Windows | |
4540901 | FIX: SQL Server may terminate due to lock conflicts during error message processing in SQL Server 2016 and 2019 | SQL security | Windows |
KB | Description | Fix Area | Platform | Learn More |
SQL Server error log contains additional empty lines while printing In-memory OLTP related messages. | In-memory OLTP | All | ||
4538118 | Improvement: Enable hybrid buffer pool read caching in SQL Server 2019 | SQL Engine | All | |
4541132 | Improvement: Size and retention policy are increased in default XEvent trace system_health in SQL Server 2019 and 2016 | SQL Engine | All | |
Enable SQL checksum sniffer for Pmm pages in hybrid buffer pool. | SQL Engine | All | ||
Due to a new feature called concurrent PFS update in SQL Server 2019 which is enabled by default, in certain rare corner cases, you may encounter non-yielding threads and latch timeout errors in SQL Server. | SQL Engine | All | ||
Updates the Zulu JRE version to zulu11.37.18-sa-jre11.0.6. | SQL Engine | All | ||
When you run a query against sys.dm_db_stats_histogram, it may fail with access violation when a parallel plan is chosen. | SQL performance | All | ||
4538686 | Improvement: Add new Protection key feature work for SQL Server 2019 on Linux | SQL Engine | Linux | |
4548131 | FIX: Fail to access openmpi path when running rx jobs in parallel mode with Revo package in Linux SQL Server 2019 | SQL Engine | Linux | |
4548133 | FIX: Data length/size of Unicode nvarchar data type column is not correct for OutputDataSet in sp_execute_external_script query in SQL Server 2019 on Linux | SQL Engine | Linux | |
This update reduces query execution time for BDC storage pool tables and other Polybase external tables. | SQL Engine | Linux | ||
Updates to SQL Server on Linux (mssql mlservices and extensibility) packages to address following issues: 1. BxlServer consumes 100% CPU 2. Python launcher encounters assert when deleting files 3. Data length mismatch when using Unicode string with OutputDataSet and InputDataSet of data passthrough query. | SQL Engine | Linux | ||
4550657 | FIX: Error occurs when you interact with SQL Server Agent in SQL Server 2019 | High Availability | Windows | |
4547890 | FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server 2019 | Integration Services | Windows | |
Allow DTSWizard to support AAD when the selected driver is MSOLEDBSQL. | Integration Services | Windows | ||
4529927 | FIX: .NET Framework DbDataAdapter.FillSchema method returns NULL on database with compatibility level 140 in SQL Server 2019 and 2017 | SQL Engine | Windows | |
4539172 | FIX: Launchpad services fails to start during failover in SQL Server 2019 | SQL Engine | Windows | |
4540121 | FIX: sp_execute_external_script doesn't run when you install SQL Server 2019 with Machine Learning Services and a customized Shared feature directory | SQL Engine | Windows | |
4548523 | FIX: Database creation to Azure blob storage from SQL Server 2019 on Linux may fail with error | SQL Engine | Windows | |
Updates RSetup with the updated FWLINK version 3.5.2.293 | SQL Engine | Windows | ||
"The JSON DDL request is missing the database name" error occurs when you delete the database property from the descriptive table under the JSON code in SQL Server 2019 | SQL Engine | Wndows | ||
When you repeatedly run a stored procedure that uses temporary table with indexes on SQL Server 2019, the client may receive an unexpected error with message "A severe error occurred on the current command" and an access violation exception is recorded on the SQL Server. If the same workload is executed on any previous major version of SQL Server, this issue does not occur. | SQL performance | Wndows | ||
When you run a SELECT query returning empty/multiple rows with variable assignment in inline-able scalar UDFs, you may receive wrong results | SQL performance | Wndows |
KB | Description | Fix Area | Platform | Learn More |
4540449 | FIX: Error occurs in sp_xml_preparedocument where MSXMLSQL tries to access virtual address space beyond limit in SQL Server 2017 and 2019 | SQL Engine | All | |
4540372 | FIX: XML PATH queries in PolyBase fail with an error in SQL Server 2019 | SQL Engine | Windows | |
4540371 | FIX: Query on Clustered Columnstore Index in SQL Server 2019 uses more CPU time than in SQL Server 2016 | SQL Engine | Windows | |
4540343 | FIX: Contained AG master database dependency creates deadlock during replica restart at certain condition in SQL Server 2019 | High Availability | All | |
4539340 | FIX: Include support for Excel ODBC driver and Text ODBC driver from Microsoft Access Database Engine Redistributable package in PolyBase for SQL Server 2019 | SQL Engine | All | |
4539203 | FIX: Error occurs when you use PolyBase Generic ODBC connector with backend that has unsupported quote character in SQL Server 2019 | SQL Engine | Windows | |
4539201 | FIX: XML queries in PolyBase fail with an unknown type error in SQL Server 2019 | SQL Engine | Windows | |
4539200 | FIX: Internal DMS error when you use PolyBase Generic ODBC connector in SQL Server 2019 | SQL Engine | All | |
4539199 | FIX: PolyBase defaults string mapping for Microsoft Spark ODBC driver in SQL Server 2019 | SQL Engine | All | |
4539198 | FIX: Map large fixed width types to variable width types in PolyBase in SQL Server 2019 | SQL Engine | All | |
4539197 | FIX: Null pointer exception error occurs when "latch_suspend_end" XEvent is enabled in SQL Server 2019 | SQL Engine | All | |
4539000 | FIX: SSMS showplan error occurs for BDC query in SQL Server 2019 | SQL Engine | All | |
4538978 | Improvement: Add BDC storage pool cache in SQL Server 2019 | SQL Engine | All | |
4538968 | FIX: PolyBase query execution time may increase exponentially when you run concurrent queries in SQL Server 2019 | SQL Engine | All | |
4538858 | FIX: Dumps occur because of OOM condition in SQL Server 2019 | SQL Engine | All | |
4538759 | Improvement: Module and offset information is sent as output for dumps in SQL Server 2019 | SQL Engine | Linux | |
4538689 | Improvement: Add BDC data/storage pool nodes DMVs in SQL Server 2019 | SQL Engine | Linux | |
4538688 | FIX: Severe spinlock contention occurs in SQL Server 2019 | SQL Engine | All | |
4538685 | FIX: SQL Server 2019 Express SLT incorrectly states that Express is not allowed for production use | SQL Engine | Windows | |
4538661 | FIX: New sandbox is created unexpectedly when sandbox cleanup fails and child process is still alive | SQL Engine | Linux | |
4538595 | Improvement: New features included in library management for external languages in SQL Server 2019 | SQL Engine | All | |
4538581 | FIX: Scalar UDF Inlining issues in SQL Server 2019 | SQL Engine | All | |
4538575 | FIX: Login and logout failures occur while auditing data classification attributes in SQL Server 2019 | SQL security | All | |
4538573 | FIX: Changes made using ALTER DATABASE...SQL Server 2019 fails to log changes in SQL Error log or raise database trigger | SQL Engine | All | |
4538515 | FIX: Concurrent PFS update in SQL Server 2019 may cause corruption of ADR | SQL Engine | All | |
4538496 | FIX: Unable to encrypt data when using column encryption with symmetric keys in SQL Server 2019 | SQL security | Windows | |
4538495 | FIX: Access violation occurs when you create remote stored procedure with one of the system variable (@@servername, @@servicename) in SQL Server 2019 | SQL Engine | Windows | |
4538493 | Improvement: Restore database and add database to the AG in SQL Server 2019 | High Availability | All | |
4538481 | FIX: Exception occurs when you run UNION ALL+ORDER BY/MERGE UNION ALL queries on table that contains randomized encrypted data in SQL Server 2019 | SQL security | All | |
4538382 | Implement support for Kerberos constrained delegation in SQL Server 2019 on Linux | SQL Engine | Linux | |
4538378 | FIX: The "is_media_read_only" value remains unchanged for a SQL Server data file even though the media is no longer read-only | SQL Engine | Windows | |
4538377 | FIX: Non-yielding scheduler condition occurs when you run batch mode query with multiple joins in SQL Server 2017 and 2019 | SQL performance | All | |
4538344 | FIX: Passwords are masked in audit logs in SQL Server 2019 | SQL security | All | |
4538342 | FIX: Latest drivers fail to work with in-memory compiled queries in SQL Server 2019 | SQL security | All | |
4538205 | Improvement: Download new CAB files that have fixes for R/Python runtime features | SQL Engine | Windows | |
4538174 | FIX: Error occurs and AG will be in non-synchronizing state when failover happens in primary AG of Distributed Availability Group in SQL Server 2017 on Linux | High Availability | All | |
4538164 | FIX: Error occurs when you run the same PolyBase query multiple times in SQL Server 2019 | SQL Engine | All | |
4538163 | FIX: PolyBase may fail to generate dumps if an error occurs during the distributed query optimization phase in SQL Server 2019 | SQL Engine | All | |
4538162 | FIX: Unable to start PolyBase services when TCP/IP is not enabled in SQL Server 2019 Developer Edition | SQL Engine | Windows | |
4538161 | FIX: Error occurs when you run queries in PolyBase scale-out groups in SQL Server 2019 | SQL Engine | Windows | |
4538160 | Improvement: Correct the floating point data type in SQL Server 2019 | SQL Engine | Linux | |
4538112 | Improvement: Use QUOTENAME with EXECUTE AT to query on table that has column name with quotes in SQL Server 2019 | SQL Engine | All | |
4538036 | FIX: Error occurs when you query storage pool external table that contains column with money data type in SQL Server 2019 BDC | SQL Engine | Linux | |
4538017 | FIX: Severe contention on LOGCACHE_ACCESS spinlock in SQL Server 2019 | SQL Engine | All | |
4537869 | FIX: Log shipping agent is not able to log history and error information to SQL Server 2019 | High Availability | Windows | |
4537868 | Improvement: Enable DNN feature in SQL Server 2019 FCI | SQL connectivity | Windows | |
4537751 | FIX: Error due to explicit transaction isolation level hint when accessing Memory-Optimized Tempdb catalog views in SQL Server 2019 | SQL Engine | Windows | |
4537749 | Improvement: Port additional two system tables in Tempdb Memory-Optimized Metatdata feature in SQL Server 2019 | SQL Engine | All | |
4537710 | FIX: SOS_BLOCKALLOCPARTIALLIST spin lock contention may occur when TF 834 is enabled in SQL Server 2019 | SQL Engine | All | |
4537637 | FIX: Master database takes primary database offline for 1.5 hours which causes the GiantDB to be in unhealthy state in SQL Server 2019 | High Availability | All | |
4537452 | FIX: Logreader doesn't execute when you upgrade from SQL Server 2017 to 2019 | SQL Engine | Windows | |
4537350 | FIX: Access violation occurs when you run DBCC CHECKTABLE against a table with Clustered Columnstore Index in SQL Server 2017 and 2019 | SQL Engine | Windows | |
4537347 | FIX: Error 544 occurs when you use SET IDENTITY_INSERT on temp table in SQL Server 2019 | SQL Engine | All | |
4537300 | FIX: Change the NuGet that's used for Polaris in SQL Server 2019 | SQL Engine | Linux | |
4537072 | FIX: Creating an external table against an Oracle database in SQL Server 2019 may fail if using Oracle database 12.2 or later versions | SQL Engine | All | |
4536841 | FIX: Error occurs while creating External Data Source for Data Pool that has nondefault name for LOCATION in SQL Server 2019 | SQL Engine | All | |
4536684 | FIX: Error occurs when QDS is turned on or you generate query plan for Polybase queries in SQL Server 2019 | SQL Engine | All | |
4536005 | Improvement: Fix incorrect memory page accounting that causes out-of-memory errors in SQL Server 2019 | SQL Engine | All | |
4534249 | FIX: Unable to execute sys.dm_exec_requests when you install SQL Server 2019 or when you upgrade from prior versions of SQL Server | High Availability | All | |
4534148 | FIX: PolyBase query may hang if you cancel the query after it is started in SQL Server 2019 | SQL Engine | All | |
4533497 | FIX: External satellite process scripts like R, Python are unable to access any directories outside of their working directory in SQL Server 2019 | SQL Engine | All | |
4531736 | FIX: SQLDiag fails to generate output due to missing stored procedure tempdb.dbo.sp_sqldiag14 in SQL Server 2017 and 2019 | Management Tools | Windows | |
4531702 | FIX: Assertion occurs when TF 831 is turned ON/OFF multiple times in SQL Server 2019 | SQL Engine | All | |
4531384 | FIX: Queries may fail in SQL Server 2019 when PolyBase is under stress and heavy cancellations | SQL Engine | All | |
4531232 | FIX: PolyBase Engine Service may dump if an error occurs during retrieval of Data Pool metadata in SQL Server 2019 | SQL Engine | Linux | |
4531010 | FIX: CREATE INDEX with new CE reads the partition table and results in huge row count higher than the total table row count in SQL Server | SQL performance | Windows | |
4530443 | FIX: Non-yielding scheduler issue occurs in SQL Server when you run an online build for an index that's not partition-aligned | SQL performance | Windows | |
4530259 | FIX: Scripts generated by SSMS collect different wait types after you install SQL Server | SQL Engine | Windows | |
4530251 | FIX: Error 8601 occurs when you run a query with partition function in SQL Server | SQL performance | Windows | |
4530212 | FIX: Access violation occurs when you use sys.dm_os_memory_objects in SQL Server | SQL performance | Linux | |
4529833 | FIX: sp_describe_parameter_encryption returns different results if you switch parameter positions in SQL Server 2017 and 2019 | SQL security | Windows | |
4528250 | FIX: Assertion error occurs when you use IDENT_CURRENT on view that has identity columns in SQL Server | In-Memory OLTP | Windows | |
4528067 | FIX: Error 8959 may occur on IAM page when you query sys.dm_db_index_physical_stats against partitioned columnstore table after partition switch in SQL Server | SQL performance | Windows | |
4528066 | FIX: Unable to restore SQL Server 2012 databases on SQL Server 2016, 2017 or 2019 because of NCCI | SQL Engine | Windows | |
4527916 | FIX: You may receive incorrect object_id after you switch a partition in SQL Server 2017 and 2019 | SQL Engine | Windows | |
4527716 | FIX: You may encounter a non-yielding scheduler condition when you run query with parallel batch-mode sort operator in SQL Server | SQL performance | Windows | |
4527355 | FIX: Synchronized job may fail when the target servers start to synchronize the database in SQL Server 2016 and 2017 | SQL Engine | Windows | |
4527229 | FIX: UPDATE STATISTICS takes very long time to generate maintenance plan for large databases in SQL Server | SQL Engine | Windows | |
4525483 | FIX: Exception error 3628 may occur when you run stored procedure in SQL Server | SQL Engine | Windows | |
4524542 | FIX: MDS and/or LocalDB patch installation fails if you patch SQL Server with a next CU | Setup & Install | Windows | |
4523102 | FIX: SQL Server database remains in frozen I/O state indefinitely when backed up by VSS | SQL Engine | Windows |
KB | Description | Cumulative Update | Fix area | Platform | Learn More |
4536077 | FIX: Dump is generated when you create an AG with more than 122 characters in SQL Server 2019 | SQL Server 2019 CU1 | High Availability | All | |
4533251 | FIX: Upgrading FCI passive node from SQL Server 2019 RC1 to RTM fails when you try to access the MSSQL\JOBS which is on the shared drive | SQL Server 2019 CU1 | High Availability | All | |
4531349 | FIX: DMVs fail when Big Data Cluster has multiple compute nodes in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | Linux | |
4531238 | FIX: Heap corruption occurs when ADR is disabled and aborted transactions are present in SQL Server 2019 database | SQL Server 2019 CU1 | SQL Engine | All | |
4531226 | FIX: Error occurs when you select from storage pool table and insert into another external table in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | Linux | |
4531225 | FIX: PolyBase query may hang when DMS restarts in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4531224 | FIX: Spurious lines may be added to the SQL Server error log at each initialization in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4531125 | Improvement: Update the hktempdb.dll version in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4531049 | FIX: Access violation occurs when you set database containment to NONE in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4531029 | FIX: Query may fail when you join a storage pool table with a data pool table in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4531026 | FIX: NullPointerException occurs when the name node is not active and the HTTP request has other failures in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | Linux | |
4531025 | Improvement: Update PolyBase vbump to 150.1812.0 in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | Linux | |
4530907 | Improvement: Corrupt statistics can be detected by using extended_logical_checks in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4530827 | FIX: Two issues with remote Hadoop bridge process in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | Linux | |
4530814 | Improvement: Add support to create index on encrypted unique identifier using Always Encrypted feature in SQL Server 2019 | SQL Server 2019 CU1 | SQL security | Windows | |
4530769 | FIX: FSM may be called when you create a database in SQL Server 2019 Big Data Clusters | SQL Server 2019 CU1 | SQL Engine | All | |
4530720 | FIX: "The File location cannot be opened" error occurs when you try to open a FileTable directory in SQL Server | SQL Server 2019 CU1 | SQL Engine | Windows | |
4530500 | FIX: Assertion dump occurs when sp_cdc_disable_db is executed to disable CDC or when distributed transaction is committed after ROLLBACK SAVEPOINT in SQL Server | SQL Server 2019 CU1 | SQL Engine | Windows | |
4530499 | FIX: Non-yielding scheduler error when Polybase function call to shared memory takes long time in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4530496 | FIX: Data pool database may be deleted if you fail to drop database on master in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4530468 | FIX: PolyBase Hadoop queries may fail when the launchpadd service is restarted or killed in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | Linux | |
4530427 | FIX: sp_describe_parameter_encryption returns different results with different parameter positions in SQL Server 2019 | SQL Server 2019 CU1 | SQL security | Windows | |
4530303 | FIX: Data masking of user-defined functions may result in crashes in SQL Server 2019 | SQL Server 2019 CU1 | SQL security | All | |
4530302 | Improvement: Add unlimited buffer size to support TDS V1 and V2 in SQL Server 2019 | SQL Server 2019 CU1 | SQL security | All | |
4530287 | Improvement: Dynamic Management View is added for external authentication in SQL Server 2019 | SQL Server 2019 CU1 | SQL security | Windows | |
4530286 | Improvement: Update SDK to improve security of Always Encrypted by using secure enclaves in SQL Server 2019 | SQL Server 2019 CU1 | SQL security | Windows | |
4530283 | Improvement: Execute Database upgrade scripts when Database state changes in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | Windows | |
4530281 | FIX: Typo in error message for Columnstore indexes on temporary tables in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4530280 | Improvement: Add new fields to latch_suspend_end Extended Event in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4530251 | FIX: Error 8601 occurs when you run a query with partition function in SQL Server | SQL Server 2019 CU1 | SQL performance | Windows | |
4530084 | FIX: Error occurs when you try to install SQL Server 2019 on a low power CPU | SQL Server 2019 CU1 | SQL security | Windows | |
4530080 | Improvement: Update the misspelled words in server_principal_sid and server_principal_name description in SQL Server 2019 | SQL Server 2019 CU1 | SQL security | Windows | |
4530079 | Improvement: Update error messages of Always Encrypted with secure enclaves in SQL Server 2019 | SQL Server 2019 CU1 | SQL security | Windows | |
4530055 | FIX: Access violation occurs when worker stealing is enabled and CPU capacity reaches maximal configured value in SQL Server 2019 | SQL Server 2019 CU1 | High Availability | All | |
4530054 | FIX: Worker stealing stops working when AG contains one or more encrypted databases in SQL Server 2019 | SQL Server 2019 CU1 | High Availability | All | |
4529944 | FIX: Unsigned files are installed through the Microsoft MPI in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | Windows | |
4529942 | FIX: Restore fails when you try to restore compressed TDE backups prior to SQL Server 2016 SP2 CU4 on SQL Server 2016 SP2 CU8 | SQL Server 2019 CU1 | SQL Engine | Windows | |
4529893 | FIX: Audit of batch may be skipped when the batch causes a failure that closes the session in SQL Server 2019 | SQL Server 2019 CU1 | SQL security | All | |
4529848 | FIX: PolyBase DMVs may return unexpected results after changing PolyBase enabled setting in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4528492 | FIX: DTC transaction scenario reports unsupported transaction error when HkTempdb transaction is used in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4528491 | FIX: Access violation occurs when you call HkError.Throw() in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4528490 | FIX: Access violation occurs when attempting to fetch the IAM page of the table in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4528337 | FIX: Assertion error when you run internal query in batch mode for populating full-text index on computed LOB in SQL Server 2019 | SQL Server 2019 CU1 | SQL performance | All | |
4528168 | FIX: Using temporary tables across multiple scopes may cause Error 213 or access violation in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4528139 | FIX: "Debug Assertion Failed" error if you create objects that are not hashed by name in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4528097 | FIX: Access violation occurs when you query sys.dm_db_persisted_sku_features DMV in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | All | |
4527538 | FIX: "A system assertion check has failed" error when a procedure call is made from CLR with an OUTPUT large object argument | SQL Server 2019 CU1 | SQL performance | All | |
4526315 | FIX: Database cannot recover and reports error 5243 in SQL Server | SQL Server 2019 CU1 | SQL Engine | Windows | |
4522405 | FIX: Non-yielding scheduler error occurs when you run batch query with sort operation in SQL Server 2017 and 2019 | SQL Server 2019 CU1 | SQL performance | All | |
4522002 | FIX: SQL Server 2017 and 2019 on Linux fails with an Assertion error | SQL Server 2019 CU1 | SQL Engine | Linux | |
4521960 | FIX: Access violation occurs when a clone database verification fails in SQL Server 2016, 2017 and 2019 | SQL Server 2019 CU1 | SQL Engine | Windows | |
4521739 | FIX: Error occurs when CDC capture process tries to insert duplicate key in table "cdc.lsn_time_mapping" in SQL Server 2016, 2017 and 2019 | SQL Server 2019 CU1 | SQL Engine | Windows | |
4521702 | FIX: ObjectPropertyEx Cardinality property for columnstore table doesn't include rows in delta store rowset or account rows in deleted bitmap rowset in SQL Server 2019 | SQL Server 2019 CU1 | SQL Engine | Windows | |
4521659 | FIX: SQL Writer Service fails to back up in non-component backup path in SQL Server 2016, 2017 and 2019 | SQL Server 2019 CU1 | SQL Engine | Windows | |
4519796 | FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016, 2017 and 2019 | SQL Server 2019 CU1 | SQL Engine | Windows | |
4519668 | FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016, 2017 and 2019 | SQL Server 2019 CU1 | SQL Engine | Windows | |
4519366 | FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server | SQL Server 2019 CU1 | SQL performance | All | |
4518364 | FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016, 2017 and 2019 | SQL Server 2019 CU1 | SQL Engine | Windows | |
4517771 | FIX: Orphaned CLR sessions cause blocking in SQL Server | SQL Server 2019 CU1 | SQL Engine | Windows | |
4515772 | FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server | SQL Server 2019 CU1 | High Availability | Windows |
KB | Description | Fix area | Platform | Learn More |
An error occurs after the failover of a Distributed Availability Group (AG) that attempts to connect to the secondary AG listener with application intent set to READ ONLY. Here are the possible error messages: Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server: Protocol error in TDS stream Invalid routing information received. | High Availability | Windows | ||
The AlwaysOn_Health extended event doesn't set STARTUP_STATE to ON during the instance starts. | High Availability | Windows | ||
The database recovery process is chosen as the deadlock victim on Availability Group (AG) failover under certain circumstances. The following error message is generated: | High Availability | Windows | ||
Improves the response time of the Sqldumpr.exe utility when in-memory objects are used in SQL Server or once existed. | In-Memory OLTP | All | ||
Lets more flexible cleanup and merge operations enable by changing In-Memory during restore operations. | In-Memory OLTP | Windows | ||
5008296 | FIX: Missing change data capture cleanup execution isn't identified because of a deadlock without an error message | SQL Engine | Windows | |
5013181 | FIX: A subscription is still active after the distribution retention period expires | SQL Engine | Windows | |
5013207 | FIX: Python is broken after the runtime upgrades to Python 3.7 | SQL Engine | Windows | |
A filtered index becomes corrupt after you drop a computed column on the same table, and the filtered index corruptions are reported as 8951 and 8955 errors when you run DBCC CHECKTABLE WITH EXTENDED_LOGICAL_CHECKS. | SQL Engine | Windows | ||
An access violation occurs when you use FileTables in SQL Server 2017. | SQL Engine | Windows | ||
The query against the dynamic management view (DMV) sys.dm_os_ring_buffers may cause an access violation (AV). | SQL Engine | All | ||
An access violation dump occurs when the query runs for a long time in parallel and tries to determine the version of the rowgroup for the particular transactions to read. | SQL Engine | Windows | ||
Restoring from a compressed backup that contains filestream content occasionally fails when the restore is run by using the Virtual Device Interface (VDI) client. The following error message is generated: Msg 3241 The media family on device ' | SQL Engine | Windows | ||
Traversing long IAM chains may cause a non-yielding scheduler and associated dump. | SQL Engine | Windows | ||
The Table Valued Function (TVF) misses calling the execution plan if the same TVF is referenced more than once in the same SQL query. | SQL Performance | Windows |
Description | Fix area | Platform |
Fixes an issue where sys.fn_hadr_backup_is_preferred_replica returns different results on secondary replicas of read-scale availability groups (Cluster_Type=None) when running on standalone machines or cluster nodes | High Availability | Windows |
Adds improvement to capture sp_server_diagnostics XEvent in an AlwaysOn_health XEvent session when STATE is 3 (ERROR) to diagnose HADR Health Events | SQL Engine | Windows |
Fixes an issue in which some of the temporary working folders are not cleared when many R queries are run in parallel | SQL Engine | Windows |
Fixes an issue where the default trace on Linux rolls over before the limit size of 20 MB | SQL Engine | Linux |
Fixes the following error that occurs when you back up a database by using virtual device interface (VDI) on ubuntu docker container installed SQL Server 2017: Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: ClientBufferAreaManager::SyncWithGlobalTable: Open(hBufferMemory): error 2Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: TriggerAbort: invoked: error 0Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: TriggerAbort: ChannelSem: error 2Features returned by SQL Server: 0x10000 Opening the device. VDS::OpenDevice fails: x80770004 Msg 18210, Level 16, State 1, Server , Line BackupVirtualDeviceSet::AllocateBuffer: failure on backup device '515697bb-6009-4018-b373-50c871ed736c'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). Msg 3013, Level 16, State 1, Server , Line BACKUP DATABASE is terminating abnormally. | SQL Engine | Linux |
Fixes an issue where SQL Server disconnects a session when it gets an attention and INTERLEAVED_EXECUTION_TVF is enabled | SQL performance | Windows |
Fixes an issue where executing concurrent queries with Large Object (LOB) parameters causes failed assertions in tmpilb.cpp and generates minidumps | SQL performance | Windows |
Fixes an issue in which the query processor can't produce a query plan if the USE PLAN hint specifies a query plan that has a left outer join and an inner join | SQL performance | Windows |
KB | Description | Fix area | Platform | Learn More |
5007158 | FIX: Access violation occurs when you use LOB data type with columnstore indexes in SQL Server 2017 | SQL Engine | All | |
5007039 | FIX: You encounter error messages 8114 or 22122 when performing change tracking cleanup | SQL Engine | Windows | |
5007381 | FIX: Sp_execute_external_script fails after you configure new runtime and remove a new Cumulative Update patch in SQL Server 2017 | SQL Engine | Windows | |
Prevents ghost cleanup from triggering a memory dump during latch time-out in SQL Server 2019 | SQL Engine | Windows | ||
Fixes an issue where Failover Cluster Instance (FCI) setup fails on secondary nodes of a PolyBase scale-out group in a standard edition of SQL Server 2019. Here is the error message: The specified scaleout setting for Polybase is not the same as that specified for the active node in the SQL Server Failover Cluster. To continue, please provide False for the setting. | SQL Engine | Windows | ||
Fixes an intra-query deadlock that occurs with certain queries when verbose truncation feature is enabled | SQL Engine | Windows | ||
Fixes the failed assertion that occurs due to implicit conversion where predicate's precision is greater than the value: Msg 3624, Level 20, State 1, Line LineNumber A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support. Msg 596, Level 21, State 1, Line LineNumber Cannot continue the execution because the session is in the kill state. Msg 0, Level 20, State 0, Line LineNumber A severe error occurred on the current command. The results, if any, should be discarded. | SQL Engine | Windows | ||
Fixes an issue where an incorrect name entry in sys.servers can result in Always On Availability Group (AG) replica being removed when the server name does not match Windows hostname | High Availability | Windows | ||
Fixes an issue where Cumulative Update (CU) patching fails with the following message when you set default data directory to Azure Blob Storage URL: The given path's format is not supported. Exception Type “System.NotSupportedException” Note To work around the issue, you can change the data default directory to a local directory and rerun the SQL patch. | Setup & Install | Windows | ||
Fixes an issue about extended event version in Alwayson_health session is not changed automatically during Cumulative Update upgrade and downgrade | High Availability | Windows | ||
Fixes an issue where the output of sp_pkeys KEY_SEQ column doesn't conform to the ordering of columns defined in the Primary Key | SQL Engine | Windows | ||
Fixes an access violation exception that may occur when sp_server_diagnostics is executed | High Availability | Windows |
KB | Description | Fix area | Platform | Learn More |
5004734 | FIX: Persisted computed columns not being consistently blocked for Columnstore index | SQL performance | All | |
5004936 | FIX: Error when you use columnstore indexes and run versioned scans if all rows in a compressed rowgroup are deleted in SQL Server 2017 and 2019 | SQL Engine | All | |
Fixes an issue in SQL Server 2017 and 2019 where you may encounter an Access Violation or Assertion when using the sys.dm_exec_query_statistics_xml Dynamic Management View | SQL performance | All | ||
5004750 | FIX: SQL Server often crashes when network.forceencryption property is set to '1' | SQL Engine | Linux | |
4039592 | FIX: Cannot change the password for a SQL Server service account when additional LSA protection is enabled | Management Tools | Windows | |
4530907 | Improvement: Corrupt statistics can be detected by using extended_logical_checks in SQL Server 2019 | SQL Engine | Windows | |
5004573 | FIX: SQL Server affinity settings are reset after applying CU for SQL Server 2017 and 2019 | SQL Engine | Windows | |
5005788 | FIX: Access violation occurs when you use FileTable feature with Windows Defender enabled | SQL Engine | Windows | |
5006029 | FIX: Assertion failure may occur when sp_cleanup_history_table is executed in SQL Server 2017 | SQL Engine | Windows | |
Fixes an intra-query deadlock that occurs with certain queries when verbose truncation feature is enabled | SQL Engine | Windows | ||
Fixes an issue where Last_sent_time and Last_received_time columns in DMV dm_hadr_database_replica_states does not get updated | High Availability | Windows | ||
Adds improvement to report SQL Server native error 35217 in the AlwaysOn_health XEvent log: DateTimeSpid Error: 35217, Severity: 16, State: 1. DateTimeSpid The thread pool for Always On Availability Groups was unable to start a new worker thread because there are not enough available worker threads. This may degrade Always On Availability Groups performance. Use the "max worker threads" configuration option to increase number of allowable threads. | High Availability | Windows | ||
Fixes missing data in the Change Data Capture (CDC) side table and adds additional error handling to prevent data loss | SQL Engine | Windows | ||
Fixes an issue in SQL Server 2017 where you may encounter an Access Violation or Assertion when using the sys.dm_exec_query_statistics_xml Dynamic Management View | SQL performance | Windows | ||
Fixes an issue where Distributed Replay Client may fail with an unhandled exception. This fix is for the Distributed Replay Client that shipped with SQL Server 2017. The following is the error you may observe in the output/log file: DateTime OPERATIONAL [Common] Unhandled exception is encountered. [Exception Code = 3221225477] DateTime OPERATIONAL [Common] Invoking dump. DateTime OPERATIONAL [Common] Service terminating | Management Tools | Windows | ||
Adds pOwnerSess to the error message to find the owner session Id that runs the Log Reader Agent or log - related procedure in SQL Server 2017 | SQL Engine | Windows | ||
Fixes the issue where datatype is not included in the warning message instead a 'null' value appears: Warning: Article with '(null)' data type column is not supported with memory optimized tables on subscribers running SQL Server 2014 or earlier | SQL Engine | Windows | ||
Fix to keep 'PERSIST_SAMPLE_PERCENT' value for statistics on an indexed column after index rebuild | SQL performance | Windows |
KB | Description | Fix area | Platform | Learn More |
5004466 | FIX: Update SQL Server 2017 CEIP service to send usage and diagnostic data to a new endpoint | SQL Engine | All | |
Fixes the Assertion error that occurs while performing database recovery in SQL Server 2017 | SQL Engine | All | ||
Fixes an issue on how to rotate the service account password without restarting SQL Server | SQL Engine | Linux | ||
5004560 | FIX: Wrong results may occur during Clustered Columnstore Index alter index reorganize in versioned scans in SQL Server 2017 | SQL Engine | Windows | |
5004646 | FIX: Access Violation on secondary replica may occur when you drop index from view on primary replica in SQL Server 2017 | SQL performance | Windows | |
5004766 | Improvement: Failover Cluster DNN in SQL Server 2017 | SQL connectivity | Windows | |
4578579 | Improvement: Availability Group listener without the load balancer in SQL Server 2017 and 2019 | High Availability | Windows | |
Fixes an issue where a query is stuck in BATCH_MODE_SORT in SQL Server 2017 | SQL Engine | Windows | ||
Fixes the EXCEPTION_INVALID_CRT_PARAMETER dump that is generated on performing INSERT\UPDATE of wide replicated table in SQL Server 2017 | SQL Engine | Windows | ||
Adds support for 32 key columns to system sp_pkeys and fixes the performance regression that occurs after the installation of Cumulative Update 21 (CU21) for SQL Server 2017 | SQL Engine | Windows | ||
Fixes an issue in which a database freezes its I/O during a VSS backup but never thaws the I/O. This can lead to latch timeouts | SQL Engine | Windows | ||
Fixes an issue that causes the database log_reuse_wait_desc to change to AVAILABILITY_REPLICA when a database is removed from Availability Group | High Availability | Windows | ||
Fixes an issue where Setup Account Privileges check may not be performed when installing Cumulative Update or Security Update | Setup & Install | Windows | ||
Fixes an issue where you are unable to set up Managed Backup on SQL 2016/2017 by using Azure SAS credential with a long secret due to SAS expiration in SQL Server 2017 | SQL Engine | Windows | ||
Fixes a potential issue that causes error 5511 when performing a log backup on a database that has filestream data | SQL Engine | Windows | ||
Fixes an issue where SQL Server 2017 CU22 using XTP UserDB for staging tables has steady growing trend for "VARHEAP\Storage internal heap" in dm_db_xtp_memory_consumers that leads to OOM/41805 errors when it reaches 50/60GB and requires proactive restart/failover to retain stability | In-Memory OLTP | Windows | ||
Adds improvement to help diagnose replica connection timeout errors. Note This improvement adds sqlserver.ucs_connection_setup XEvent and 35206, 35201 ERROR_REPORTED XEvent to AlwaysOn_health, to provide additional logging detail when connection timeout occurs between error log. SSAS does not work with AlwaysOn Availability Groups, but need a different solution for DR unless you are using SQL databases as your data source. | High Availability | Windows |
KB | Description | Fix area | Platform | Learn More |
5000651 | FIX: Assert failure occurs when concurrent query modifies the same bitmap during clustered columnstore delete bitmap seek in SQL Server 2016 and 2017 | SQL Engine | All | |
5001260 | Improvement: Performance improvements of several spatial built-in properties and methods in SQL Server | SQL Engine | All | |
Fixes an Access Violation (AV) that occurs when error is being collected for Availability Group (AG) DB Failover while there is a AG failover undergoing | High Availability | All | ||
Improves the records stage of failure and error during stack copy for better diagnostics | SQL Engine | All | ||
Fixes an issue where optimizer doesn't push down constant parameter to remote query via linked server | SQL performance | All | ||
Disables FQDNs in AD usernames when creating/modifying SQL Logins/users for SQL Server 2019 on Linux | SQL Engine | Linux | ||
Fixes an error that occurs when you execute a query by using sp_send_dbmail inside a SQL Agent Job to send mails with attachments | SQL Engine | Linux | ||
Fixes "Fast Fail" error that occurs when SQL Server 2017 on Linux creates core dumps and SQL Server not starting after applying the latest update | SQL Engine | Linux | ||
4023170 | FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014 | SQL Engine | Windows | |
4589350 | FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server | SQL performance | Windows | |
5000715 | FIX: Failures with log reader agent occurs when you create and drop publication on CDC-enabled database in SQL Server 2019, 2017, and 2016 | SQL Engine | Windows | |
5001423 | FIX: Delete operation may fail with 7105 error in SQL Server 2017 | SQL Engine | Windows | |
5003342 | FIX: SqlLocalDB fails to start shared instances or you cannot connect to shared instances of SqlLocalDB in SQL Server 2017 | SQL Engine | Windows | |
When a VSS backup tries to backup SQL Server databases that are hosted on the forwarder replica of a Distributed Availability Group, the backup operation fails. This BACKUP or RESTORE command is not supported on a database mirror or secondary replica. BACKUP DATABASE is terminating abnormally. In the error log, you may see the following error: DateTime Backup Error: 3041, Severity: 16, State: 1. DateTime Backup BACKUP failed to complete the command BACKUP DATABASE DatabaseName. Check the backup application log for detailed messages. | SQL Engine | Windows | ||
Fixes an issue with the Foreign Key added to a table that is referencing a table's column which is part of a unique index with included columns. When the table's ALTER command is replicated, Distribution Agent fails with the following error message. Number of referencing columns in foreign key differs from number of referenced columns, table 'TableName'. (Source: MSSQLServer, Error number: 8139) | SQL Engine | Windows | ||
Fixes an Access Violation error that occurs at sqllang!CStatement::SetDbIdMaskingUsageInfo+0x11 in SQL Server 2016 | SQL security | Windows | ||
Fixes FullText query not returning the expected values that are located on the FullText index structure with AccentSensitivity turned on | SQL Engine | Windows | ||
Fixes the performance issue that occurs with CHANGETABLE function and syscommit on SQL Server 2017 | SQL performance | Windows | ||
Fixes an Access Violation error that occurs when importing large amount of data to Azure Blob storage. This can occur if PolyBase Data Movement Service encounters out-of-memory condition during large data insert transaction | SQL Engine | Windows | ||
Fixes an issue where DBCC PAGE with option 3 generates access violation dumps after dropping a unique identifier column from the table in SQL Server 2017. Msg 596, Level 21, State 1, Line LineNumber Cannot continue the execution because the session is in the kill state. Msg 0, Level 20, State 0, Line LineNumber A severe error occurred on the current command. The results, if any, should be discarded. | SQL Engine | Windows | ||
Fixed the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all the memory available is taken. | SQL Engine | Windows | ||
Fixes the sp_hadr_verify_replication_publisher displaying wrong distribution database name in error in SQL Server 2017 | SQL Engine | Windows | ||
After FIPS is enabled in Windows, you cannot enable Managed Backup in SQL Server 2017. When trying to do so, the Application event log will record a 57054 error (from the "Microsoft SQL Server Automated Backup" source) with the following message: [Warning] ManagedBackupBackupCertificateFailed: System.Exception: Failed to backup certificate and upload it to Azure storage. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms. | SQL Engine | Windows |
KB | Description | Fix area | Platform | Learn More |
5000649 | FIX: Wrong results due to undetected concatenation parameters from scalar expression | SQL performance | All | |
5001044 | FIX: Wrong results when you run a query on In-Memory optimized tables in SQL Server 2017 | In-memory OLTP | All | |
5001045 | FIX: Memory grant wait times out when you run many Columnstore bulk inserts concurrently in SQL Server 2017 | SQL Engine | All | |
Fixes an issue where ALTER AVAILABILITY GROUP SET (ROLE=SECONDARY) raises an error 41104. However, it doesn't impact the Always On Availability Group health | High Availability | All | ||
Intermittent error 6552 occurs when running Spatial query with TOP or OFFSET ROWS FETCH NEXT ROWS ONLY clause and parallel plan | SQL Engine | All | ||
Query Store scalability improvement for ad-hoc workloads. Query Store now imposes internal limits to the amount of memory, it can use and automatically changes the operation mode to READ-ONLY until enough memory has been returned to the Database Engine, preventing performance issues. | SQL Engine | All | ||
Fixes an issue where an access violation exception may occur when you execute queries in read uncommitted mode with high concurrent read or write pattern over XML data types | SQL Engine | All | ||
4336876 | FIX: SQL Server on Linux does not start after trace flag 8809 is enabled | SQL Engine | Linux | |
4582558 | FIX: SQL Server service fails to start in Linux operating system | SQL Engine | Linux | |