Weboldal keresés

Gyorsan újraindexelheti a WSUS adatbázist T-SQL Script segítségével

Ebben a cikkben megmutatom, hogyan lehet újraindexelni a WSUS adatbázist T-SQL Script használatával. A WSUS-adatbázis újraindexelése javítja a WSUS- és WSUS-telepítések teljesítményét.

Ha önálló WSUS-kiszolgálóval rendelkezik, amelyet a frissítések telepítésére használnak, idővel az adatbázis teljesítménye romlik. Ez a probléma a WSUS-rendszergazdák számára ismert.

A WSUS-adatbázis teljesítményének javítása érdekében futtathat egy egyszerű T-SQL-parancsfájlt, amely egy WSUSDBMaintenance-szkript a WSUS-adatbázisok újraindexelésére és töredezettelbontására.

A nagy WSUS-telepítések teljesítménye idővel romlik, ha a WSUS-adatbázis nincs megfelelően karbantartva. Ezért további erőfeszítéseket kell tennie a WSUS-adatbázis karbantartása és újjáépítése érdekében.

A WSUS-adatbázis újraindexelésének két módja van a telepítés módjától függően.

  • Ha Windows belső adatbázist használ, akkor az sqlcmd segédprogramot kell használnia, amely letölthető a docs.microsoft.com SQLCMD oldaláról.
  • Ha a WSUS DB az SQL Serveren található, akkor az SQL Server Management Studio segítségével futtathatja a WSUSDBMaintenance parancsfájlt (T-SQL-parancsfájl) az adatbázisban.

Megjegyzés: Ne használjon WSUSDBMaintenance szkriptet WSUS 2.0 adatbázisokon, mivel az nem támogatott.

Mit csinál a WSUSDBMaintenance szkript?

Ez a WSUSDBMaintenance szkript alapvető karbantartási feladatokat végez a SUSDB-n:

  • Azonosítsa a töredezett indexeket, és töredezettségmentesítse őket.
  • Egyes táblázatoknál be van állítva egy kitöltési tényező a lapka teljesítményének javítása érdekében.
  • Frissíti az esetlegesen elavult táblázatstatisztikát.
  • Javítja a WSUS adatbázis teljesítményét.

Töltse le a WSUSDBMaintenance T-SQL parancsfájlt

A WSUSDBMaintenance T-SQL Script letölthető a Microsoft dokumentációjából. Másolhatja a szkriptet és futtathatja a SUSDB-n, vagy mentheti a szkriptet egy fájlba, és futtathatja SSMS-ben.

A WSUS-adatbázis újraindexelése

A WSUS adatbázis újraindexelése T-SQL Script használatával:

  • Indítsa el az SQL Server Management Studio programot.
  • Hitelesítési adataival csatlakozzon az adatbázismotorhoz.
  • Bontsa ki az Adatbázisok elemet, kattintson jobb gombbal a SUSDB-re, és válassza az Új lekérdezés lehetőséget.

A lekérdező ablakba illessze be a WSUSDBMaintenance parancsfájlt (T-SQL-szkript), majd kattintson a Végrehajtás gombra.

Várja meg, amíg a T-SQL Script fut. A szkript újraindexeli és töredezettségmentesíti a WSUS-adatbázist. A lekérdezés kimenetének következő sorai megerősítik, hogy a WSUS-adatbázis újraindexelése sikeresen befejeződött.

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

Az alábbi kimenet a WSUS-adatbázis karbantartási parancsfájlja. Ezt referenciaként adtam hozzá.

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

Kapcsolódó cikkek