33
SBS 2011 WSUS deinstallieren
Hallo zusammen,
eine Frage an die Experten.
Wir setzen bei uns einen SBS 2011 ein und so langsam geht unser Speicherplatz (1000 GB) zu nichte.
wir haben noch ca. 220 GB frei.
Der WSUS benötigt ca 350 GB.
Insgesamt haben wir 12 Client PCs im Einsatz.
Die WSUS-Bereinigung schlägt fehl (auch beim durchführen der Einzelschritte)
Meine Idee ist WSUS zu deinstallieren. Kann das jemand empfehlen und wie geht man vor.
eine Frage an die Experten.
Wir setzen bei uns einen SBS 2011 ein und so langsam geht unser Speicherplatz (1000 GB) zu nichte.
wir haben noch ca. 220 GB frei.
Der WSUS benötigt ca 350 GB.
Insgesamt haben wir 12 Client PCs im Einsatz.
Die WSUS-Bereinigung schlägt fehl (auch beim durchführen der Einzelschritte)
Meine Idee ist WSUS zu deinstallieren. Kann das jemand empfehlen und wie geht man vor.
Share on Facebook
Share on Twitter
Share on Reddit
Share on LinkedinPlease also mark the comments that contributed to the solution of the article
Content-Key: 335089
Url: https://administrator.de/contentid/335089
Printed on: April 19, 2024 at 15:04 o'clock
33 Comments
Latest comment
Hallo
WSUS auf einem SBS zu deinstallieren / deaktivieren kann ich nicht empfehlen. Der SBS will seine "Default" Rollen ausführen und inne haben, sonst wird er ganz schnell zu Zicke.
Im Net gibt es aber alternative Bereinigungs-Scripts:
https://www.wsus.de/de/Scripts/WSUS-Serverbereinigung-mit-Powershell-1
https://www.wsus.de/de/Scripts/WSUS-Serverbereinigung-mit-Powershell-2
Schon probiert??
Ansonsten kannst du den WSUS-Content auf eine andere Harddisk / Partition verschieben (dies akzeptiert der SBS
)
Gruss
WSUS auf einem SBS zu deinstallieren / deaktivieren kann ich nicht empfehlen. Der SBS will seine "Default" Rollen ausführen und inne haben, sonst wird er ganz schnell zu Zicke.
Im Net gibt es aber alternative Bereinigungs-Scripts:
https://www.wsus.de/de/Scripts/WSUS-Serverbereinigung-mit-Powershell-1
https://www.wsus.de/de/Scripts/WSUS-Serverbereinigung-mit-Powershell-2
Schon probiert??
Ansonsten kannst du den WSUS-Content auf eine andere Harddisk / Partition verschieben (dies akzeptiert der SBS
)Gruss
hallo...
und das bereinigen dauer sehr lange.....
WSUS zu deinstallieren... ist auf dem SBS2011 keine gute idee.
frank
Die WSUS-Bereinigung schlägt fehl (auch beim durchführen der Einzelschritte)
und was haben wir uns darunter vorzustellen- da gibbet bestimmt fehlermeldungen & ereignisprotokolle!und das bereinigen dauer sehr lange.....
WSUS zu deinstallieren... ist auf dem SBS2011 keine gute idee.
frank
Die Scripts habe ich ausprobiert haben aber nicht funktioniert. Vielleicht habe ich diese falsch angepasst.
Was muss denn an dieser Stelle eingegeben werden:
set wsus-server-01=Servername.Domain.xxx
set wsus-server-02=Servername.Domain.xxx
set wsus-server-03=Servername.Domain.xxx
set wsus-server-04=Servername.Domain.xxx
Meldung: Verbindungsfehler. Der Serverknoten muss zurückgestzt werden
Was muss denn an dieser Stelle eingegeben werden:
set wsus-server-01=Servername.Domain.xxx
set wsus-server-02=Servername.Domain.xxx
set wsus-server-03=Servername.Domain.xxx
set wsus-server-04=Servername.Domain.xxx
Meldung: Verbindungsfehler. Der Serverknoten muss zurückgestzt werden
Hallo Leute,
prinzipiell würde ich auch erstmal versuchen, den WSUS zu bereinigen.
Aber das nichts damit zu tun, dass man den WSUS nicht vom SBS runterbekommt und ihn bspw. auf einem Memberserver laufen lässt.
prinzipiell würde ich auch erstmal versuchen, den WSUS zu bereinigen.
Aber das nichts damit zu tun, dass man den WSUS nicht vom SBS runterbekommt und ihn bspw. auf einem Memberserver laufen lässt.
Mit einer Bereinigung kann ich auch sehr gut leben, wenn Sie dann funktionieren würde.
Zitat von @goscho:
Hallo Leute,
prinzipiell würde ich auch erstmal versuchen, den WSUS zu bereinigen.
Aber das nichts damit zu tun, dass man den WSUS nicht vom SBS runterbekommt und ihn bspw. auf einem Memberserver laufen lässt.
brauchst ja nur die deinstallation der WSUS-Rolle anschubsen Hallo Leute,
prinzipiell würde ich auch erstmal versuchen, den WSUS zu bereinigen.
Aber das nichts damit zu tun, dass man den WSUS nicht vom SBS runterbekommt und ihn bspw. auf einem Memberserver laufen lässt.
Frank
Hallo
Musste auch zuerst mal schauen, wie das Script bei mir aussieht.
Habe dir die 3 Dateien mal hochgeladen
WsusDBMaintenance.sql
http://s000.tinyupload.com/?file_id=09351801346365864355
WSUS-Serverbereinigung.cmd
http://s000.tinyupload.com/?file_id=01116927823647494566
WSUS-Serverbereinigung.ps1
http://s000.tinyupload.com/?file_id=10953931388651096634
Diese 3 Dateien herunterladen, und ins Verzeichnis vom WSUS kopieren
Dann in der CMD noch die Zeilen 2, 3 und 4 ggf anpassen, und das Script sollte laufen
(Läuft aber sicherlich einige Stunden)
Gruss
Musste auch zuerst mal schauen, wie das Script bei mir aussieht.
Habe dir die 3 Dateien mal hochgeladen
WsusDBMaintenance.sql
http://s000.tinyupload.com/?file_id=09351801346365864355
WSUS-Serverbereinigung.cmd
http://s000.tinyupload.com/?file_id=01116927823647494566
WSUS-Serverbereinigung.ps1
http://s000.tinyupload.com/?file_id=10953931388651096634
Diese 3 Dateien herunterladen, und ins Verzeichnis vom WSUS kopieren
Dann in der CMD noch die Zeilen 2, 3 und 4 ggf anpassen, und das Script sollte laufen
(Läuft aber sicherlich einige Stunden)
Gruss
Mit der Deinstallation der Rolle zerschiesst du dir mit einiger Sicherheit das Selfmonitoring, da das den Update-Status mit abgreift. Von der zwangsläufigen Folge der manuellen Überwachung der Clients reden wir gar nicht erst.
Stell den WSUS auf "Updates von MS herunterladen" um, den Rest tunlichst in den Standard-Settings des SBS belassen, dann mit den hier genannten Scripten aufräumen. Damit hat die WSUS Datenbank maximal noch 7, vielleicht 8GB.
Stell den WSUS auf "Updates von MS herunterladen" um, den Rest tunlichst in den Standard-Settings des SBS belassen, dann mit den hier genannten Scripten aufräumen. Damit hat die WSUS Datenbank maximal noch 7, vielleicht 8GB.
Moin,
?
LG, Thomas
wir haben noch ca. 220 GB frei
wenn der SBS als SBS genutzt wird, sollte das doch bis zum EOL reichen ?und so langsam geht unser Speicherplatz (1000 GB) zu nichte.
Simple Lösung? Noch eine Platte in die Kiste stecken und den WSUS-Content darauf schieben und freuen.LG, Thomas
Danke probiere es aus und gebe Rückmeldung
Habe das Script mal laufen lassen, nach ausführen von WSUS-Serverbereinigung.cmd kommt folgende Fehlermeldung:
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occured while
establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if
SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
hatte das script angepasst.
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occured while
establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if
SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
hatte das script angepasst.
Aldder ...,
warum hängst Du nicht einfach noch 'ne Platte in die Kiste und jut is??
LG, Thomas
warum hängst Du nicht einfach noch 'ne Platte in die Kiste und jut is??
LG, Thomas
Hallo
Stimmt der Name des SQL Servers / der Instanz?
Kannst du dich mit dem SQL Server Management Studio mit der Instanz verbinden?
Wird da etwas mit der Firewall blockiert?
Gruss
Server is not found or not accessible. Check if instance name is correct and if
SQL Server is configured to allow remote connections.
Sagt doch eigentlich alles aus??SQL Server is configured to allow remote connections.
Stimmt der Name des SQL Servers / der Instanz?
Kannst du dich mit dem SQL Server Management Studio mit der Instanz verbinden?
Wird da etwas mit der Firewall blockiert?
Gruss
Kannst du mir ungefähr sagen wie lange die Scripts laufen?
Das WSUS-Serverbereinigung.cmd läuft bereits seit > 6 Stunden in der CMD (Bild nur schwarz)
Ist das so korrekt?
Das WSUS-Serverbereinigung.cmd läuft bereits seit > 6 Stunden in der CMD (Bild nur schwarz)
Ist das so korrekt?
Hallo Moelle
Ja, ist korrekt. Bei mir läuft das Script jeweils ca 15 Std (ungefähr 1x pro Monat)
Fortschritt kannst du in der Log Datei beobachten
Gruss
Ja, ist korrekt. Bei mir läuft das Script jeweils ca 15 Std (ungefähr 1x pro Monat)
Fortschritt kannst du in der Log Datei beobachten
Gruss
Danke für die Antwort aber die Logdatei ist gesperrt (WSUS-CleanUp.log)
Guten Morgen jetzt läuft das Script schon 24 Stunden und es ist unverändert.
WSUS-Serverbereinigung.cmd
WSUS-Serverbereinigung.cmd
Hallo
Wie geschrieben, der Task läuft sehr lange
Siehst du auch hier im Auszug von meinem Log (läuft ~ 1 x pro Monat, und dauert trotzdem noch > 12 Std
Wenn du aber das Gefühl hast, da stimmt was nicht. kannst du mal in die WSUS-Cleanup.log schauen (Datei kann mit einem Viewer, zB mit dem im Totalcommander integrierten Viewer, angesehen werden, auch wenn die Datei geöffnet ist).
Ansonsten halt den Prozess im Taskmanager abwürgen, und die LOG anschauen
Wurde die Dateibereinigung abgeschlossen?
Nach der Dateibereinigung iwrd noch eine Bereinigung der SQL-DB durgeführt
Wurde diese angefangen?
Gruss
Wie geschrieben, der Task läuft sehr lange
Siehst du auch hier im Auszug von meinem Log (läuft ~ 1 x pro Monat, und dauert trotzdem noch > 12 Std
Wenn du aber das Gefühl hast, da stimmt was nicht. kannst du mal in die WSUS-Cleanup.log schauen (Datei kann mit einem Viewer, zB mit dem im Totalcommander integrierten Viewer, angesehen werden, auch wenn die Datei geöffnet ist).
Ansonsten halt den Prozess im Taskmanager abwürgen, und die LOG anschauen
Wurde die Dateibereinigung abgeschlossen?
Nach der Dateibereinigung iwrd noch eine Bereinigung der SQL-DB durgeführt
Wurde diese angefangen?
Gruss
Moin,
ich hatte schon einen SBS2011 der brauchste 3 tage für die bereinigung...
also... warten
Frank
ich hatte schon einen SBS2011 der brauchste 3 tage für die bereinigung...
also... warten
Frank
Der Log ist unverändert da hat sich nichts aktualisiert!
Hallo
Heisst dein WSUS Server wirklich SERVER
Gruss
Heisst dein WSUS Server wirklich SERVER
Gruss
JA heisst der
Hallo
Der Pfad zum WSUS Verzeichnis stimmt auch?
Der Pfad zum SQL Server SQLCMD="%ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\sqlcmd.exe" stimmt auch?
Gruss
Der Pfad zum WSUS Verzeichnis stimmt auch?
Der Pfad zum SQL Server SQLCMD="%ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\sqlcmd.exe" stimmt auch?
Gruss
Ja passt auch!
Hallo
Ok, dann mache mal das @echo off am Anfang weg, und schaue, ob irgendein Fehler angezeigt wird
Gruss
Ok, dann mache mal das @echo off am Anfang weg, und schaue, ob irgendein Fehler angezeigt wird
Gruss
Ich habe das Script abgebrochen und dann geändert?
Jetzt sieht es so aus
Jetzt sieht es so aus
Hallo
Sieht bei mir exakt genauso aus (ausser, dass ich die WSUS auf dem Laufwerk F: beheimatet habe.
Wie gross ist denn bei dir die SUSDB.mdf?? (Bei mir aktuell ~ 7GB)
Wie gross ist der WSUScontent?? (bei mir aktuell ~ 36.1 GB)
Lass doch die Bereinigung mal über's WE laufen
Gruss
Sieht bei mir exakt genauso aus (ausser, dass ich die WSUS auf dem Laufwerk F: beheimatet habe.
Wie gross ist denn bei dir die SUSDB.mdf?? (Bei mir aktuell ~ 7GB)
Wie gross ist der WSUScontent?? (bei mir aktuell ~ 36.1 GB)
Lass doch die Bereinigung mal über's WE laufen
Gruss
WSUSContent Ordner 364 GB und SUSDB.mdf 14.65 GB
Den Serverneustart habe ich mal deaktiviert.
Den Serverneustart habe ich mal deaktiviert.
Das Script WSUS-Serverbereinigung.cmd ist durchgelaufen.
Muss als nächstes dann "WSUS-Serverbereinigung.ps1" über die Powershell gestartet werden?
Muss als nächstes dann "WSUS-Serverbereinigung.ps1" über die Powershell gestartet werden?
Hallo
Freut mich, das es nun klappt.
Nein, über das CMD File wird zuerst das WSUS-Serverbereinigung.ps1 ausgeführt.
Danach wird noch eine SQL Datenbank-Wartung WsusDBMaintenance.sql durchgeführt.
Gruss
Freut mich, das es nun klappt.
Nein, über das CMD File wird zuerst das WSUS-Serverbereinigung.ps1 ausgeführt.
Danach wird noch eine SQL Datenbank-Wartung WsusDBMaintenance.sql durchgeführt.
Gruss
Danke für deine Antwort,
hier mal das Logfile.
Cleanup Report für [SERVER] (Port: 8530)
Start der Datenbankbereinigung: 20.04.2017 um 15:38:26,63 Uhr
Cleanup Report für [SERVER] (Port: 8530)
Ausnahme beim Aufrufen von "PerformCleanup" mit 1 Argument(en): "Timeout ist a
bgelaufen. Das Zeitlimit wurde vor dem Beenden des Vorgangs berschritten oder
der Server reagiert nicht.
The statement has been terminated."
Bei C:\WSUS\WSUS-Serverbereinigung.ps1:37 Zeichen:31
+ CategoryInfo : NotSpecified: ( , MethodInvocationException
+ FullyQualifiedErrorId : DotNetMethodException
Ende Dateibereinigung: 20.04.2017 um 20:11:40,71 Uhr
SQL Server Wartung (Connect np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query)
Changed database context to 'SUSDB'.
Estimating fragmentation: Begin. 2017-04-20 20:11:52.143
Number of indexes to rebuild: 74
Estimating fragmentation: End. 2017-04-20 20:13:15.370
2017-04-20 20:13:15.430 Executing: ALTER INDEX [PK__tbBundleDependen__023D5A04] ON [dbo].[tbBundleDependency] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:18.177 Done.
2017-04-20 20:13:18.177 Executing: ALTER INDEX [nc1BundleDependency] ON [dbo].[tbBundleDependency] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:19.377 Done.
2017-04-20 20:13:19.377 Executing: ALTER INDEX [tbEulaProperty_PK] ON [dbo].[tbEulaProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:19.643 Done.
2017-04-20 20:13:19.643 Executing: ALTER INDEX [nc1EulaProperty] ON [dbo].[tbEulaProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:19.767 Done.
2017-04-20 20:13:19.767 Executing: ALTER INDEX [nc2EulaProperty] ON [dbo].[tbEulaProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:20.000 Done.
2017-04-20 20:13:20.000 Executing: ALTER INDEX [cUpdateStatusPerComputer] ON [dbo].[tbUpdateStatusPerComputer] REBUILD
2017-04-20 20:13:20.203 Done.
2017-04-20 20:13:20.203 Executing: ALTER INDEX [nc3UpdateStatusPerComputer] ON [dbo].[tbUpdateStatusPerComputer] REBUILD
2017-04-20 20:13:20.283 Done.
2017-04-20 20:13:20.283 Executing: ALTER INDEX [nc2UpdateStatusPerComputer] ON [dbo].[tbUpdateStatusPerComputer] REBUILD
2017-04-20 20:13:20.483 Done.
2017-04-20 20:13:20.483 Executing: ALTER INDEX [PK__tbUpdateSummaryF__060DEAE8] ON [dbo].[tbUpdateSummaryForAllComputers] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:20.673 Done.
2017-04-20 20:13:20.673 Executing: ALTER INDEX [PK__tbRevisionInCate__078C1F06] ON [dbo].[tbRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:24.650 Done.
2017-04-20 20:13:24.650 Executing: ALTER INDEX [nc1RevisionInCategory] ON [dbo].[tbRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:26.693 Done.
2017-04-20 20:13:26.693 Executing: ALTER INDEX [PK__tbFile__0A9D95DB] ON [dbo].[tbFile] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:14:23.040 Done.
2017-04-20 20:14:23.040 Executing: ALTER INDEX [nc1tbXml] ON [dbo].[tbXml] REORGANIZE
2017-04-20 20:14:47.923 Done.
2017-04-20 20:14:47.923 Executing: ALTER INDEX [nc2tbXml] ON [dbo].[tbXml] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:14:57.750 Done.
2017-04-20 20:14:57.780 Executing: ALTER INDEX [PK__tbRevision__17C286CF] ON [dbo].[tbRevision] REORGANIZE
2017-04-20 20:14:59.263 Done.
2017-04-20 20:14:59.263 Executing: ALTER INDEX [UQ__tbRevision__0E391C95] ON [dbo].[tbRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:01.073 Done.
2017-04-20 20:15:01.073 Executing: ALTER INDEX [ncRevision_LocalUpdateID_RevisionNumber__IsLatestRevision] ON [dbo].[tbRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:01.947 Done.
2017-04-20 20:15:01.947 Executing: ALTER INDEX [c0FileOnServer] ON [dbo].[tbFileOnServer] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:07.450 Done.
2017-04-20 20:15:07.450 Executing: ALTER INDEX [PK__tbFileOnServer__2CA8951C] ON [dbo].[tbFileOnServer] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:11.007 Done.
2017-04-20 20:15:11.007 Executing: ALTER INDEX [c0FileDownloadProgress] ON [dbo].[tbFileDownloadProgress] REBUILD
2017-04-20 20:15:11.130 Done.
2017-04-20 20:15:11.130 Executing: ALTER INDEX [PK__tbUpdate__2704CA5F] ON [dbo].[tbUpdate] REORGANIZE
2017-04-20 20:15:25.790 Done.
2017-04-20 20:15:25.790 Executing: ALTER INDEX [UQ__tbUpdate__27F8EE98] ON [dbo].[tbUpdate] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:26.850 Done.
2017-04-20 20:15:26.850 Executing: ALTER INDEX [nc1UpdateIsLocallyPublished] ON [dbo].[tbUpdate] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:27.240 Done.
2017-04-20 20:15:27.240 Executing: ALTER INDEX [PK__tbEventInstance__2C3E80C8] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:27.413 Done.
2017-04-20 20:15:27.413 Executing: ALTER INDEX [PK__tbEventInstance__2C3E80C8] ON [dbo].[tbEventInstance] REORGANIZE
2017-04-20 20:15:28.630 Done.
2017-04-20 20:15:28.630 Executing: ALTER INDEX [nc3EventInstanceConstraint] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:28.723 Done.
2017-04-20 20:15:28.723 Executing: ALTER INDEX [nc2EventInstance] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:28.753 Done.
2017-04-20 20:15:28.753 Executing: ALTER INDEX [nc4EventInstance] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:28.817 Done.
2017-04-20 20:15:28.817 Executing: ALTER INDEX [ncEventInstance_ComputerID_EventNamespaceID_EventID] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:28.880 Done.
2017-04-20 20:15:28.880 Executing: ALTER INDEX [nc_EventNamespaceID_EventID] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:28.927 Done.
2017-04-20 20:15:28.943 Executing: ALTER INDEX [c_RevisionID] ON [dbo].[ivwApiUpdateRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:29.393 Done.
2017-04-20 20:15:29.393 Executing: ALTER INDEX [nc_LocalUpdateID] ON [dbo].[ivwApiUpdateRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:29.660 Done.
2017-04-20 20:15:29.660 Executing: ALTER INDEX [nc_EffectiveArrivalTime] ON [dbo].[ivwApiUpdateRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:29.800 Done.
2017-04-20 20:15:29.817 Executing: ALTER INDEX [c0DeploymentRevision] ON [dbo].[tbDeployment] REORGANIZE
2017-04-20 20:15:41.047 Done.
2017-04-20 20:15:41.047 Executing: ALTER INDEX [PK__tbDeployment__48CFD27E] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:43.013 Done.
2017-04-20 20:15:43.013 Executing: ALTER INDEX [nc2DeploymentRevision] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:50.267 Done.
2017-04-20 20:15:50.267 Executing: ALTER INDEX [nc5DeploymentRevision] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:52.093 Done.
2017-04-20 20:15:52.093 Executing: ALTER INDEX [nc6DeploymentRevision] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:56.210 Done.
2017-04-20 20:15:56.210 Executing: ALTER INDEX [nc_RevisionID_TargetGroupID_ActionID] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:00.860 Done.
2017-04-20 20:16:00.860 Executing: ALTER INDEX [PK__tbFlattenedRevis__4865BE2A] ON [dbo].[tbFlattenedRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:01.733 Done.
2017-04-20 20:16:01.733 Executing: ALTER INDEX [nc1FlattenedRevisionInCategory] ON [dbo].[tbFlattenedRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:02.060 Done.
2017-04-20 20:16:02.077 Executing: ALTER INDEX [PK__tbDeadDeployment__4AB81AF0] ON [dbo].[tbDeadDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:11.793 Done.
2017-04-20 20:16:11.793 Executing: ALTER INDEX [nc1DeadDeployment] ON [dbo].[tbDeadDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:12.527 Done.
2017-04-20 20:16:12.527 Executing: ALTER INDEX [nc2DeadDeployment] ON [dbo].[tbDeadDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:13.463 Done.
2017-04-20 20:16:13.463 Executing: ALTER INDEX [nc3DeadDeployment] ON [dbo].[tbDeadDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:14.383 Done.
2017-04-20 20:16:14.383 Executing: ALTER INDEX [nc1PreComputedLocalizedProperty] ON [dbo].[tbPreComputedLocalizedProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:48.047 Done.
2017-04-20 20:16:48.047 Executing: ALTER INDEX [ncPreComputedLocalizedProperty_RevisionID_ShortLanguage] ON [dbo].[tbPreComputedLocalizedProperty] REORGANIZE
2017-04-20 20:17:07.877 Done.
2017-04-20 20:17:07.877 Executing: ALTER INDEX [PK__tbPrecomputedCat__4E1E9780] ON [dbo].[tbPrecomputedCategoryLocalizedProperty] REBUILD
2017-04-20 20:17:08.000 Done.
2017-04-20 20:17:08.000 Executing: ALTER INDEX [PK__tbRevisionLangua__5165187F] ON [dbo].[tbRevisionLanguage] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:13.180 Done.
2017-04-20 20:17:13.180 Executing: ALTER INDEX [nc1RevisionLanguage] ON [dbo].[tbRevisionLanguage] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:17.703 Done.
2017-04-20 20:17:17.703 Executing: ALTER INDEX [nc1Property] ON [dbo].[tbProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:19.030 Done.
2017-04-20 20:17:19.047 Executing: ALTER INDEX [nc2Property] ON [dbo].[tbProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:20.043 Done.
2017-04-20 20:17:20.043 Executing: ALTER INDEX [PK__tbKBArticleForRe__59FA5E80] ON [dbo].[tbKBArticleForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:20.310 Done.
2017-04-20 20:17:20.310 Executing: ALTER INDEX [nc1KBArticleForRevision] ON [dbo].[tbKBArticleForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:20.573 Done.
2017-04-20 20:17:20.573 Executing: ALTER INDEX [tbKBArticleForRevision_RevisionID_AK] ON [dbo].[tbKBArticleForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:20.713 Done.
2017-04-20 20:17:20.713 Executing: ALTER INDEX [nc_RevisionID_ShortLanguage] ON [dbo].[tbMoreInfoURLForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:26.143 Done.
2017-04-20 20:17:26.143 Executing: ALTER INDEX [PK__tbSecurityBullet__5EBF139D] ON [dbo].[tbSecurityBulletinForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:26.300 Done.
2017-04-20 20:17:26.300 Executing: ALTER INDEX [nc1SecurityBulletinForRevision] ON [dbo].[tbSecurityBulletinForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:26.500 Done.
2017-04-20 20:17:26.500 Executing: ALTER INDEX [tbSecurityBulletinForRevision_RevisionID_AK] ON [dbo].[tbSecurityBulletinForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:26.640 Done.
2017-04-20 20:17:26.640 Executing: ALTER INDEX [PK__tbLocalizedPrope__60A75C0F] ON [dbo].[tbLocalizedPropertyForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:30.480 Done.
2017-04-20 20:17:30.480 Executing: ALTER INDEX [PK__tbFileForRevisio__28D80438] ON [dbo].[tbFileForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:32.570 Done.
2017-04-20 20:17:32.570 Executing: ALTER INDEX [nc1FileForRevision] ON [dbo].[tbFileForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:34.193 Done.
2017-04-20 20:17:34.193 Executing: ALTER INDEX [PK__tbRevisionSupers__656C112C] ON [dbo].[tbRevisionSupersedesUpdate] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:35.330 Done.
2017-04-20 20:17:35.330 Executing: ALTER INDEX [PK__tbInstalledUpdat__6754599E] ON [dbo].[tbInstalledUpdateSufficientForPrerequisite] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:40.150 Done.
2017-04-20 20:17:40.150 Executing: ALTER INDEX [nc1InstalledUpdateSufficientForPrerequisite] ON [dbo].[tbInstalledUpdateSufficientForPrerequisite] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:42.850 Done.
2017-04-20 20:17:42.867 Executing: ALTER INDEX [tbBundleAtLeastOne_PK] ON [dbo].[tbBundleAtLeastOne] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:44.067 Done.
2017-04-20 20:17:44.067 Executing: ALTER INDEX [nc1BundleAtLeastOne] ON [dbo].[tbBundleAtLeastOne] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:44.643 Done.
2017-04-20 20:17:44.643 Executing: ALTER INDEX [tbBundleAll_PK] ON [dbo].[tbBundleAll] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:44.957 Done.
2017-04-20 20:17:44.957 Executing: ALTER INDEX [nc1BundleAll] ON [dbo].[tbBundleAll] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:45.097 Done.
2017-04-20 20:17:45.097 Executing: ALTER INDEX [PK__tbPrerequisite__6D0D32F4] ON [dbo].[tbPrerequisite] REORGANIZE
2017-04-20 20:18:13.130 Done.
2017-04-20 20:18:13.130 Executing: ALTER INDEX [nc1Prerequisite] ON [dbo].[tbPrerequisite] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:18:15.190 Done.
2017-04-20 20:18:15.190 Executing: ALTER INDEX [PK__tbPrerequisiteDe__00551192] ON [dbo].[tbPrerequisiteDependency] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:18:28.743 Done.
2017-04-20 20:18:28.743 Executing: ALTER INDEX [nc1PrerequisiteDependency] ON [dbo].[tbPrerequisiteDependency] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:18:39.570 Done.
2017-04-20 20:18:39.570 Executing: ALTER INDEX [nc2PrerequisiteDependency] ON [dbo].[tbPrerequisiteDependency] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:18:50.320 Done.
Estimated number of pages in fragmented indexes: 251283
Estimated number of pages freed: 96611
Updating all statistics.2017-04-20 20:18:50.583
Updating [dbo].[tbTargetInTargetGroup]
[PK__tbTargetInTarget__01142BA1] has been updated...
[nc1TargetInTargetGroup] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbSchedule]
[PK__tbSchedule__03BB8E22], update is not necessary...
[_WA_Sys_00000002_00DF2177], update is not necessary...
[_WA_Sys_00000006_00DF2177] has been updated...
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbBundleDependency]
[PK__tbBundleDependen__023D5A04], update is not necessary...
[nc1BundleDependency], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbInventoryClassInstance]
[PK__tbInventoryClass__02B25B50], update is not necessary...
[nc_TargetID_ClassID_KeyValue], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 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].[tbUpdateStatusPerComputer]
[cUpdateStatusPerComputer], update is not necessary...
[nc3UpdateStatusPerComputer], update is not necessary...
[nc2UpdateStatusPerComputer], update is not necessary...
[_WA_Sys_00000005_03317E3D] has been updated...
1 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbInventoryPropertyInstance]
[PK__tbInventoryPrope__049AA3C2], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbEulaAcceptance]
[PK__tbEulaAcceptance__04E4BC85] has been updated...
[_WA_Sys_00000002_03F0984C] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbEmailNotificationRecipient]
[_WA_Sys_00000002_04AFB25B], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbUpdateSummaryForAllComputers]
[PK__tbUpdateSummaryF__060DEAE8], update is not necessary...
[_WA_Sys_00000002_0519C6AF] has been updated...
[_WA_Sys_00000003_0519C6AF] has been updated...
[_WA_Sys_00000004_0519C6AF] has been updated...
[_WA_Sys_00000005_0519C6AF] has been updated...
[_WA_Sys_00000006_0519C6AF] has been updated...
[_WA_Sys_00000007_0519C6AF] has been updated...
6 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbRevisionInCategory]
[PK__tbRevisionInCate__078C1F06], update is not necessary...
[nc1RevisionInCategory], update is not necessary...
[_WA_Sys_00000003_05A3D694] has been updated...
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbLocalizedProperty]
[PK__tbLocalizedPrope__06CD04F7] has been updated...
[_WA_Sys_00000004_05D8E0BE] has been updated...
[_WA_Sys_00000002_05D8E0BE] has been updated...
[_WA_Sys_00000003_05D8E0BE] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbFile]
[PK__tbFile__0A9D95DB], update is not necessary...
[_WA_Sys_00000005_07C12930] has been updated...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbCategory]
[PK__tbCategory__0C50D423] has been updated...
[nc1Category] has been updated...
[_WA_Sys_00000003_0880433F] has been updated...
[_WA_Sys_00000001_0880433F] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbXml]
[PK__tbXml__0E6E26BF] has been updated...
[nc1tbXml] has been updated...
[nc2tbXml], update is not necessary...
[_WA_Sys_00000004_0B91BA14] has been updated...
3 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbComputerSummaryForMicrosoftUpdates]
[PK__tbComputerSummar__0DAF0CB0] has been updated...
[_WA_Sys_00000002_0CBAE877] has been updated...
[_WA_Sys_00000003_0CBAE877] has been updated...
[_WA_Sys_00000004_0CBAE877] has been updated...
[_WA_Sys_00000006_0CBAE877] has been updated...
[_WA_Sys_00000007_0CBAE877] has been updated...
[_WA_Sys_00000005_0CBAE877] has been updated...
7 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevision]
[PK__tbRevision__17C286CF] has been updated...
[UQ__tbRevision__0E391C95], update is not necessary...
[ncRevision_LocalUpdateID_RevisionNumber__IsLatestRevision], update is not necessary...
[_WA_Sys_0000000D_0D44F85C] has been updated...
[_WA_Sys_00000003_0D44F85C] has been updated...
[_WA_Sys_00000009_0D44F85C] has been updated...
[_WA_Sys_00000005_0D44F85C] has been updated...
[_WA_Sys_0000000C_0D44F85C] has been updated...
[_WA_Sys_0000000A_0D44F85C] has been updated...
[_WA_Sys_0000000E_0D44F85C] has been updated...
8 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbGroupAuthorization]
[PK__tbGroupAuthoriza__10566F31] has been updated...
[_WA_Sys_00000002_0F624AF8] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbAuthorization]
[PK__tbAuthorization__123EB7A3] has been updated...
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbFileOnServer]
[c0FileOnServer], update is not necessary...
[PK__tbFileOnServer__2CA8951C], update is not necessary...
[_WA_Sys_00000005_1332DBDC] has been updated...
[_WA_Sys_00000004_1332DBDC] has been updated...
[_WA_Sys_00000007_1332DBDC] has been updated...
[_WA_Sys_00000006_1332DBDC] has been updated...
4 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbRequestedTargetGroup]
[PK__tbRequestedTarge__15502E78], 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].[tbRequestedTargetGroupsForTarget]
[PK__tbRequestedTarge__173876EA], update is not necessary...
[nc1RequestedTargetGroupNamesForTarget], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbDeletedComputer]
[cDeletedComputer] has been updated...
[_WA_Sys_00000002_182C9B23] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevisionExtendedLanguageMask]
[PK__tbRevisionExtend__2057CCD0], update is not necessary...
[_WA_Sys_00000002_18B6AB08], update is not necessary...
[_WA_Sys_00000003_18B6AB08], update is not necessary...
[_WA_Sys_00000004_18B6AB08], update is not necessary...
[_WA_Sys_00000005_18B6AB08], update is not necessary...
[_WA_Sys_00000006_18B6AB08], update is not necessary...
[_WA_Sys_00000007_18B6AB08], update is not necessary...
[_WA_Sys_00000008_18B6AB08], update is not necessary...
0 index(es)/statistic(s) have been updated, 8 did not require update.
Updating [dbo].[tbFileDownloadProgress]
[c0FileDownloadProgress], update is not necessary...
[PK__tbFileDownloadPr__2D9CB955] has been updated...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbComputerTargetDetail]
[PK__tbComputerTarget__25869641] has been updated...
[_WA_Sys_00000019_1B0907CE] has been updated...
[_WA_Sys_00000018_1B0907CE] has been updated...
[_WA_Sys_00000002_1B0907CE] has been updated...
[_WA_Sys_00000003_1B0907CE] has been updated...
[_WA_Sys_00000004_1B0907CE] has been updated...
[_WA_Sys_00000005_1B0907CE] has been updated...
[_WA_Sys_00000006_1B0907CE] has been updated...
[_WA_Sys_00000007_1B0907CE] has been updated...
[_WA_Sys_0000000D_1B0907CE] has been updated...
[_WA_Sys_00000011_1B0907CE] has been updated...
[_WA_Sys_00000013_1B0907CE] has been updated...
[_WA_Sys_00000014_1B0907CE] has been updated...
[_WA_Sys_00000015_1B0907CE] has been updated...
[_WA_Sys_00000016_1B0907CE] has been updated...
[_WA_Sys_00000012_1B0907CE] has been updated...
16 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbReference]
[_WA_Sys_00000003_1F98B2C1] has been updated...
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbUpdate]
[PK__tbUpdate__2704CA5F] has been updated...
[UQ__tbUpdate__27F8EE98], update is not necessary...
[nc1UpdateIsLocallyPublished], update is not necessary...
[_WA_Sys_00000007_214BF109] has been updated...
[_WA_Sys_00000003_214BF109] has been updated...
[_WA_Sys_00000008_214BF109] has been updated...
[_WA_Sys_00000009_214BF109] has been updated...
[_WA_Sys_00000006_214BF109] has been updated...
[_WA_Sys_0000000A_214BF109] has been updated...
[_WA_Sys_0000000C_214BF109] has been updated...
8 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbFrontEndServersHealth]
[_WA_Sys_00000001_236943A5] has been updated...
[_WA_Sys_00000002_236943A5] has been updated...
[_WA_Sys_00000003_236943A5] has been updated...
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbConfigurationC]
[PK__tbConfigurationC__4B7734FF], update is not necessary...
[_WA_Sys_00000006_25518C17] has been updated...
[_WA_Sys_00000007_25518C17] has been updated...
[_WA_Sys_00000010_25518C17] has been updated...
[_WA_Sys_00000013_25518C17] has been updated...
4 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbComputerTarget]
[PK__tbComputerTarget__2A4B4B5E] has been updated...
[UQ__tbComputerTarget__276EDEB3] has been updated...
[nc1ComputerTarget] has been updated...
[nc4ComputerTarget] has been updated...
[nc5ComputerTarget] has been updated...
[nc_EffectiveLastDetectionTime] has been updated...
[ncComputerTarget_FullDomainName] has been updated...
[_WA_Sys_00000004_267ABA7A] has been updated...
[_WA_Sys_0000000E_267ABA7A] has been updated...
[_WA_Sys_00000006_267ABA7A] has been updated...
10 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbEventMessageTemplate]
[PK__tbEventMessageTe__2B4A5C8F] has been updated...
[_WA_Sys_00000002_2759D01A] has been updated...
[_WA_Sys_00000003_2759D01A] has been updated...
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbUpdateType]
[PK__tbUpdateType__29E1370A], update is not necessary...
[_WA_Sys_00000002_28ED12D1], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbEventInstance]
[PK__tbEventInstance__2C3E80C8], update is not necessary...
[nc3EventInstanceConstraint], update is not necessary...
[nc2EventInstance], update is not necessary...
[nc4EventInstance], update is not necessary...
[ncEventInstance_ComputerID_EventNamespaceID_EventID], update is not necessary...
[nc_EventNamespaceID_EventID], update is not necessary...
[_WA_Sys_0000000D_2942188C] has been updated...
[_WA_Sys_00000002_2942188C] has been updated...
[_WA_Sys_00000004_2942188C] has been updated...
[_WA_Sys_00000005_2942188C] has been updated...
4 index(es)/statistic(s) have been updated, 6 did not require update.
Updating [dbo].[tbUpdateFlag]
[PK__tbUpdateFlag__2BC97F7C], update is not necessary...
[_WA_Sys_00000002_2AD55B43], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbClientWithRecentNameChange]
[c0ClientWithRecentNameChange], update is not necessary...
[nc1ClientWithRecentNameChange], update is not necessary...
[nc2ClientWithRecentNameChange], update is not necessary...
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbEvent]
[PK__tbEvent__2E06CDA9] has been updated...
[_WA_Sys_00000002_2C1E8537] has been updated...
[_WA_Sys_00000004_2C1E8537] has been updated...
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDownstreamServerTarget]
[PK__tbDownstreamServ__2E1BDC42], update is not necessary...
[ncDownstreamServerTarget_AccountServerID], update is not necessary...
[_WA_Sys_00000003_2C3393D0], update is not necessary...
[_WA_Sys_00000008_2C3393D0], update is not necessary...
0 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbHandler]
[PK__tbHandler__2DB1C7EE], update is not necessary...
[_WA_Sys_00000002_2CBDA3B5], update is not necessary...
[_WA_Sys_00000003_2CBDA3B5], update is not necessary...
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbSingletonData]
[PK__tbSingletonData__32616E72] has been updated...
[_WA_Sys_00000004_2E90DD8E], update is not necessary...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbLanguage]
[PK__tbLanguage__336AA144], update is not necessary...
[nc1Language], update is not necessary...
[_WA_Sys_00000006_2EA5EC27] has been updated...
[_WA_Sys_00000008_2EA5EC27] has been updated...
2 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbEventSource]
[PK__tbEventSource__2FEF161B] has been updated...
[_WA_Sys_00000002_2EFAF1E2] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDownstreamServerSummaryRollup]
[PK__tbDownstreamServ__300424B4], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbEventNamespace]
[PK__tbEventNamespace__31D75E8D] has been updated...
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDownstreamServerClientSummaryRollup]
[PK__tbDownstreamServ__35BCFE0A] has been updated...
[_WA_Sys_00000001_30F848ED] has been updated...
[_WA_Sys_00000003_30F848ED] has been updated...
[_WA_Sys_00000004_30F848ED] has been updated...
[_WA_Sys_00000005_30F848ED] has been updated...
[_WA_Sys_00000006_30F848ED] has been updated...
[_WA_Sys_00000007_30F848ED] has been updated...
[_WA_Sys_00000008_30F848ED] has been updated...
[_WA_Sys_00000009_30F848ED] has been updated...
[_WA_Sys_0000000F_30F848ED] has been updated...
[_WA_Sys_0000000C_30F848ED] has been updated...
[_WA_Sys_0000000D_30F848ED] has been updated...
[_WA_Sys_0000000E_30F848ED] has been updated...
13 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbCategoryType]
[PK__tbCategoryType__3552E9B6], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbStateMachine]
[PK__tbStateMachine__373B3228] has been updated...
[nc1StateMachine] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDownstreamServerClientActivityRollup]
[PK__tbDownstreamServ__37A5467C] has been updated...
[_WA_Sys_00000002_36B12243] has been updated...
[_WA_Sys_00000003_36B12243] has been updated...
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbStateMachineState]
[PK__tbStateMachineSt__39237A9A] has been updated...
[nc1StateMachineState] has been updated...
[stateNameUniqueForStateMachineID] has been updated...
[_WA_Sys_00000002_382F5661] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbTarget]
[PK__tbTarget__3A81B327] has been updated...
[nc1Target] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbLocaleMap]
[PK__tbLocaleMap__3B60C8C7], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbStateMachineEvent]
[PK__tbStateMachineEv__3BFFE745] has been updated...
[nc1StateMachineEvent] has been updated...
[eventNameUniqueForStateMachineID] has been updated...
[_WA_Sys_00000002_3B0BC30C], update is not necessary...
3 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbTargetType]
[PK__tbTargetType__3C69FB99], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbOSMap]
[PK__tbOSMap__3D491139], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbDeployment]
[c0DeploymentRevision] has been updated...
[PK__tbDeployment__48CFD27E], update is not necessary...
[nc2DeploymentRevision], update is not necessary...
[nc5DeploymentRevision], update is not necessary...
[nc6DeploymentRevision], update is not necessary...
[nc_RevisionID_TargetGroupID_ActionID], update is not necessary...
[_WA_Sys_00000005_3D5E1FD2] has been updated...
[_WA_Sys_0000000F_3D5E1FD2] has been updated...
[_WA_Sys_00000008_3D5E1FD2] has been updated...
[_WA_Sys_00000002_3D5E1FD2] has been updated...
[_WA_Sys_00000011_3D5E1FD2] has been updated...
[_WA_Sys_00000010_3D5E1FD2] has been updated...
[_WA_Sys_00000004_3D5E1FD2] has been updated...
[_WA_Sys_0000000C_3D5E1FD2] has been updated...
[_WA_Sys_00000013_3D5E1FD2] has been updated...
[_WA_Sys_0000000A_3D5E1FD2] has been updated...
[_WA_Sys_00000006_3D5E1FD2] has been updated...
12 index(es)/statistic(s) have been updated, 5 did not require update.
Updating [dbo].[tbStateMachineTransition]
[PK__tbStateMachineTr__3EDC53F0] has been updated...
[_WA_Sys_00000002_3DE82FB7] has been updated...
[_WA_Sys_00000003_3DE82FB7] has been updated...
[_WA_Sys_00000004_3DE82FB7] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDownstreamServerRollupConfiguration]
[PK__tbDownstreamServ__34D3C6C9], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbStateMachineEventTransitionLog]
[PK__tbStateMachineEv__41B8C09B], update is not necessary...
[_WA_Sys_00000002_3FD07829], update is not necessary...
[_WA_Sys_00000003_3FD07829], update is not necessary...
[_WA_Sys_00000005_3FD07829], update is not necessary...
[_WA_Sys_00000006_3FD07829], update is not necessary...
[_WA_Sys_00000007_3FD07829], update is not necessary...
0 index(es)/statistic(s) have been updated, 6 did not require update.
Updating [dbo].[tbEventRollupCounters]
[PK__tbEventRollupCou__35C7EB02], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbNotificationEvent]
[PK__tbNotificationEv__44952D46] has been updated...
[_WA_Sys_00000004_43A1090D] has been updated...
[_WA_Sys_00000003_43A1090D] has been updated...
[_WA_Sys_00000002_43A1090D] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbChangeTracking]
[c0ChangeTracking], update is not necessary...
[PK__tbChangeTracking__467D75B8] has been updated...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbFlattenedRevisionInCategory]
[PK__tbFlattenedRevis__4865BE2A], update is not necessary...
[nc1FlattenedRevisionInCategory], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbServerSyncResult]
[PK__tbServerSyncResu__4A4E069C], 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].[tbDeadDeployment]
[PK__tbDeadDeployment__4AB81AF0], update is not necessary...
[nc1DeadDeployment], update is not necessary...
[nc2DeadDeployment], update is not necessary...
[nc3DeadDeployment], update is not necessary...
[_WA_Sys_0000000D_49C3F6B7] has been updated...
[_WA_Sys_0000000F_49C3F6B7] has been updated...
[_WA_Sys_00000012_49C3F6B7] has been updated...
[_WA_Sys_00000003_49C3F6B7] has been updated...
4 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbPreComputedLocalizedProperty]
[PK__tbPreComputedLoc__4C364F0E] has been updated...
[nc1PreComputedLocalizedProperty], update is not necessary...
[ncPreComputedLocalizedProperty_RevisionID_ShortLanguage] has been updated...
[_WA_Sys_00000002_4B422AD5] has been updated...
[_WA_Sys_00000003_4B422AD5] has been updated...
[_WA_Sys_00000004_4B422AD5] has been updated...
[_WA_Sys_00000005_4B422AD5] has been updated...
6 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbConfigurationB]
[PK__tbConfigurationB__6442E2C9], update is not necessary...
[_WA_Sys_00000003_4C6B5938] has been updated...
[_WA_Sys_00000002_4C6B5938] has been updated...
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbPrecomputedCategoryLocalizedProperty]
[PK__tbPrecomputedCat__4E1E9780], update is not necessary...
[_WA_Sys_00000002_4D2A7347] has been updated...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbAutoDeploymentRule]
[PK__tbAutoDeployment__51EF2864], update is not necessary...
[_WA_Sys_00000002_4F12BBB9] has been updated...
[_WA_Sys_00000003_4F12BBB9] has been updated...
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbRevisionLanguage]
[PK__tbRevisionLangua__5165187F], update is not necessary...
[nc1RevisionLanguage], update is not necessary...
[_WA_Sys_00000003_4F7CD00D] has been updated...
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbProperty]
[PK__tbProperty__5629CD9C] has been updated...
[nc1Property], update is not necessary...
[nc2Property], update is not necessary...
[_WA_Sys_00000005_52593CB8] has been updated...
[_WA_Sys_00000006_52593CB8] has been updated...
[_WA_Sys_0000000B_52593CB8] has been updated...
[_WA_Sys_00000013_52593CB8] has been updated...
[_WA_Sys_00000004_52593CB8] has been updated...
[_WA_Sys_00000002_52593CB8] has been updated...
[_WA_Sys_00000003_52593CB8] has been updated...
[_WA_Sys_00000012_52593CB8] has been updated...
[_WA_Sys_00000015_52593CB8] has been updated...
[_WA_Sys_00000009_52593CB8] has been updated...
[_WA_Sys_0000000E_52593CB8] has been updated...
12 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbUpdateClassificationInAutoDeploymentRule]
[PK__tbUpdateClassifi__53D770D6] has been updated...
[_WA_Sys_00000002_52E34C9D] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbCategoryInAutoDeploymentRule]
[PK__tbCategoryInAuto__55BFB948], update is not necessary...
[_WA_Sys_00000002_54CB950F], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbTargetGroupInAutoDeploymentRule]
[PK__tbTargetGroupInA__57A801BA] has been updated...
[_WA_Sys_00000002_56B3DD81] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevisionExtendedProperty]
[cRevisionExtendedProperty], update is not necessary...
[PK__tbRevisionExtend__5812160E], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbSchemaVersion]
[PK__tbSchemaVersion__5A846E65] has been updated...
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbKBArticleForRevision]
[PK__tbKBArticleForRe__59FA5E80], update is not necessary...
[nc1KBArticleForRevision], update is not necessary...
[tbKBArticleForRevision_RevisionID_AK], update is not necessary...
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbMoreInfoURLForRevision]
[PK__tbMoreInfoURLFor__5CD6CB2B] has been updated...
[nc_RevisionID_ShortLanguage], update is not necessary...
[_WA_Sys_00000004_5AEE82B9] has been updated...
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbSchemaVersionHistory]
[PK__tbSchemaVersionH__5C6CB6D7] has been updated...
[_WA_Sys_00000002_5B78929E], update is not necessary...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbSecurityBulletinForRevision]
[PK__tbSecurityBullet__5EBF139D], update is not necessary...
[nc1SecurityBulletinForRevision], update is not necessary...
[tbSecurityBulletinForRevision_RevisionID_AK], update is not necessary...
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbServerHealth]
[PK__tbServerHealth__61316BF4], update is not necessary...
[_WA_Sys_00000002_5F492382] has been updated...
[_WA_Sys_00000003_5F492382] has been updated...
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbLocalizedPropertyForRevision]
[PK__tbLocalizedPrope__60A75C0F], update is not necessary...
[_WA_Sys_00000002_5FB337D6] has been updated...
[_WA_Sys_00000003_5FB337D6] has been updated...
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbFileForRevision]
[PK__tbFileForRevisio__28D80438], update is not necessary...
[nc1FileForRevision], update is not necessary...
[_WA_Sys_00000003_619B8048] has been updated...
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbProgramKeys]
[PK__tbProgramKeys__6319B466], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbComputersThatNeedDetailedRollup]
[cComputersThatNeedDetailedRollup] has been updated...
[_WA_Sys_00000002_640DD89F] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevisionSupersedesUpdate]
[PK__tbRevisionSupers__656C112C], update is not necessary...
[_WA_Sys_00000002_6477ECF3] has been updated...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbConfigurationA]
[PK__tbConfigurationA__756D6ECB], update is not necessary...
[_WA_Sys_0000000E_65370702] has been updated...
[_WA_Sys_00000018_65370702] has been updated...
[_WA_Sys_0000000F_65370702] has been updated...
[_WA_Sys_00000004_65370702] has been updated...
4 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbInstalledUpdateSufficientForPrerequisite]
[PK__tbInstalledUpdat__6754599E], update is not necessary...
[nc1InstalledUpdateSufficientForPrerequisite], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbBundleAtLeastOne]
[tbBundleAtLeastOne_PK], update is not necessary...
[nc1BundleAtLeastOne], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbBundleAll]
[tbBundleAll_PK], update is not necessary...
[nc1BundleAll], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbPrerequisite]
[PK__tbPrerequisite__6D0D32F4] has been updated...
[nc1Prerequisite], update is not necessary...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbDriver]
[PK__tbDriver__29CC2871], update is not necessary...
[nc1Driver], update is not necessary...
[nc2Driver], update is not necessary...
[_WA_Sys_00000008_6E01572D], update is not necessary...
0 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbCompatiblePrinterProvider]
[PK__tbCompatiblePrin__70DDC3D8], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbDriverClass]
[PK__tbDriverClass__72C60C4A], update is not necessary...
[_WA_Sys_00000002_71D1E811], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbTargetGroup]
[PK__tbTargetGroup__778AC167] has been updated...
[_WA_Sys_00000007_73BA3083] has been updated...
[_WA_Sys_00000001_73BA3083] has been updated...
[_WA_Sys_00000002_73BA3083] has been updated...
[_WA_Sys_00000006_73BA3083], update is not necessary...
4 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbConfiguration]
[PK__tbConfiguration__7755B73D] has been updated...
[_WA_Sys_00000002_76619304] has been updated...
2 index(es)/statistic(s) have been updated, 0 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].[tbInventoryRule]
[PK__tbInventoryRule__7928F116] has been updated...
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbImplicitCategory]
[PK__tbImplicitCatego__7B264821] has been updated...
[_WA_Sys_00000002_7849DB76] has been updated...
[_WA_Sys_00000003_7849DB76] has been updated...
[_WA_Sys_00000004_7849DB76] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbFlattenedTargetGroup]
[cFlattenedTargetGroup] has been updated...
[_WA_Sys_00000002_787EE5A0], update is not necessary...
1 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].[tbInventoryClass]
[PK__tbInventoryClass__7B113988] has been updated...
[UQ__tbInventoryClass__7C055DC1] has been updated...
2 index(es)/statistic(s) have been updated, 0 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].[tbTargetGroupType]
[PK__tbTargetGroupTyp__7C4F7684], update is not necessary...
[_WA_Sys_00000002_7B5B524B], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbCategoryInSubscription]
[PK__tbCategoryInSubs__7D0E9093] has been updated...
[_WA_Sys_00000001_7C1A6C5A] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbInventoryProperty]
[PK__tbInventoryPrope__7DEDA633] has been updated...
[nc_ClassID_Name] has been updated...
[_WA_Sys_00000003_7CF981FA] has been updated...
[_WA_Sys_00000004_7CF981FA] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbExpandedTargetInTargetGroup]
[PK__tbExpandedTarget__7E37BEF6] has been updated...
[nc1ExpandedTargetInTargetGroup] has been updated...
[_WA_Sys_00000003_7D439ABD] has been updated...
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbLanguageInSubscription]
[PK__tbLanguageInSubs__7FEAFD3E] has been updated...
[_WA_Sys_00000001_7E02B4CC] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbInventoryXml]
[PK__tbInventoryXml__7FD5EEA5], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbPrerequisiteDependency]
[PK__tbPrerequisiteDe__00551192], 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.
Statistics for all tables have been updated.
Done updating statistics.2017-04-20 20:19:26.293
Delete sync history.2017-04-20 20:19:26.323
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
----------- ----------- ----------- ----------- --------------
5 1 997104 152 947624 947624
5 2 63 63 56 56
(2 Zeilen betroffen)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
----------- ----------- ----------- ----------- --------------
5 1 997016 152 947576 947576
(1 Zeilen betroffen)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
----------- ----------- ----------- ----------- --------------
5 2 63 63 56 56
(1 Zeilen betroffen)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Ende der Datenbankbereinigung: 20.04.2017 um 21:18:38,43 Uhr
Durch das Script hat sich der Wsus Content Ordner aber nicht verändert
hier mal das Logfile.
Cleanup Report für [SERVER] (Port: 8530)
Start der Datenbankbereinigung: 20.04.2017 um 15:38:26,63 Uhr
Cleanup Report für [SERVER] (Port: 8530)
Ausnahme beim Aufrufen von "PerformCleanup" mit 1 Argument(en): "Timeout ist a
bgelaufen. Das Zeitlimit wurde vor dem Beenden des Vorgangs berschritten oder
der Server reagiert nicht.
The statement has been terminated."
Bei C:\WSUS\WSUS-Serverbereinigung.ps1:37 Zeichen:31
$CleanupManager.PerformCleanup <<<< ($CleanupScope)
+ CategoryInfo : NotSpecified: ( , MethodInvocationException+ FullyQualifiedErrorId : DotNetMethodException
Ende Dateibereinigung: 20.04.2017 um 20:11:40,71 Uhr
SQL Server Wartung (Connect np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query)
Changed database context to 'SUSDB'.
Estimating fragmentation: Begin. 2017-04-20 20:11:52.143
Number of indexes to rebuild: 74
Estimating fragmentation: End. 2017-04-20 20:13:15.370
2017-04-20 20:13:15.430 Executing: ALTER INDEX [PK__tbBundleDependen__023D5A04] ON [dbo].[tbBundleDependency] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:18.177 Done.
2017-04-20 20:13:18.177 Executing: ALTER INDEX [nc1BundleDependency] ON [dbo].[tbBundleDependency] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:19.377 Done.
2017-04-20 20:13:19.377 Executing: ALTER INDEX [tbEulaProperty_PK] ON [dbo].[tbEulaProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:19.643 Done.
2017-04-20 20:13:19.643 Executing: ALTER INDEX [nc1EulaProperty] ON [dbo].[tbEulaProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:19.767 Done.
2017-04-20 20:13:19.767 Executing: ALTER INDEX [nc2EulaProperty] ON [dbo].[tbEulaProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:20.000 Done.
2017-04-20 20:13:20.000 Executing: ALTER INDEX [cUpdateStatusPerComputer] ON [dbo].[tbUpdateStatusPerComputer] REBUILD
2017-04-20 20:13:20.203 Done.
2017-04-20 20:13:20.203 Executing: ALTER INDEX [nc3UpdateStatusPerComputer] ON [dbo].[tbUpdateStatusPerComputer] REBUILD
2017-04-20 20:13:20.283 Done.
2017-04-20 20:13:20.283 Executing: ALTER INDEX [nc2UpdateStatusPerComputer] ON [dbo].[tbUpdateStatusPerComputer] REBUILD
2017-04-20 20:13:20.483 Done.
2017-04-20 20:13:20.483 Executing: ALTER INDEX [PK__tbUpdateSummaryF__060DEAE8] ON [dbo].[tbUpdateSummaryForAllComputers] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:20.673 Done.
2017-04-20 20:13:20.673 Executing: ALTER INDEX [PK__tbRevisionInCate__078C1F06] ON [dbo].[tbRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:24.650 Done.
2017-04-20 20:13:24.650 Executing: ALTER INDEX [nc1RevisionInCategory] ON [dbo].[tbRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:13:26.693 Done.
2017-04-20 20:13:26.693 Executing: ALTER INDEX [PK__tbFile__0A9D95DB] ON [dbo].[tbFile] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:14:23.040 Done.
2017-04-20 20:14:23.040 Executing: ALTER INDEX [nc1tbXml] ON [dbo].[tbXml] REORGANIZE
2017-04-20 20:14:47.923 Done.
2017-04-20 20:14:47.923 Executing: ALTER INDEX [nc2tbXml] ON [dbo].[tbXml] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:14:57.750 Done.
2017-04-20 20:14:57.780 Executing: ALTER INDEX [PK__tbRevision__17C286CF] ON [dbo].[tbRevision] REORGANIZE
2017-04-20 20:14:59.263 Done.
2017-04-20 20:14:59.263 Executing: ALTER INDEX [UQ__tbRevision__0E391C95] ON [dbo].[tbRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:01.073 Done.
2017-04-20 20:15:01.073 Executing: ALTER INDEX [ncRevision_LocalUpdateID_RevisionNumber__IsLatestRevision] ON [dbo].[tbRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:01.947 Done.
2017-04-20 20:15:01.947 Executing: ALTER INDEX [c0FileOnServer] ON [dbo].[tbFileOnServer] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:07.450 Done.
2017-04-20 20:15:07.450 Executing: ALTER INDEX [PK__tbFileOnServer__2CA8951C] ON [dbo].[tbFileOnServer] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:11.007 Done.
2017-04-20 20:15:11.007 Executing: ALTER INDEX [c0FileDownloadProgress] ON [dbo].[tbFileDownloadProgress] REBUILD
2017-04-20 20:15:11.130 Done.
2017-04-20 20:15:11.130 Executing: ALTER INDEX [PK__tbUpdate__2704CA5F] ON [dbo].[tbUpdate] REORGANIZE
2017-04-20 20:15:25.790 Done.
2017-04-20 20:15:25.790 Executing: ALTER INDEX [UQ__tbUpdate__27F8EE98] ON [dbo].[tbUpdate] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:26.850 Done.
2017-04-20 20:15:26.850 Executing: ALTER INDEX [nc1UpdateIsLocallyPublished] ON [dbo].[tbUpdate] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:27.240 Done.
2017-04-20 20:15:27.240 Executing: ALTER INDEX [PK__tbEventInstance__2C3E80C8] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:27.413 Done.
2017-04-20 20:15:27.413 Executing: ALTER INDEX [PK__tbEventInstance__2C3E80C8] ON [dbo].[tbEventInstance] REORGANIZE
2017-04-20 20:15:28.630 Done.
2017-04-20 20:15:28.630 Executing: ALTER INDEX [nc3EventInstanceConstraint] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:28.723 Done.
2017-04-20 20:15:28.723 Executing: ALTER INDEX [nc2EventInstance] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:28.753 Done.
2017-04-20 20:15:28.753 Executing: ALTER INDEX [nc4EventInstance] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:28.817 Done.
2017-04-20 20:15:28.817 Executing: ALTER INDEX [ncEventInstance_ComputerID_EventNamespaceID_EventID] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:28.880 Done.
2017-04-20 20:15:28.880 Executing: ALTER INDEX [nc_EventNamespaceID_EventID] ON [dbo].[tbEventInstance] REBUILD
2017-04-20 20:15:28.927 Done.
2017-04-20 20:15:28.943 Executing: ALTER INDEX [c_RevisionID] ON [dbo].[ivwApiUpdateRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:29.393 Done.
2017-04-20 20:15:29.393 Executing: ALTER INDEX [nc_LocalUpdateID] ON [dbo].[ivwApiUpdateRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:29.660 Done.
2017-04-20 20:15:29.660 Executing: ALTER INDEX [nc_EffectiveArrivalTime] ON [dbo].[ivwApiUpdateRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:29.800 Done.
2017-04-20 20:15:29.817 Executing: ALTER INDEX [c0DeploymentRevision] ON [dbo].[tbDeployment] REORGANIZE
2017-04-20 20:15:41.047 Done.
2017-04-20 20:15:41.047 Executing: ALTER INDEX [PK__tbDeployment__48CFD27E] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:43.013 Done.
2017-04-20 20:15:43.013 Executing: ALTER INDEX [nc2DeploymentRevision] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:50.267 Done.
2017-04-20 20:15:50.267 Executing: ALTER INDEX [nc5DeploymentRevision] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:52.093 Done.
2017-04-20 20:15:52.093 Executing: ALTER INDEX [nc6DeploymentRevision] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:15:56.210 Done.
2017-04-20 20:15:56.210 Executing: ALTER INDEX [nc_RevisionID_TargetGroupID_ActionID] ON [dbo].[tbDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:00.860 Done.
2017-04-20 20:16:00.860 Executing: ALTER INDEX [PK__tbFlattenedRevis__4865BE2A] ON [dbo].[tbFlattenedRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:01.733 Done.
2017-04-20 20:16:01.733 Executing: ALTER INDEX [nc1FlattenedRevisionInCategory] ON [dbo].[tbFlattenedRevisionInCategory] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:02.060 Done.
2017-04-20 20:16:02.077 Executing: ALTER INDEX [PK__tbDeadDeployment__4AB81AF0] ON [dbo].[tbDeadDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:11.793 Done.
2017-04-20 20:16:11.793 Executing: ALTER INDEX [nc1DeadDeployment] ON [dbo].[tbDeadDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:12.527 Done.
2017-04-20 20:16:12.527 Executing: ALTER INDEX [nc2DeadDeployment] ON [dbo].[tbDeadDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:13.463 Done.
2017-04-20 20:16:13.463 Executing: ALTER INDEX [nc3DeadDeployment] ON [dbo].[tbDeadDeployment] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:14.383 Done.
2017-04-20 20:16:14.383 Executing: ALTER INDEX [nc1PreComputedLocalizedProperty] ON [dbo].[tbPreComputedLocalizedProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:16:48.047 Done.
2017-04-20 20:16:48.047 Executing: ALTER INDEX [ncPreComputedLocalizedProperty_RevisionID_ShortLanguage] ON [dbo].[tbPreComputedLocalizedProperty] REORGANIZE
2017-04-20 20:17:07.877 Done.
2017-04-20 20:17:07.877 Executing: ALTER INDEX [PK__tbPrecomputedCat__4E1E9780] ON [dbo].[tbPrecomputedCategoryLocalizedProperty] REBUILD
2017-04-20 20:17:08.000 Done.
2017-04-20 20:17:08.000 Executing: ALTER INDEX [PK__tbRevisionLangua__5165187F] ON [dbo].[tbRevisionLanguage] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:13.180 Done.
2017-04-20 20:17:13.180 Executing: ALTER INDEX [nc1RevisionLanguage] ON [dbo].[tbRevisionLanguage] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:17.703 Done.
2017-04-20 20:17:17.703 Executing: ALTER INDEX [nc1Property] ON [dbo].[tbProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:19.030 Done.
2017-04-20 20:17:19.047 Executing: ALTER INDEX [nc2Property] ON [dbo].[tbProperty] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:20.043 Done.
2017-04-20 20:17:20.043 Executing: ALTER INDEX [PK__tbKBArticleForRe__59FA5E80] ON [dbo].[tbKBArticleForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:20.310 Done.
2017-04-20 20:17:20.310 Executing: ALTER INDEX [nc1KBArticleForRevision] ON [dbo].[tbKBArticleForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:20.573 Done.
2017-04-20 20:17:20.573 Executing: ALTER INDEX [tbKBArticleForRevision_RevisionID_AK] ON [dbo].[tbKBArticleForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:20.713 Done.
2017-04-20 20:17:20.713 Executing: ALTER INDEX [nc_RevisionID_ShortLanguage] ON [dbo].[tbMoreInfoURLForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:26.143 Done.
2017-04-20 20:17:26.143 Executing: ALTER INDEX [PK__tbSecurityBullet__5EBF139D] ON [dbo].[tbSecurityBulletinForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:26.300 Done.
2017-04-20 20:17:26.300 Executing: ALTER INDEX [nc1SecurityBulletinForRevision] ON [dbo].[tbSecurityBulletinForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:26.500 Done.
2017-04-20 20:17:26.500 Executing: ALTER INDEX [tbSecurityBulletinForRevision_RevisionID_AK] ON [dbo].[tbSecurityBulletinForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:26.640 Done.
2017-04-20 20:17:26.640 Executing: ALTER INDEX [PK__tbLocalizedPrope__60A75C0F] ON [dbo].[tbLocalizedPropertyForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:30.480 Done.
2017-04-20 20:17:30.480 Executing: ALTER INDEX [PK__tbFileForRevisio__28D80438] ON [dbo].[tbFileForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:32.570 Done.
2017-04-20 20:17:32.570 Executing: ALTER INDEX [nc1FileForRevision] ON [dbo].[tbFileForRevision] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:34.193 Done.
2017-04-20 20:17:34.193 Executing: ALTER INDEX [PK__tbRevisionSupers__656C112C] ON [dbo].[tbRevisionSupersedesUpdate] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:35.330 Done.
2017-04-20 20:17:35.330 Executing: ALTER INDEX [PK__tbInstalledUpdat__6754599E] ON [dbo].[tbInstalledUpdateSufficientForPrerequisite] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:40.150 Done.
2017-04-20 20:17:40.150 Executing: ALTER INDEX [nc1InstalledUpdateSufficientForPrerequisite] ON [dbo].[tbInstalledUpdateSufficientForPrerequisite] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:42.850 Done.
2017-04-20 20:17:42.867 Executing: ALTER INDEX [tbBundleAtLeastOne_PK] ON [dbo].[tbBundleAtLeastOne] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:44.067 Done.
2017-04-20 20:17:44.067 Executing: ALTER INDEX [nc1BundleAtLeastOne] ON [dbo].[tbBundleAtLeastOne] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:44.643 Done.
2017-04-20 20:17:44.643 Executing: ALTER INDEX [tbBundleAll_PK] ON [dbo].[tbBundleAll] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:44.957 Done.
2017-04-20 20:17:44.957 Executing: ALTER INDEX [nc1BundleAll] ON [dbo].[tbBundleAll] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:17:45.097 Done.
2017-04-20 20:17:45.097 Executing: ALTER INDEX [PK__tbPrerequisite__6D0D32F4] ON [dbo].[tbPrerequisite] REORGANIZE
2017-04-20 20:18:13.130 Done.
2017-04-20 20:18:13.130 Executing: ALTER INDEX [nc1Prerequisite] ON [dbo].[tbPrerequisite] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:18:15.190 Done.
2017-04-20 20:18:15.190 Executing: ALTER INDEX [PK__tbPrerequisiteDe__00551192] ON [dbo].[tbPrerequisiteDependency] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:18:28.743 Done.
2017-04-20 20:18:28.743 Executing: ALTER INDEX [nc1PrerequisiteDependency] ON [dbo].[tbPrerequisiteDependency] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:18:39.570 Done.
2017-04-20 20:18:39.570 Executing: ALTER INDEX [nc2PrerequisiteDependency] ON [dbo].[tbPrerequisiteDependency] REBUILD WITH (FILLFACTOR = 90)
2017-04-20 20:18:50.320 Done.
Estimated number of pages in fragmented indexes: 251283
Estimated number of pages freed: 96611
Updating all statistics.2017-04-20 20:18:50.583
Updating [dbo].[tbTargetInTargetGroup]
[PK__tbTargetInTarget__01142BA1] has been updated...
[nc1TargetInTargetGroup] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbSchedule]
[PK__tbSchedule__03BB8E22], update is not necessary...
[_WA_Sys_00000002_00DF2177], update is not necessary...
[_WA_Sys_00000006_00DF2177] has been updated...
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbBundleDependency]
[PK__tbBundleDependen__023D5A04], update is not necessary...
[nc1BundleDependency], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbInventoryClassInstance]
[PK__tbInventoryClass__02B25B50], update is not necessary...
[nc_TargetID_ClassID_KeyValue], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 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].[tbUpdateStatusPerComputer]
[cUpdateStatusPerComputer], update is not necessary...
[nc3UpdateStatusPerComputer], update is not necessary...
[nc2UpdateStatusPerComputer], update is not necessary...
[_WA_Sys_00000005_03317E3D] has been updated...
1 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbInventoryPropertyInstance]
[PK__tbInventoryPrope__049AA3C2], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbEulaAcceptance]
[PK__tbEulaAcceptance__04E4BC85] has been updated...
[_WA_Sys_00000002_03F0984C] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbEmailNotificationRecipient]
[_WA_Sys_00000002_04AFB25B], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbUpdateSummaryForAllComputers]
[PK__tbUpdateSummaryF__060DEAE8], update is not necessary...
[_WA_Sys_00000002_0519C6AF] has been updated...
[_WA_Sys_00000003_0519C6AF] has been updated...
[_WA_Sys_00000004_0519C6AF] has been updated...
[_WA_Sys_00000005_0519C6AF] has been updated...
[_WA_Sys_00000006_0519C6AF] has been updated...
[_WA_Sys_00000007_0519C6AF] has been updated...
6 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbRevisionInCategory]
[PK__tbRevisionInCate__078C1F06], update is not necessary...
[nc1RevisionInCategory], update is not necessary...
[_WA_Sys_00000003_05A3D694] has been updated...
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbLocalizedProperty]
[PK__tbLocalizedPrope__06CD04F7] has been updated...
[_WA_Sys_00000004_05D8E0BE] has been updated...
[_WA_Sys_00000002_05D8E0BE] has been updated...
[_WA_Sys_00000003_05D8E0BE] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbFile]
[PK__tbFile__0A9D95DB], update is not necessary...
[_WA_Sys_00000005_07C12930] has been updated...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbCategory]
[PK__tbCategory__0C50D423] has been updated...
[nc1Category] has been updated...
[_WA_Sys_00000003_0880433F] has been updated...
[_WA_Sys_00000001_0880433F] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbXml]
[PK__tbXml__0E6E26BF] has been updated...
[nc1tbXml] has been updated...
[nc2tbXml], update is not necessary...
[_WA_Sys_00000004_0B91BA14] has been updated...
3 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbComputerSummaryForMicrosoftUpdates]
[PK__tbComputerSummar__0DAF0CB0] has been updated...
[_WA_Sys_00000002_0CBAE877] has been updated...
[_WA_Sys_00000003_0CBAE877] has been updated...
[_WA_Sys_00000004_0CBAE877] has been updated...
[_WA_Sys_00000006_0CBAE877] has been updated...
[_WA_Sys_00000007_0CBAE877] has been updated...
[_WA_Sys_00000005_0CBAE877] has been updated...
7 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevision]
[PK__tbRevision__17C286CF] has been updated...
[UQ__tbRevision__0E391C95], update is not necessary...
[ncRevision_LocalUpdateID_RevisionNumber__IsLatestRevision], update is not necessary...
[_WA_Sys_0000000D_0D44F85C] has been updated...
[_WA_Sys_00000003_0D44F85C] has been updated...
[_WA_Sys_00000009_0D44F85C] has been updated...
[_WA_Sys_00000005_0D44F85C] has been updated...
[_WA_Sys_0000000C_0D44F85C] has been updated...
[_WA_Sys_0000000A_0D44F85C] has been updated...
[_WA_Sys_0000000E_0D44F85C] has been updated...
8 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbGroupAuthorization]
[PK__tbGroupAuthoriza__10566F31] has been updated...
[_WA_Sys_00000002_0F624AF8] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbAuthorization]
[PK__tbAuthorization__123EB7A3] has been updated...
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbFileOnServer]
[c0FileOnServer], update is not necessary...
[PK__tbFileOnServer__2CA8951C], update is not necessary...
[_WA_Sys_00000005_1332DBDC] has been updated...
[_WA_Sys_00000004_1332DBDC] has been updated...
[_WA_Sys_00000007_1332DBDC] has been updated...
[_WA_Sys_00000006_1332DBDC] has been updated...
4 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbRequestedTargetGroup]
[PK__tbRequestedTarge__15502E78], 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].[tbRequestedTargetGroupsForTarget]
[PK__tbRequestedTarge__173876EA], update is not necessary...
[nc1RequestedTargetGroupNamesForTarget], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbDeletedComputer]
[cDeletedComputer] has been updated...
[_WA_Sys_00000002_182C9B23] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevisionExtendedLanguageMask]
[PK__tbRevisionExtend__2057CCD0], update is not necessary...
[_WA_Sys_00000002_18B6AB08], update is not necessary...
[_WA_Sys_00000003_18B6AB08], update is not necessary...
[_WA_Sys_00000004_18B6AB08], update is not necessary...
[_WA_Sys_00000005_18B6AB08], update is not necessary...
[_WA_Sys_00000006_18B6AB08], update is not necessary...
[_WA_Sys_00000007_18B6AB08], update is not necessary...
[_WA_Sys_00000008_18B6AB08], update is not necessary...
0 index(es)/statistic(s) have been updated, 8 did not require update.
Updating [dbo].[tbFileDownloadProgress]
[c0FileDownloadProgress], update is not necessary...
[PK__tbFileDownloadPr__2D9CB955] has been updated...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbComputerTargetDetail]
[PK__tbComputerTarget__25869641] has been updated...
[_WA_Sys_00000019_1B0907CE] has been updated...
[_WA_Sys_00000018_1B0907CE] has been updated...
[_WA_Sys_00000002_1B0907CE] has been updated...
[_WA_Sys_00000003_1B0907CE] has been updated...
[_WA_Sys_00000004_1B0907CE] has been updated...
[_WA_Sys_00000005_1B0907CE] has been updated...
[_WA_Sys_00000006_1B0907CE] has been updated...
[_WA_Sys_00000007_1B0907CE] has been updated...
[_WA_Sys_0000000D_1B0907CE] has been updated...
[_WA_Sys_00000011_1B0907CE] has been updated...
[_WA_Sys_00000013_1B0907CE] has been updated...
[_WA_Sys_00000014_1B0907CE] has been updated...
[_WA_Sys_00000015_1B0907CE] has been updated...
[_WA_Sys_00000016_1B0907CE] has been updated...
[_WA_Sys_00000012_1B0907CE] has been updated...
16 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbReference]
[_WA_Sys_00000003_1F98B2C1] has been updated...
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbUpdate]
[PK__tbUpdate__2704CA5F] has been updated...
[UQ__tbUpdate__27F8EE98], update is not necessary...
[nc1UpdateIsLocallyPublished], update is not necessary...
[_WA_Sys_00000007_214BF109] has been updated...
[_WA_Sys_00000003_214BF109] has been updated...
[_WA_Sys_00000008_214BF109] has been updated...
[_WA_Sys_00000009_214BF109] has been updated...
[_WA_Sys_00000006_214BF109] has been updated...
[_WA_Sys_0000000A_214BF109] has been updated...
[_WA_Sys_0000000C_214BF109] has been updated...
8 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbFrontEndServersHealth]
[_WA_Sys_00000001_236943A5] has been updated...
[_WA_Sys_00000002_236943A5] has been updated...
[_WA_Sys_00000003_236943A5] has been updated...
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbConfigurationC]
[PK__tbConfigurationC__4B7734FF], update is not necessary...
[_WA_Sys_00000006_25518C17] has been updated...
[_WA_Sys_00000007_25518C17] has been updated...
[_WA_Sys_00000010_25518C17] has been updated...
[_WA_Sys_00000013_25518C17] has been updated...
4 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbComputerTarget]
[PK__tbComputerTarget__2A4B4B5E] has been updated...
[UQ__tbComputerTarget__276EDEB3] has been updated...
[nc1ComputerTarget] has been updated...
[nc4ComputerTarget] has been updated...
[nc5ComputerTarget] has been updated...
[nc_EffectiveLastDetectionTime] has been updated...
[ncComputerTarget_FullDomainName] has been updated...
[_WA_Sys_00000004_267ABA7A] has been updated...
[_WA_Sys_0000000E_267ABA7A] has been updated...
[_WA_Sys_00000006_267ABA7A] has been updated...
10 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbEventMessageTemplate]
[PK__tbEventMessageTe__2B4A5C8F] has been updated...
[_WA_Sys_00000002_2759D01A] has been updated...
[_WA_Sys_00000003_2759D01A] has been updated...
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbUpdateType]
[PK__tbUpdateType__29E1370A], update is not necessary...
[_WA_Sys_00000002_28ED12D1], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbEventInstance]
[PK__tbEventInstance__2C3E80C8], update is not necessary...
[nc3EventInstanceConstraint], update is not necessary...
[nc2EventInstance], update is not necessary...
[nc4EventInstance], update is not necessary...
[ncEventInstance_ComputerID_EventNamespaceID_EventID], update is not necessary...
[nc_EventNamespaceID_EventID], update is not necessary...
[_WA_Sys_0000000D_2942188C] has been updated...
[_WA_Sys_00000002_2942188C] has been updated...
[_WA_Sys_00000004_2942188C] has been updated...
[_WA_Sys_00000005_2942188C] has been updated...
4 index(es)/statistic(s) have been updated, 6 did not require update.
Updating [dbo].[tbUpdateFlag]
[PK__tbUpdateFlag__2BC97F7C], update is not necessary...
[_WA_Sys_00000002_2AD55B43], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbClientWithRecentNameChange]
[c0ClientWithRecentNameChange], update is not necessary...
[nc1ClientWithRecentNameChange], update is not necessary...
[nc2ClientWithRecentNameChange], update is not necessary...
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbEvent]
[PK__tbEvent__2E06CDA9] has been updated...
[_WA_Sys_00000002_2C1E8537] has been updated...
[_WA_Sys_00000004_2C1E8537] has been updated...
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDownstreamServerTarget]
[PK__tbDownstreamServ__2E1BDC42], update is not necessary...
[ncDownstreamServerTarget_AccountServerID], update is not necessary...
[_WA_Sys_00000003_2C3393D0], update is not necessary...
[_WA_Sys_00000008_2C3393D0], update is not necessary...
0 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbHandler]
[PK__tbHandler__2DB1C7EE], update is not necessary...
[_WA_Sys_00000002_2CBDA3B5], update is not necessary...
[_WA_Sys_00000003_2CBDA3B5], update is not necessary...
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbSingletonData]
[PK__tbSingletonData__32616E72] has been updated...
[_WA_Sys_00000004_2E90DD8E], update is not necessary...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbLanguage]
[PK__tbLanguage__336AA144], update is not necessary...
[nc1Language], update is not necessary...
[_WA_Sys_00000006_2EA5EC27] has been updated...
[_WA_Sys_00000008_2EA5EC27] has been updated...
2 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbEventSource]
[PK__tbEventSource__2FEF161B] has been updated...
[_WA_Sys_00000002_2EFAF1E2] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDownstreamServerSummaryRollup]
[PK__tbDownstreamServ__300424B4], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbEventNamespace]
[PK__tbEventNamespace__31D75E8D] has been updated...
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDownstreamServerClientSummaryRollup]
[PK__tbDownstreamServ__35BCFE0A] has been updated...
[_WA_Sys_00000001_30F848ED] has been updated...
[_WA_Sys_00000003_30F848ED] has been updated...
[_WA_Sys_00000004_30F848ED] has been updated...
[_WA_Sys_00000005_30F848ED] has been updated...
[_WA_Sys_00000006_30F848ED] has been updated...
[_WA_Sys_00000007_30F848ED] has been updated...
[_WA_Sys_00000008_30F848ED] has been updated...
[_WA_Sys_00000009_30F848ED] has been updated...
[_WA_Sys_0000000F_30F848ED] has been updated...
[_WA_Sys_0000000C_30F848ED] has been updated...
[_WA_Sys_0000000D_30F848ED] has been updated...
[_WA_Sys_0000000E_30F848ED] has been updated...
13 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbCategoryType]
[PK__tbCategoryType__3552E9B6], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbStateMachine]
[PK__tbStateMachine__373B3228] has been updated...
[nc1StateMachine] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDownstreamServerClientActivityRollup]
[PK__tbDownstreamServ__37A5467C] has been updated...
[_WA_Sys_00000002_36B12243] has been updated...
[_WA_Sys_00000003_36B12243] has been updated...
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbStateMachineState]
[PK__tbStateMachineSt__39237A9A] has been updated...
[nc1StateMachineState] has been updated...
[stateNameUniqueForStateMachineID] has been updated...
[_WA_Sys_00000002_382F5661] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbTarget]
[PK__tbTarget__3A81B327] has been updated...
[nc1Target] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbLocaleMap]
[PK__tbLocaleMap__3B60C8C7], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbStateMachineEvent]
[PK__tbStateMachineEv__3BFFE745] has been updated...
[nc1StateMachineEvent] has been updated...
[eventNameUniqueForStateMachineID] has been updated...
[_WA_Sys_00000002_3B0BC30C], update is not necessary...
3 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbTargetType]
[PK__tbTargetType__3C69FB99], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbOSMap]
[PK__tbOSMap__3D491139], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbDeployment]
[c0DeploymentRevision] has been updated...
[PK__tbDeployment__48CFD27E], update is not necessary...
[nc2DeploymentRevision], update is not necessary...
[nc5DeploymentRevision], update is not necessary...
[nc6DeploymentRevision], update is not necessary...
[nc_RevisionID_TargetGroupID_ActionID], update is not necessary...
[_WA_Sys_00000005_3D5E1FD2] has been updated...
[_WA_Sys_0000000F_3D5E1FD2] has been updated...
[_WA_Sys_00000008_3D5E1FD2] has been updated...
[_WA_Sys_00000002_3D5E1FD2] has been updated...
[_WA_Sys_00000011_3D5E1FD2] has been updated...
[_WA_Sys_00000010_3D5E1FD2] has been updated...
[_WA_Sys_00000004_3D5E1FD2] has been updated...
[_WA_Sys_0000000C_3D5E1FD2] has been updated...
[_WA_Sys_00000013_3D5E1FD2] has been updated...
[_WA_Sys_0000000A_3D5E1FD2] has been updated...
[_WA_Sys_00000006_3D5E1FD2] has been updated...
12 index(es)/statistic(s) have been updated, 5 did not require update.
Updating [dbo].[tbStateMachineTransition]
[PK__tbStateMachineTr__3EDC53F0] has been updated...
[_WA_Sys_00000002_3DE82FB7] has been updated...
[_WA_Sys_00000003_3DE82FB7] has been updated...
[_WA_Sys_00000004_3DE82FB7] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDownstreamServerRollupConfiguration]
[PK__tbDownstreamServ__34D3C6C9], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbStateMachineEventTransitionLog]
[PK__tbStateMachineEv__41B8C09B], update is not necessary...
[_WA_Sys_00000002_3FD07829], update is not necessary...
[_WA_Sys_00000003_3FD07829], update is not necessary...
[_WA_Sys_00000005_3FD07829], update is not necessary...
[_WA_Sys_00000006_3FD07829], update is not necessary...
[_WA_Sys_00000007_3FD07829], update is not necessary...
0 index(es)/statistic(s) have been updated, 6 did not require update.
Updating [dbo].[tbEventRollupCounters]
[PK__tbEventRollupCou__35C7EB02], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbNotificationEvent]
[PK__tbNotificationEv__44952D46] has been updated...
[_WA_Sys_00000004_43A1090D] has been updated...
[_WA_Sys_00000003_43A1090D] has been updated...
[_WA_Sys_00000002_43A1090D] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbChangeTracking]
[c0ChangeTracking], update is not necessary...
[PK__tbChangeTracking__467D75B8] has been updated...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbFlattenedRevisionInCategory]
[PK__tbFlattenedRevis__4865BE2A], update is not necessary...
[nc1FlattenedRevisionInCategory], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbServerSyncResult]
[PK__tbServerSyncResu__4A4E069C], 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].[tbDeadDeployment]
[PK__tbDeadDeployment__4AB81AF0], update is not necessary...
[nc1DeadDeployment], update is not necessary...
[nc2DeadDeployment], update is not necessary...
[nc3DeadDeployment], update is not necessary...
[_WA_Sys_0000000D_49C3F6B7] has been updated...
[_WA_Sys_0000000F_49C3F6B7] has been updated...
[_WA_Sys_00000012_49C3F6B7] has been updated...
[_WA_Sys_00000003_49C3F6B7] has been updated...
4 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbPreComputedLocalizedProperty]
[PK__tbPreComputedLoc__4C364F0E] has been updated...
[nc1PreComputedLocalizedProperty], update is not necessary...
[ncPreComputedLocalizedProperty_RevisionID_ShortLanguage] has been updated...
[_WA_Sys_00000002_4B422AD5] has been updated...
[_WA_Sys_00000003_4B422AD5] has been updated...
[_WA_Sys_00000004_4B422AD5] has been updated...
[_WA_Sys_00000005_4B422AD5] has been updated...
6 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbConfigurationB]
[PK__tbConfigurationB__6442E2C9], update is not necessary...
[_WA_Sys_00000003_4C6B5938] has been updated...
[_WA_Sys_00000002_4C6B5938] has been updated...
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbPrecomputedCategoryLocalizedProperty]
[PK__tbPrecomputedCat__4E1E9780], update is not necessary...
[_WA_Sys_00000002_4D2A7347] has been updated...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbAutoDeploymentRule]
[PK__tbAutoDeployment__51EF2864], update is not necessary...
[_WA_Sys_00000002_4F12BBB9] has been updated...
[_WA_Sys_00000003_4F12BBB9] has been updated...
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbRevisionLanguage]
[PK__tbRevisionLangua__5165187F], update is not necessary...
[nc1RevisionLanguage], update is not necessary...
[_WA_Sys_00000003_4F7CD00D] has been updated...
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbProperty]
[PK__tbProperty__5629CD9C] has been updated...
[nc1Property], update is not necessary...
[nc2Property], update is not necessary...
[_WA_Sys_00000005_52593CB8] has been updated...
[_WA_Sys_00000006_52593CB8] has been updated...
[_WA_Sys_0000000B_52593CB8] has been updated...
[_WA_Sys_00000013_52593CB8] has been updated...
[_WA_Sys_00000004_52593CB8] has been updated...
[_WA_Sys_00000002_52593CB8] has been updated...
[_WA_Sys_00000003_52593CB8] has been updated...
[_WA_Sys_00000012_52593CB8] has been updated...
[_WA_Sys_00000015_52593CB8] has been updated...
[_WA_Sys_00000009_52593CB8] has been updated...
[_WA_Sys_0000000E_52593CB8] has been updated...
12 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbUpdateClassificationInAutoDeploymentRule]
[PK__tbUpdateClassifi__53D770D6] has been updated...
[_WA_Sys_00000002_52E34C9D] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbCategoryInAutoDeploymentRule]
[PK__tbCategoryInAuto__55BFB948], update is not necessary...
[_WA_Sys_00000002_54CB950F], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbTargetGroupInAutoDeploymentRule]
[PK__tbTargetGroupInA__57A801BA] has been updated...
[_WA_Sys_00000002_56B3DD81] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevisionExtendedProperty]
[cRevisionExtendedProperty], update is not necessary...
[PK__tbRevisionExtend__5812160E], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbSchemaVersion]
[PK__tbSchemaVersion__5A846E65] has been updated...
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbKBArticleForRevision]
[PK__tbKBArticleForRe__59FA5E80], update is not necessary...
[nc1KBArticleForRevision], update is not necessary...
[tbKBArticleForRevision_RevisionID_AK], update is not necessary...
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbMoreInfoURLForRevision]
[PK__tbMoreInfoURLFor__5CD6CB2B] has been updated...
[nc_RevisionID_ShortLanguage], update is not necessary...
[_WA_Sys_00000004_5AEE82B9] has been updated...
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbSchemaVersionHistory]
[PK__tbSchemaVersionH__5C6CB6D7] has been updated...
[_WA_Sys_00000002_5B78929E], update is not necessary...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbSecurityBulletinForRevision]
[PK__tbSecurityBullet__5EBF139D], update is not necessary...
[nc1SecurityBulletinForRevision], update is not necessary...
[tbSecurityBulletinForRevision_RevisionID_AK], update is not necessary...
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbServerHealth]
[PK__tbServerHealth__61316BF4], update is not necessary...
[_WA_Sys_00000002_5F492382] has been updated...
[_WA_Sys_00000003_5F492382] has been updated...
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbLocalizedPropertyForRevision]
[PK__tbLocalizedPrope__60A75C0F], update is not necessary...
[_WA_Sys_00000002_5FB337D6] has been updated...
[_WA_Sys_00000003_5FB337D6] has been updated...
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbFileForRevision]
[PK__tbFileForRevisio__28D80438], update is not necessary...
[nc1FileForRevision], update is not necessary...
[_WA_Sys_00000003_619B8048] has been updated...
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbProgramKeys]
[PK__tbProgramKeys__6319B466], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbComputersThatNeedDetailedRollup]
[cComputersThatNeedDetailedRollup] has been updated...
[_WA_Sys_00000002_640DD89F] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevisionSupersedesUpdate]
[PK__tbRevisionSupers__656C112C], update is not necessary...
[_WA_Sys_00000002_6477ECF3] has been updated...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbConfigurationA]
[PK__tbConfigurationA__756D6ECB], update is not necessary...
[_WA_Sys_0000000E_65370702] has been updated...
[_WA_Sys_00000018_65370702] has been updated...
[_WA_Sys_0000000F_65370702] has been updated...
[_WA_Sys_00000004_65370702] has been updated...
4 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbInstalledUpdateSufficientForPrerequisite]
[PK__tbInstalledUpdat__6754599E], update is not necessary...
[nc1InstalledUpdateSufficientForPrerequisite], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbBundleAtLeastOne]
[tbBundleAtLeastOne_PK], update is not necessary...
[nc1BundleAtLeastOne], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbBundleAll]
[tbBundleAll_PK], update is not necessary...
[nc1BundleAll], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbPrerequisite]
[PK__tbPrerequisite__6D0D32F4] has been updated...
[nc1Prerequisite], update is not necessary...
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbDriver]
[PK__tbDriver__29CC2871], update is not necessary...
[nc1Driver], update is not necessary...
[nc2Driver], update is not necessary...
[_WA_Sys_00000008_6E01572D], update is not necessary...
0 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbCompatiblePrinterProvider]
[PK__tbCompatiblePrin__70DDC3D8], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbDriverClass]
[PK__tbDriverClass__72C60C4A], update is not necessary...
[_WA_Sys_00000002_71D1E811], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbTargetGroup]
[PK__tbTargetGroup__778AC167] has been updated...
[_WA_Sys_00000007_73BA3083] has been updated...
[_WA_Sys_00000001_73BA3083] has been updated...
[_WA_Sys_00000002_73BA3083] has been updated...
[_WA_Sys_00000006_73BA3083], update is not necessary...
4 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbConfiguration]
[PK__tbConfiguration__7755B73D] has been updated...
[_WA_Sys_00000002_76619304] has been updated...
2 index(es)/statistic(s) have been updated, 0 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].[tbInventoryRule]
[PK__tbInventoryRule__7928F116] has been updated...
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbImplicitCategory]
[PK__tbImplicitCatego__7B264821] has been updated...
[_WA_Sys_00000002_7849DB76] has been updated...
[_WA_Sys_00000003_7849DB76] has been updated...
[_WA_Sys_00000004_7849DB76] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbFlattenedTargetGroup]
[cFlattenedTargetGroup] has been updated...
[_WA_Sys_00000002_787EE5A0], update is not necessary...
1 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].[tbInventoryClass]
[PK__tbInventoryClass__7B113988] has been updated...
[UQ__tbInventoryClass__7C055DC1] has been updated...
2 index(es)/statistic(s) have been updated, 0 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].[tbTargetGroupType]
[PK__tbTargetGroupTyp__7C4F7684], update is not necessary...
[_WA_Sys_00000002_7B5B524B], update is not necessary...
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbCategoryInSubscription]
[PK__tbCategoryInSubs__7D0E9093] has been updated...
[_WA_Sys_00000001_7C1A6C5A] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbInventoryProperty]
[PK__tbInventoryPrope__7DEDA633] has been updated...
[nc_ClassID_Name] has been updated...
[_WA_Sys_00000003_7CF981FA] has been updated...
[_WA_Sys_00000004_7CF981FA] has been updated...
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbExpandedTargetInTargetGroup]
[PK__tbExpandedTarget__7E37BEF6] has been updated...
[nc1ExpandedTargetInTargetGroup] has been updated...
[_WA_Sys_00000003_7D439ABD] has been updated...
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbLanguageInSubscription]
[PK__tbLanguageInSubs__7FEAFD3E] has been updated...
[_WA_Sys_00000001_7E02B4CC] has been updated...
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbInventoryXml]
[PK__tbInventoryXml__7FD5EEA5], update is not necessary...
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbPrerequisiteDependency]
[PK__tbPrerequisiteDe__00551192], 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.
Statistics for all tables have been updated.
Done updating statistics.2017-04-20 20:19:26.293
Delete sync history.2017-04-20 20:19:26.323
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
----------- ----------- ----------- ----------- --------------
5 1 997104 152 947624 947624
5 2 63 63 56 56
(2 Zeilen betroffen)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
----------- ----------- ----------- ----------- --------------
5 1 997016 152 947576 947576
(1 Zeilen betroffen)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
----------- ----------- ----------- ----------- --------------
5 2 63 63 56 56
(1 Zeilen betroffen)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Ende der Datenbankbereinigung: 20.04.2017 um 21:18:38,43 Uhr
Durch das Script hat sich der Wsus Content Ordner aber nicht verändert
Hallo
Ist ja auch klar, steht ja im Log, dass die Dateibereinigung nicht abgeschlossen werden konnte.
Bin jetzt auch nicht gerade der Powershell Spezi (bin's erst noch am Lernern), kann da nicht weiterhelfen.
Hatte diese Probleme noch nie.
Hat denn der User, unter dem du das Script laufen lässt, Zugriff auf das Verzeichnis WSUS-Content?
Gruss
Ausnahme beim Aufrufen von "PerformCleanup" mit 1 Argument(en): "Timeout ist a
bgelaufen. Das Zeitlimit wurde vor dem Beenden des Vorgangs berschritten oder
der Server reagiert nicht.
The statement has been terminated."
Bei C:\WSUS\WSUS-Serverbereinigung.ps1:37 Zeichen:31
+ CategoryInfo : NotSpecified: ( , MethodInvocationException
+ FullyQualifiedErrorId : DotNetMethodException
Ende Dateibereinigung: 20.04.2017 um 20:11:40,71 Uhr
bgelaufen. Das Zeitlimit wurde vor dem Beenden des Vorgangs berschritten oder
der Server reagiert nicht.
The statement has been terminated."
Bei C:\WSUS\WSUS-Serverbereinigung.ps1:37 Zeichen:31
$CleanupManager.PerformCleanup <<<< ($CleanupScope)
+ CategoryInfo : NotSpecified: ( , MethodInvocationException+ FullyQualifiedErrorId : DotNetMethodException
Ende Dateibereinigung: 20.04.2017 um 20:11:40,71 Uhr
Ist ja auch klar, steht ja im Log, dass die Dateibereinigung nicht abgeschlossen werden konnte.
Bin jetzt auch nicht gerade der Powershell Spezi (bin's erst noch am Lernern), kann da nicht weiterhelfen.
Hatte diese Probleme noch nie.
Hat denn der User, unter dem du das Script laufen lässt, Zugriff auf das Verzeichnis WSUS-Content?
Gruss
Ok, das habe ich überlesen.
Dank dir für deine Unterstützung, ich schau dann nochmal.
Lass den Post aber noch offen.
Dank dir für deine Unterstützung, ich schau dann nochmal.
Lass den Post aber noch offen.
