360服务器已停止响应,对于 SQL Server 2017年累积更新 5

累积更新包信息

先决条件要应用此累积更新程序包，必须运行 SQL Server 2017。

重启信息

应用此累积更新包后，可能必须重新启动计算机。

注册表信息

要使用此程序包中的某个修补程序，不必对注册表进行任何更改。

查询存储通知

重要说明

如果您使用查询存储功能，并且您以前已经安装累积更新 2 (CU2) (14.0.3008.27)，以下要求适用于您：

安装后累积更新 3 (CU3) (14.0.3015.40)或更高版本的 CU，必须立即运行下面的脚本来删除查询存储 CU2 安装时所收集的所有计划：

SET NOCOUNT ON;

DROP TABLE IF EXISTS #tmpUserDBs;

SELECT [database_id], 0 AS [IsDone]

INTO #tmpUserDBs

FROM master.sys.databases

WHERE [database_id] > 4

AND [state] = 0 -- must be ONLINE

AND is_read_only = 0 -- cannot be READ_ONLY

AND [database_id] NOT IN (SELECT dr.database_id FROM sys.dm_hadr_database_replica_states dr -- Except all local Always On secondary replicas

INNER JOIN sys.dm_hadr_availability_replica_states rs ON dr.group_id = rs.group_id

INNER JOIN sys.databases d ON dr.database_id = d.database_id

WHERE rs.role = 2 -- Is Secondary

AND dr.is_local = 1

AND rs.is_local = 1)

DECLARE @userDB sysname;

WHILE (SELECT COUNT([database_id]) FROM #tmpUserDBs WHERE [IsDone] = 0) > 0

BEGIN

SELECT TOP 1 @userDB = DB_NAME([database_id]) FROM #tmpUserDBs WHERE [IsDone] = 0

-- PRINT 'Working on database ' + @userDB

EXEC ('USE [' + @userDB + '];

DECLARE @clearPlan bigint, @clearQry bigint;

IF EXISTS (SELECT [actual_state] FROM sys.database_query_store_options WHERE [actual_state] IN (1,2))

BEGIN

IF EXISTS (SELECT plan_id FROM sys.query_store_plan WHERE engine_version = ''14.0.3008.27'')

BEGIN

DROP TABLE IF EXISTS #tmpclearPlans;

SELECT plan_id, query_id, 0 AS [IsDone]

INTO #tmpclearPlans

FROM sys.query_store_plan WHERE engine_version = ''14.0.3008.27''

WHILE (SELECT COUNT(plan_id) FROM #tmpclearPlans WHERE [IsDone] = 0) > 0

BEGIN

SELECT TOP 1 @clearPlan = plan_id, @clearQry = query_id FROM #tmpclearPlans WHERE [IsDone] = 0

EXECUTE sys.sp_query_store_unforce_plan @clearQry, @clearPlan;

EXECUTE sys.sp_query_store_remove_plan @clearPlan;

UPDATE #tmpclearPlans

SET [IsDone] = 1

WHERE plan_id = @clearPlan AND query_id = @clearQry

END;

PRINT ''- Cleared possibly affected plans in database [' + @userDB + ']''

END

ELSE

BEGIN

PRINT ''- No affected plans in database [' + @userDB + ']''

END

END

ELSE

BEGIN

PRINT ''- Query Store not enabled in database [' + @userDB + ']''

END')

UPDATE #tmpUserDBs

SET [IsDone] = 1

WHERE [database_id] = DB_ID(@userDB)

END

参考

Writer Review: v-madora

Tech Reviewer: sanat;leewoods;DS D- SQL Server Preview

Editor: v-phoebh