[玩转系统] 使用 T-SQL 脚本快速重新索引 WSUS 数据库

作者：精品下载站日期：2024-12-14 10:22:09 浏览：13 分类：玩电脑

使用 T-SQL 脚本快速重新索引 WSUS 数据库

在本文中，我将向您展示如何使用 T-SQL 脚本重新索引 WSUS 数据库。重新索引 WSUS 数据库可提高 WSUS 和 WSUS 部署的性能。

当您拥有用于部署更新的独立 WSUS 服务器时，随着时间的推移，数据库的性能会下降。这是 WSUS 管理员的一个已知问题。

为了提高 WSUS 数据库的性能，您可以运行一个简单的 T-SQL 脚本，该脚本是一个 WSUSDBMaintenance 脚本，用于重新索引 WSUS 数据库并对其进行碎片整理。

如果 WSUS 数据库维护不当，大型 WSUS 部署的性能将随着时间的推移而降低。因此，您必须付出额外的努力来维护和重建WSUS数据库。

有两种方法可以重新索引 WSUS 数据库，具体取决于其安装方式。

如果您使用的是 Windows 内部数据库，则需要使用 sqlcmd 实用程序，该实用程序可以从 docs.microsoft.com SQLCMD 页面下载。
如果 WSUS DB 位于 SQL Server 上，则可以使用 SQL Server Management Studio 针对数据库运行 WSUSDBMaintenance 脚本（T-SQL 脚本）。

注意：您不应在 WSUS 2.0 数据库上使用 WSUSDBMaintenance 脚本，因为它不受支持。

WSUSDBMaintenance 脚本有什么作用？

此 WSUSDBMaintenance 脚本在 SUSDB 上执行基本维护任务：

识别碎片化的索引，并对它们进行碎片整理。
对于某些表，设置填充因子以提高插入性能。
更新可能过时的表统计信息。
提高 WSUS 数据库的性能。

下载 WSUSDBMaintenance T-SQL 脚本

您可以从 Microsoft 文档下载 WSUSDBMaintenance T-SQL 脚本。您可以复制脚本并针对 SUSDB 运行它，也可以将脚本保存到文件中并在 SSMS 中运行。

重新索引 WSUS 数据库的步骤

使用 T-SQL 脚本重新索引 WSUS 数据库：

启动 SQL Server Management Studio。
使用您的凭据连接到数据库引擎。
展开数据库，右键单击 SUSDB 并选择新建查询。

在查询窗口中，粘贴 WSUSDBMaintenance 脚本（T-SQL 脚本）并单击执行。

等待 T-SQL 脚本运行。该脚本会重新索引 WSUS 数据库并对其进行碎片整理。查询输出中的以下行确认重新索引 WSUS 数据库操作已成功完成。

Statistics for all tables have been updated.
Done updating statistics.2022-04-13 15:00:23.490
Completion time: 2022-04-13T15:00:23.5018971+05:30

以下输出是 WSUS 数据库维护脚本的输出。我添加了这个供我参考。

