Backup exec updating catalogs hang
If not mitigated, this issue will also fill up disk space allocated for the error logs, as every attempt to execute cleanup produces a dump file.
Cleanup activation period depends on the workload frequency, but it is no longer than 15 min.
Try it out: Download SQL Server 2016 from the Evaluation Center Have an Azure account?
Then go Here to spin up a Virtual Machine with SQL Server 2016 SP1 already installed.
Severity column represents the severity of the PMR at the time the APAR was opened.
THIS TOPIC APPLIES TO: SQL Server (starting with 2016)Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse This article describes limitations and issues with SQL Server 2016 releases.
Workaround: Drop the index that uses the INCLUDE keyword, enable Stretch Database on the table, then recreate the index.
If you do this, be sure to follow your organization's maintenance practices and policies to ensure minimal or no impact to users of the affected table.
Consequently, if data is not purged manually, space used by the Query Store will grow over time until configured limit is reached.Workaround: If you plan to use Query Store on editions other than Enterprise and Developer, you need to explicitly turn off cleanup policies.It can be done either from SQL Server Management Studio (Database Properties page) or via Transact-SQL script: Issue and customer impact: A downloadable version of the SQL Server 2016 documentation is not yet available.[SSMS: To get the latest version of SQL Server Management Studio, see Download SQL Server Management Studio (SSMS).For information on what's new, see What's New in SQL Server 2016.