Estimating fragmentation: Begin. 2022-04-13 14:59:54.203
Number of indexes to rebuild: 53
Estimating fragmentation: End. 2022-04-13 14:59:56.287
2022-04-13 14:59:56.290 Executing: ALTER INDEX [nc1KBArticleForRevision] ON [dbo].[tbKBArticleForRevision] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:56.303 Done.
2022-04-13 14:59:56.303 Executing: ALTER INDEX [PK__tbMoreIn__DF49EF3C638F0653] ON [dbo].[tbMoreInfoURLForRevision] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:56.430 Done.
2022-04-13 14:59:56.430 Executing: ALTER INDEX [nc_RevisionID_ShortLanguage] ON [dbo].[tbMoreInfoURLForRevision] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:56.520 Done.
2022-04-13 14:59:56.520 Executing: ALTER INDEX [nc1SecurityBulletinForRevision] ON [dbo].[tbSecurityBulletinForRevision] REBUILD
2022-04-13 14:59:56.523 Done.
2022-04-13 14:59:56.523 Executing: ALTER INDEX [PK__tbLocali__D4CFF3987CA3BCDC] ON [dbo].[tbLocalizedPropertyForRevision] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:56.693 Done.
2022-04-13 14:59:56.693 Executing: ALTER INDEX [nc1LocalizedPropertyID] ON [dbo].[tbLocalizedPropertyForRevision] REORGANIZE
2022-04-13 14:59:57.020 Done.
2022-04-13 14:59:57.020 Executing: ALTER INDEX [PK__tbFileFo__42CF22AD880D1325] ON [dbo].[tbFileForRevision] REORGANIZE
2022-04-13 14:59:57.080 Done.
2022-04-13 14:59:57.080 Executing: ALTER INDEX [nc1FileForRevision] ON [dbo].[tbFileForRevision] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.123 Done.
2022-04-13 14:59:57.123 Executing: ALTER INDEX [PK__tbFileHa__67EC15CE6D7F5C88] ON [dbo].[tbFileHash] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.147 Done.
2022-04-13 14:59:57.147 Executing: ALTER INDEX [PK__tbRevisi__43332583DDF5C093] ON [dbo].[tbRevisionSupersedesUpdate] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.193 Done.
2022-04-13 14:59:57.193 Executing: ALTER INDEX [nc1SupercededUpdateID] ON [dbo].[tbRevisionSupersedesUpdate] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.237 Done.
2022-04-13 14:59:57.237 Executing: ALTER INDEX [PK__tbInstal__C3A16224D78C8EC9] ON [dbo].[tbInstalledUpdateSufficientForPrerequisite] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.310 Done.
2022-04-13 14:59:57.313 Executing: ALTER INDEX [nc1InstalledUpdateSufficientForPrerequisite] ON [dbo].[tbInstalledUpdateSufficientForPrerequisite] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.383 Done.
2022-04-13 14:59:57.383 Executing: ALTER INDEX [tbBundleAtLeastOne_PK] ON [dbo].[tbBundleAtLeastOne] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.393 Done.
2022-04-13 14:59:57.393 Executing: ALTER INDEX [PK__tbPrereq__4E62540B6C754374] ON [dbo].[tbPrerequisiteDependency] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.483 Done.
2022-04-13 14:59:57.483 Executing: ALTER INDEX [nc1PrerequisiteDependency] ON [dbo].[tbPrerequisiteDependency] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.560 Done.
2022-04-13 14:59:57.560 Executing: ALTER INDEX [nc2PrerequisiteDependency] ON [dbo].[tbPrerequisiteDependency] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.670 Done.
2022-04-13 14:59:57.670 Executing: ALTER INDEX [nc1BundleDependency] ON [dbo].[tbBundleDependency] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.680 Done.
2022-04-13 14:59:57.680 Executing: ALTER INDEX [nc_LocalUpdateID] ON [dbo].[ivwApiUpdateRevision] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.693 Done.
2022-04-13 14:59:57.693 Executing: ALTER INDEX [nc_EffectiveArrivalTime] ON [dbo].[ivwApiUpdateRevision] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.710 Done.
2022-04-13 14:59:57.710 Executing: ALTER INDEX [tbEulaProperty_PK] ON [dbo].[tbEulaProperty] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.750 Done.
2022-04-13 14:59:57.750 Executing: ALTER INDEX [nc1EulaProperty] ON [dbo].[tbEulaProperty] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.777 Done.
2022-04-13 14:59:57.777 Executing: ALTER INDEX [nc2EulaProperty] ON [dbo].[tbEulaProperty] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 14:59:57.843 Done.
2022-04-13 14:59:57.843 Executing: ALTER INDEX [PK__tbLocali__ED9531CAD798662D] ON [dbo].[tbLocalizedProperty] REORGANIZE
2022-04-13 15:00:08.603 Done.
2022-04-13 15:00:08.603 Executing: ALTER INDEX [PK__tbRevisi__15217053B7552F2A] ON [dbo].[tbRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:08.637 Done.
2022-04-13 15:00:08.637 Executing: ALTER INDEX [nc1RevisionInCategory] ON [dbo].[tbRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:08.673 Done.
2022-04-13 15:00:08.673 Executing: ALTER INDEX [PK__tbFile__67EC15CE8A94D90B] ON [dbo].[tbFile] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:08.710 Done.
2022-04-13 15:00:08.710 Executing: ALTER INDEX [nc1Category] ON [dbo].[tbCategory] REBUILD
2022-04-13 15:00:08.710 Done.
2022-04-13 15:00:08.710 Executing: ALTER INDEX [nc2tbXml] ON [dbo].[tbXml] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:08.967 Done.
2022-04-13 15:00:08.967 Executing: ALTER INDEX [UQ__tbRevisi__FFEE745013572FBA] ON [dbo].[tbRevision] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:08.983 Done.
2022-04-13 15:00:08.983 Executing: ALTER INDEX [ncRevision_LocalUpdateID_RevisionNumber__IsLatestRevision] ON [dbo].[tbRevision] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:09.007 Done.
2022-04-13 15:00:09.007 Executing: ALTER INDEX [c0FileOnServer] ON [dbo].[tbFileOnServer] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:09.020 Done.
2022-04-13 15:00:09.020 Executing: ALTER INDEX [PK__tbFileOn__CEB6B0F6DEA5BF58] ON [dbo].[tbFileOnServer] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:09.037 Done.
2022-04-13 15:00:09.037 Executing: ALTER INDEX [UQ__tbUpdate__7A0CF3248A713C44] ON [dbo].[tbUpdate] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:09.057 Done.
2022-04-13 15:00:09.057 Executing: ALTER INDEX [c0DeploymentRevision] ON [dbo].[tbDeployment] REORGANIZE
2022-04-13 15:00:09.293 Done.
2022-04-13 15:00:09.293 Executing: ALTER INDEX [nc2DeploymentRevision] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:09.337 Done.
2022-04-13 15:00:09.337 Executing: ALTER INDEX [nc5DeploymentRevision] ON [dbo].[tbDeployment] REORGANIZE
2022-04-13 15:00:09.497 Done.
2022-04-13 15:00:09.497 Executing: ALTER INDEX [nc6DeploymentRevision] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:09.540 Done.
2022-04-13 15:00:09.540 Executing: ALTER INDEX [nc_RevisionID_TargetGroupID_ActionID] ON [dbo].[tbDeployment] REORGANIZE
2022-04-13 15:00:09.820 Done.
2022-04-13 15:00:09.820 Executing: ALTER INDEX [PK__tbDeadDe__5EF8D7176C4708F2] ON [dbo].[tbDeadDeployment] REBUILD
2022-04-13 15:00:09.823 Done.
2022-04-13 15:00:09.823 Executing: ALTER INDEX [PK__tbFlatte__15217053010D33F8] ON [dbo].[tbFlattenedRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:09.880 Done.
2022-04-13 15:00:09.880 Executing: ALTER INDEX [nc1FlattenedRevisionInCategory] ON [dbo].[tbFlattenedRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:09.900 Done.
2022-04-13 15:00:09.903 Executing: ALTER INDEX [PK__tbEventM__24626EC3227301B2] ON [dbo].[tbEventMessageTemplate] REBUILD
2022-04-13 15:00:09.907 Done.
2022-04-13 15:00:09.907 Executing: ALTER INDEX [PK__tbPreCom__5FF1DDB60E4CD459] ON [dbo].[tbPreComputedLocalizedProperty] REORGANIZE
2022-04-13 15:00:18.573 Done.
2022-04-13 15:00:18.573 Executing: ALTER INDEX [nc1PreComputedLocalizedProperty] ON [dbo].[tbPreComputedLocalizedProperty] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:18.960 Done.
2022-04-13 15:00:18.960 Executing: ALTER INDEX [PK__tbEventI__94C75A0739C22A4E] ON [dbo].[tbEventInstance] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:19.027 Done.
2022-04-13 15:00:19.027 Executing: ALTER INDEX [nc3EventInstanceConstraint] ON [dbo].[tbEventInstance] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:19.053 Done.
2022-04-13 15:00:19.053 Executing: ALTER INDEX [nc2EventInstance] ON [dbo].[tbEventInstance] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:19.063 Done.
2022-04-13 15:00:19.063 Executing: ALTER INDEX [ncEventInstance_ComputerID_EventNamespaceID_EventID] ON [dbo].[tbEventInstance] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:19.090 Done.
2022-04-13 15:00:19.090 Executing: ALTER INDEX [nc_EventNamespaceID_EventID] ON [dbo].[tbEventInstance] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:19.097 Done.
2022-04-13 15:00:19.097 Executing: ALTER INDEX [nc1RevisionLanguage] ON [dbo].[tbRevisionLanguage] REBUILD WITH (FILLFACTOR = 90)
2022-04-13 15:00:19.107 Done.
2022-04-13 15:00:19.110 Executing: ALTER INDEX [PK__tbPrecom__2DD8E6FD6241149C] ON [dbo].[tbPrecomputedCategoryLocalizedProperty] REBUILD
2022-04-13 15:00:19.113 Done.
2022-04-13 15:00:19.113 Executing: ALTER INDEX [nc2Property] ON [dbo].[tbProperty] REORGANIZE
2022-04-13 15:00:19.140 Done.
Estimated number of pages in fragmented indexes: 102530
Estimated number of pages freed: 12909
Updating all statistics.2022-04-13 15:00:19.170
Updating [dbo].[tbEventSource]
    [PK__tbEventS__DF51BBD6D6A69993] has been updated...
    [_WA_Sys_00000002_000AF8CF] has been updated...
    2 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbUpdateClassificationInAutoDeploymentRule]
    [PK__tbUpdate__EF57E38A19F10EBD], update is not necessary...
    [_WA_Sys_00000002_019E3B86], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbEventNamespace]
    [PK__tbEventN__D26A6B34FCC29735] has been updated...
    1 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbRevisionExtendedProperty]
    [cRevisionExtendedProperty], update is not necessary...
    [PK__tbRevisi__B4B1E3F016D22175], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbDcRollupStatus]
    [PK__tbDcRoll__3214EC077105E313], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbCategoryInAutoDeploymentRule]
    [PK__tbCatego__89359C8DF4025B99], update is not necessary...
    [_WA_Sys_00000002_038683F8], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbKBArticleForRevision]
    [PK__tbKBArti__41E15B739586BFE3] has been updated...
    [nc1KBArticleForRevision], update is not necessary...
    [tbKBArticleForRevision_RevisionID_AK] has been updated...
    2 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbTargetGroupInAutoDeploymentRule]
    [PK__tbTarget__EF99A0ABB21CCA34], update is not necessary...
    [_WA_Sys_00000002_056ECC6A], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbMoreInfoURLForRevision]
    [PK__tbMoreIn__DF49EF3C638F0653], update is not necessary...
    [nc_RevisionID_ShortLanguage], update is not necessary...
    [_WA_Sys_00000004_05D8E0BE] has been updated...
    1 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [sys].[sqlagent_jobs]
    [sqlagent_jobs_clust], update is not necessary...
    [sqlagent_jobs_nc1_name], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbDeletedDynamicCategory]
    [PK__tbDelete__3214EC0743504EAB], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [sys].[sqlagent_jobsteps]
    [sqlagent_jobsteps_clust], update is not necessary...
    [sqlagent_jobsteps_nc1], update is not necessary...
    [sqlagent_jobsteps_nc2], update is not necessary...
    0 index(es)/statistic(s) have been updated, 3 did not require update.
 
Updating [dbo].[tbSchemaVersion]
    [PK__tbSchema__3214EC27DAE12E5E] has been updated...
    1 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [sys].[sqlagent_job_history]
    [sqlagent_job_history_clust], update is not necessary...
    [sqlagent_job_history_nc1], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbSecurityBulletinForRevision]
    [PK__tbSecuri__2A32F464F3832071] has been updated...
    [nc1SecurityBulletinForRevision], update is not necessary...
    [tbSecurityBulletinForRevision_RevisionID_AK] has been updated...
    2 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [sys].[sqlagent_jobsteps_logs]
    [sqlagent_jobsteps_logs_nc1], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [sys].[plan_persist_query_text]
    [plan_persist_query_text_cidx], update is not necessary...
    [plan_persist_query_text_idx1], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbSchemaVersionHistory]
    [PK__tbSchema__3214EC279D8D69E4], update is not necessary...
    [_WA_Sys_00000002_0A338187], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbLocalizedPropertyForRevision]
    [PK__tbLocali__D4CFF3987CA3BCDC], update is not necessary...
    [nc1LocalizedPropertyID] has been updated...
    [_WA_Sys_00000003_0A9D95DB] has been updated...
    2 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [sys].[plan_persist_query]
    [plan_persist_query_cidx], update is not necessary...
    [plan_persist_query_idx1], update is not necessary...
    [_WA_Sys_0000000B_0AD2A005], update is not necessary...
    [_WA_Sys_00000007_0AD2A005], update is not necessary...
    0 index(es)/statistic(s) have been updated, 4 did not require update.
 
Updating [dbo].[tbLocaleMap]
    [PK__tbLocale__AE84BA92DDB0A12D] has been updated...
    1 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [sys].[plan_persist_plan]
    [plan_persist_plan_cidx], update is not necessary...
    [plan_persist_plan_idx1], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbFileForRevision]
    [PK__tbFileFo__42CF22AD880D1325] has been updated...
    [nc1FileForRevision], update is not necessary...
    [_WA_Sys_00000003_0C85DE4D] has been updated...
    2 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [sys].[plan_persist_runtime_stats]
    [plan_persist_runtime_stats_cidx], update is not necessary...
    [plan_persist_runtime_stats_idx1], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbOSMap]
    [PK__tbOSMap__AEE3B0B5DD1C5790] has been updated...
    1 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [sys].[plan_persist_runtime_stats_interval]
    [plan_persist_runtime_stats_interval_cidx], update is not necessary...
    [plan_persist_runtime_stats_interval_idx1], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbServerHealth]
    [PK__tbServer__DB06D1C03009743A], update is not necessary...
    [_WA_Sys_00000002_0E04126B] has been updated...
    [_WA_Sys_00000003_0E04126B] has been updated...
    2 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [sys].[plan_persist_context_settings]
    [plan_persist_context_settings_cidx], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbDownstreamServerRollupConfiguration]
    [PK__tbDownst__3214EC27811DF1F5] has been updated...
    1 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbFileHash]
    [PK__tbFileHa__67EC15CE6D7F5C88], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [sys].[plan_persist_query_hints]
    [plan_persist_query_hints_cidx], update is not necessary...
    [plan_persist_query_hints_idx1], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [sys].[plan_persist_query_template_parameterization]
    [plan_persist_query_template_parameterization_cidx], update is not necessary...
    [plan_persist_query_template_parameterization_idx1], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbProgramKeys]
    [PK__tbProgra__998876FC3880DEFD], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbEventRollupCounters]
    [PK__tbEventR__3214EC27DF7995EF] has been updated...
    1 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbRevisionSupersedesUpdate]
    [PK__tbRevisi__43332583DDF5C093], update is not necessary...
    [nc1SupercededUpdateID], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [sys].[plan_persist_wait_stats]
    [plan_persist_wait_stats_cidx], update is not necessary...
    [plan_persist_wait_stats_idx1], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
 
Updating [dbo].[tbComputersThatNeedDetailedRollup]
    [cComputersThatNeedDetailedRollup] has been updated...
    [_WA_Sys_00000002_12C8C788] has been updated...
    2 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbInstalledUpdateSufficientForPrerequisite]
    [PK__tbInstal__C3A16224D78C8EC9], update is not necessary...
    [nc1InstalledUpdateSufficientForPrerequisite], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
 
Updating [dbo].[tbConfigurationA]
    [PK__tbConfig__95AA539B8EE790E4], update is not necessary...
    [_WA_Sys_0000000E_13F1F5EB] has been updated...
    [_WA_Sys_00000018_13F1F5EB] has been updated...
    [_WA_Sys_0000000F_13F1F5EB] has been updated...
    [_WA_Sys_00000004_13F1F5EB] has been updated...
    4 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbBundleAtLeastOne]
    [tbBundleAtLeastOne_PK], update is not necessary...
    [nc1BundleAtLeastOne] has been updated...
    1 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbDriverTargetingGroup]
    [PK_DriverTargetingGroup_DriverTargetingID], update is not necessary...
    [AK_TargetGroupID], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbBundleAll]
    [tbBundleAll_PK] has been updated...
    [nc1BundleAll] has been updated...
    2 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbDriverTargetingGroupPrerequisite]
    [PK_DriverTargetingGroupPrerequisite_DriverTargetingID_LocalUpdateID], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbPrerequisite]
    [PK__tbPrereq__25A953F9CA9A8E9C] has been updated...
    [nc1Prerequisite] has been updated...
    2 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbDriver]
    [PK__tbDriver__258B78A97092C332], update is not necessary...
    [nc1Driver], update is not necessary...
    [nc2Driver], update is not necessary...
    [_WA_Sys_00000008_1AD3FDA4], update is not necessary...
    0 index(es)/statistic(s) have been updated, 4 did not require update.
 
Updating [dbo].[tbTargetedDriverHwid]
    [PK_tbTargetedDriverHwid_TargetGroupID_LocalUpdateID_HardwareID], update is not necessary...
    [IX_LocalUpdateID], update is not necessary...
    [_WA_Sys_00000003_1C5231C2], update is not necessary...
    0 index(es)/statistic(s) have been updated, 3 did not require update.
 
Updating [dbo].[tbCompatiblePrinterProvider]
    [PK__tbCompat__DA62685FB41D4181], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbDriverClass]
    [PK__tbDriver__CB1927A08A47C413], update is not necessary...
    [_WA_Sys_00000002_1EA48E88] has been updated...
    1 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbDriverFeatureScore]
    [PK_tbDriverFeatureScore_OperatingSystem_FeatureScore_RevisionID_HardwareID], update is not necessary...
    [IX_RevisionID], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbTargetGroup]
    [PK__tbTarget__73CAF84DA05C146B] has been updated...
    [_WA_Sys_00000007_208CD6FA], update is not necessary...
    [_WA_Sys_00000001_208CD6FA], update is not necessary...
    [_WA_Sys_00000006_208CD6FA], update is not necessary...
    [_WA_Sys_00000002_208CD6FA], update is not necessary...
    1 index(es)/statistic(s) have been updated, 4 did not require update.
 
Updating [sys].[wpr_bucket_table]
    [wpr_bucket_clustered_idx], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbDistributionComputerHardwareId]
    [PK_tbDistributionComputerHardwareId_DistributionComputerHardwareId_RevisionID_HardwareID], update is not necessary...
    [IX_RevisionID], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbConfiguration]
    [PK__tbConfig__737584F7C43BB1AD] has been updated...
    [_WA_Sys_00000002_251C81ED] has been updated...
    2 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbFlattenedTargetGroup]
    [cFlattenedTargetGroup] has been updated...
    [_WA_Sys_00000002_25518C17], update is not necessary...
    1 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbTargetComputerHardwareId]
    [PK_tbTargetComputerHardwareId_TargetComputerHardwareId_RevisionID_HardwareID], update is not necessary...
    [IX_RevisionID], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbPrerequisiteDependency]
    [PK__tbPrereq__4E62540B6C754374], update is not necessary...
    [nc1PrerequisiteDependency], update is not necessary...
    [nc2PrerequisiteDependency], update is not necessary...
    0 index(es)/statistic(s) have been updated, 3 did not require update.
 
Updating [dbo].[tbImplicitCategory]
    [PK__tbImplic__D0AB8860BF46F2E4] has been updated...
    [_WA_Sys_00000002_2704CA5F] has been updated...
    [_WA_Sys_00000003_2704CA5F] has been updated...
    [_WA_Sys_00000004_2704CA5F] has been updated...
    4 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbTargetGroupType]
    [PK__tbTarget__59800DAA89DD3F23], update is not necessary...
    [_WA_Sys_00000002_282DF8C2], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbBundleDependency]
    [PK__tbBundle__40BEE6EB142CF854] has been updated...
    [nc1BundleDependency], update is not necessary...
    1 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbExpandedTargetInTargetGroup]
    [PK__tbExpand__017B08B6EB34A6FF] has been updated...
    [nc1ExpandedTargetInTargetGroup] has been updated...
    [_WA_Sys_00000003_2A164134] has been updated...
    3 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbUpdateStatusPerComputer]
    [cUpdateStatusPerComputer], update is not necessary...
    [nc3UpdateStatusPerComputer], update is not necessary...
    [nc2UpdateStatusPerComputer], update is not necessary...
    0 index(es)/statistic(s) have been updated, 3 did not require update.
 
Updating [dbo].[tbCategoryInSubscription]
    [PK__tbCatego__D0AB88601B1C739B] has been updated...
    [_WA_Sys_00000001_2AD55B43] has been updated...
    2 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbUpdateSummaryForAllComputers]
    [PK__tbUpdate__41FBF71B944D41D9] has been updated...
    [_WA_Sys_00000002_2C3393D0] has been updated...
    [_WA_Sys_00000007_2C3393D0] has been updated...
    [_WA_Sys_00000006_2C3393D0] has been updated...
    [_WA_Sys_00000005_2C3393D0] has been updated...
    [_WA_Sys_00000004_2C3393D0] has been updated...
    [_WA_Sys_00000003_2C3393D0] has been updated...
    7 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbLanguageInSubscription]
    [PK__tbLangua__709AE7C0E199A62C], update is not necessary...
    [_WA_Sys_00000001_2CBDA3B5], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbTargetInTargetGroup]
    [PK__tbTarget__017B08B65E7D85F8] has been updated...
    [nc1TargetInTargetGroup] has been updated...
    2 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbEulaProperty]
    [tbEulaProperty_PK], update is not necessary...
    [nc1EulaProperty], update is not necessary...
    [nc2EulaProperty], update is not necessary...
    0 index(es)/statistic(s) have been updated, 3 did not require update.
 
Updating [dbo].[tbSchedule]
    [PK__tbSchedu__0AFEF4FF505588C7] has been updated...
    [_WA_Sys_00000002_2F9A1060], update is not necessary...
    [_WA_Sys_00000006_2F9A1060] has been updated...
    2 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbEulaAcceptance]
    [PK__tbEulaAc__51426B64EDE2F1AA], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbLocalizedProperty]
    [PK__tbLocali__ED9531CAD798662D] has been updated...
    [_WA_Sys_00000004_32AB8735] has been updated...
    [_WA_Sys_00000002_32AB8735] has been updated...
    [_WA_Sys_00000003_32AB8735] has been updated...
    4 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbEmailNotificationRecipient]
    [_WA_Sys_00000002_336AA144], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbComputerSummaryForMicrosoftUpdates]
    [PK__tbComput__2B1F0FB604F318EC] has been updated...
    [_WA_Sys_00000007_33D4B598] has been updated...
    [_WA_Sys_00000006_33D4B598] has been updated...
    [_WA_Sys_00000004_33D4B598] has been updated...
    [_WA_Sys_00000003_33D4B598] has been updated...
    [_WA_Sys_00000002_33D4B598] has been updated...
    [_WA_Sys_00000005_33D4B598] has been updated...
    7 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbRevisionInCategory]
    [PK__tbRevisi__15217053B7552F2A], update is not necessary...
    [nc1RevisionInCategory], update is not necessary...
    [_WA_Sys_00000003_345EC57D] has been updated...
    1 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbFile]
    [PK__tbFile__67EC15CE8A94D90B], update is not necessary...
    [_WA_Sys_0000000A_3493CFA7] has been updated...
    [_WA_Sys_00000009_3493CFA7] has been updated...
    [_WA_Sys_00000005_3493CFA7] has been updated...
    3 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbCategory]
    [PK__tbCatego__19093A2B07D353BA] has been updated...
    [nc1Category], update is not necessary...
    [_WA_Sys_00000003_373B3228] has been updated...
    [_WA_Sys_00000001_373B3228] has been updated...
    3 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbXml]
    [PK__tbXml__D14A66A9CC88A518] has been updated...
    [nc1tbXml] has been updated...
    [nc2tbXml], update is not necessary...
    [_WA_Sys_00000004_3A4CA8FD] has been updated...
    3 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbRequestedTargetGroup]
    [PK__tbReques__4AC8E77D35EB6745], update is not necessary...
    [AK_Name], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbRevision]
    [PK__tbRevisi__B4B1E3F16493AE88] has been updated...
    [UQ__tbRevisi__FFEE745013572FBA], update is not necessary...
    [ncRevision_LocalUpdateID_RevisionNumber__IsLatestRevision], update is not necessary...
    [_WA_Sys_0000000D_3BFFE745] has been updated...
    [_WA_Sys_00000003_3BFFE745] has been updated...
    [_WA_Sys_00000009_3BFFE745] has been updated...
    [_WA_Sys_00000005_3BFFE745] has been updated...
    [_WA_Sys_0000000C_3BFFE745] has been updated...
    [_WA_Sys_0000000E_3BFFE745] has been updated...
    [_WA_Sys_0000000A_3BFFE745] has been updated...
    8 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbRequestedTargetGroupsForTarget]
    [PK__tbReques__EFB381C179E466FA], update is not necessary...
    [nc1RequestedTargetGroupNamesForTarget], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbGroupAuthorization]
    [PK__tbGroupA__CD594A3193A4ADDD] has been updated...
    1 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbDeletedComputer]
    [cDeletedComputer], update is not necessary...
    [_WA_Sys_00000002_3F466844], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbAuthorization]
    [PK__tbAuthor__7C10E5016D25CFAB] has been updated...
    1 index(es)/statistic(s) have been updated, 0 did not require update.

 
Updating [dbo].[tbFileDownloadProgress]
    [c0FileDownloadProgress] has been updated...
    [PK__tbFileDo__FFEE7450BCA89139] has been updated...
    2 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbSingletonData]
    [PK__tbSingle__3214EC270FE779F9] has been updated...
    [_WA_Sys_00000004_498EEC8D], update is not necessary...
    1 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbInventoryRule]
    [PK__tbInvent__110458C234910392] has been updated...
    1 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbInventoryClass]
    [PK__tbInvent__CB1927A04F7A1A51] has been updated...
    [UQ__tbInvent__737584F64ECCC7C5] has been updated...
    2 index(es)/statistic(s) have been updated, 0 did not require update.
 

Updating [dbo].[tbNotificationEvent]
    [PK__tbNotifi__2BA9DFBC8A849DB6], update is not necessary...
    [_WA_Sys_00000004_725BF7F6], update is not necessary...
    [_WA_Sys_00000003_725BF7F6] has been updated...
    [_WA_Sys_00000002_725BF7F6], update is not necessary...
    1 index(es)/statistic(s) have been updated, 3 did not require update.
 
Updating [dbo].[tbDeadDeployment]
    [PK__tbDeadDe__5EF8D7176C4708F2], update is not necessary...
    [nc1DeadDeployment] has been updated...
    [nc2DeadDeployment] has been updated...
    [nc3DeadDeployment] has been updated...
    [_WA_Sys_00000012_72C60C4A] has been updated...
    [_WA_Sys_0000000F_72C60C4A] has been updated...
    [_WA_Sys_0000000D_72C60C4A] has been updated...
    [_WA_Sys_0000000C_72C60C4A] has been updated...
    7 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbChangeTracking]
    [c0ChangeTracking] has been updated...
    [PK__tbChange__DD60B210B23F024B] has been updated...
    2 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [dbo].[tbDynamicCategory]
    [PK_DynamicCategory], update is not necessary...
    [Unique_DynamicCategory_Name_Type], update is not necessary...
    [IX_dbDynamicInventoryItem_Name], update is not necessary...
    0 index(es)/statistic(s) have been updated, 3 did not require update.
 
Updating [dbo].[tbFlattenedRevisionInCategory]
    [PK__tbFlatte__15217053010D33F8], update is not necessary...
    [nc1FlattenedRevisionInCategory], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [sys].[queue_messages_1977058079]
    [queue_clustered_index], update is not necessary...
    [queue_secondary_index], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbServerSyncResult]
    [PK__tbServer__54173E1BDBF94E93], update is not necessary...
    [nc1ServerSyncResult], update is not necessary...
    [nc2tbServerSyncResult], update is not necessary...
    0 index(es)/statistic(s) have been updated, 3 did not require update.
 
Updating [dbo].[tbEventMessageTemplate]
    [PK__tbEventM__24626EC3227301B2], update is not necessary...
    [_WA_Sys_00000003_7869D707] has been updated...
    [_WA_Sys_00000002_7869D707] has been updated...
    2 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [sys].[queue_messages_2009058193]
    [queue_clustered_index], update is not necessary...
    [queue_secondary_index], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update. 

 
Updating [dbo].[tbRevisionLanguage]
    [PK__tbRevisi__1F2266A96B0AB904] has been updated...
    [nc1RevisionLanguage], update is not necessary...
    [_WA_Sys_00000003_7A672E12] has been updated...
    2 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [sys].[queue_messages_2041058307]
    [queue_clustered_index], update is not necessary...
    [queue_secondary_index], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbConfigurationB]
    [PK__tbConfig__95AA539B4EB6810C] has been updated...
    [_WA_Sys_00000003_7B264821] has been updated...
    [_WA_Sys_00000002_7B264821] has been updated...
    3 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [sys].[filestream_tombstone_2073058421]
    [FSTSClusIdx], update is not necessary...
    [FSTSNCIdx], update is not necessary...
    0 index(es)/statistic(s) have been updated, 2 did not require update.
 
Updating [dbo].[tbPrecomputedCategoryLocalizedProperty]
    [PK__tbPrecom__2DD8E6FD6241149C], update is not necessary...
    [_WA_Sys_00000002_7BE56230] has been updated...
    1 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [sys].[syscommittab]
    [ci_commit_ts], update is not necessary...
    [si_xdes_id], update is not necessary...
    [si_commit_time_ts], update is not necessary...
    0 index(es)/statistic(s) have been updated, 3 did not require update.
 
Updating [dbo].[tbEvent]
    [PK__tbEvent__24626EC3ACD99138] has been updated...
    [_WA_Sys_00000002_7D2E8C24] has been updated...
    [_WA_Sys_00000004_7D2E8C24], update is not necessary...
    2 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbProperty]
    [PK__tbProper__B4B1E3F1ED122F5D] has been updated...
    [nc1Property] has been updated...
    [nc2Property] has been updated...
    [_WA_Sys_00000005_7D439ABD] has been updated...
    [_WA_Sys_00000006_7D439ABD] has been updated...
    [_WA_Sys_0000000B_7D439ABD] has been updated...
    [_WA_Sys_00000013_7D439ABD] has been updated...
    [_WA_Sys_00000015_7D439ABD] has been updated...
    [_WA_Sys_00000012_7D439ABD] has been updated...
    [_WA_Sys_00000004_7D439ABD] has been updated...
    [_WA_Sys_00000003_7D439ABD] has been updated...
    [_WA_Sys_00000002_7D439ABD] has been updated...
    12 index(es)/statistic(s) have been updated, 0 did not require update.
 
Updating [sys].[filetable_updates_2105058535]
    [FFtUpdateIdx], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbMapping_Target_DynamicCategory]
    [PK__tbMappin__90B4D91DA5AA9E72], update is not necessary...
    0 index(es)/statistic(s) have been updated, 1 did not require update.
 
Updating [dbo].[tbAutoDeploymentRule]
    [PK__tbAutoDe__3214EC27AF232B5C], update is not necessary...
    [_WA_Sys_00000002_7DCDAAA2] has been updated...
    [_WA_Sys_00000003_7DCDAAA2] has been updated...
    2 index(es)/statistic(s) have been updated, 1 did not require update.
 
Statistics for all tables have been updated.
Done updating statistics.2022-04-13 15:00:23.490

Completion time: 2022-04-13T15:00:23.5018971+05:30