errors when synchronising updates from WSUS. Increasing HTTP session times, max upload limits and max memory times can certainly help but if making major changes, it may also be necessary to make the infrastructure as clean as possible to improve efficiency. Each second can make a huge difference.
The following SQL script should be run from within the Microsoft SQL Management Studio interface when connected to the database instance containing the SCCM database. I got most if not all of this script from somewhere years ago. I’ts been in my tool kit ever since. I’m sorry I cant give the original source.
USE SUSDB;
GO
SET NOCOUNT ON;
-- Rebuild or reorganize indexes based on their fragmentation levels
DECLARE @work_to_do TABLE (
objectid int
, indexid int
, pagedensity float
, fragmentation float
, numrows int
)
DECLARE @objectid int;
DECLARE @indexid int;
DECLARE @schemaname nvarchar(130);
DECLARE @objectname nvarchar(130);
DECLARE @indexname nvarchar(130);
DECLARE @numrows int
DECLARE @density float;
DECLARE @fragmentation float;
DECLARE @command nvarchar(4000);
DECLARE @fillfactorset bit
DECLARE @numpages int
-- Select indexes that need to be defragmented based on the following
-- * Page density is low
-- * External fragmentation is high in relation to index size
PRINT 'Estimating fragmentation: Begin. ' + convert(nvarchar, getdate(), 121)
INSERT @work_to_do
SELECT
f.object_id
, index_id
, avg_page_space_used_in_percent
, avg_fragmentation_in_percent
, record_count
FROM
sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'SAMPLED') AS f
WHERE
(f.avg_page_space_used_in_percent < 85.0 and f.avg_page_space_used_in_percent/100.0 * page_count < page_count - 1)
or (f.page_count > 50 and f.avg_fragmentation_in_percent > 15.0)
or (f.page_count > 10 and f.avg_fragmentation_in_percent > 80.0)
PRINT 'Number of indexes to rebuild: ' + cast(@@ROWCOUNT as nvarchar(20))
PRINT 'Estimating fragmentation: End. ' + convert(nvarchar, getdate(), 121)
SELECT @numpages = sum(ps.used_page_count)
FROM
@work_to_do AS fi
INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and fi.indexid = i.index_id
INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id = ps.object_id and i.index_id = ps.index_id
-- Declare the cursor for the list of indexes to be processed.
DECLARE curIndexes CURSOR FOR SELECT * FROM @work_to_do
-- Open the cursor.
OPEN curIndexes
-- Loop through the indexes
WHILE (1=1)
BEGIN
FETCH NEXT FROM curIndexes
INTO @objectid, @indexid, @density, @fragmentation, @numrows;
IF @@FETCH_STATUS < 0 BREAK;
SELECT
@objectname = QUOTENAME(o.name)
, @schemaname = QUOTENAME(s.name)
FROM sys.objects AS o
INNER JOIN sys.schemas as s ON s.schema_id = o.schema_id
WHERE
o.object_id = @objectid;
SELECT
@indexname = QUOTENAME(name)
, @fillfactorset = CASE fill_factor WHEN 0 THEN 0 ELSE 1 END
FROM
sys.indexes
WHERE
object_id = @objectid AND index_id = @indexid;
IF ((@density BETWEEN 75.0 AND 85.0) AND @fillfactorset = 1) OR (@fragmentation < 30.0)
SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REORGANIZE';
ELSE IF @numrows >= 5000 AND @fillfactorset = 0
SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD WITH (FILLFACTOR = 90)';
ELSE
SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD';
PRINT convert(nvarchar, getdate(), 121) + N' Executing: ' + @command;
EXEC (@command);
PRINT convert(nvarchar, getdate(), 121) + N' Done.';
END
-- Close and deallocate the cursor.
CLOSE curIndexes;
DEALLOCATE curIndexes;
IF EXISTS (SELECT * FROM @work_to_do)
BEGIN
PRINT 'Estimated number of pages in fragmented indexes: ' + cast(@numpages as nvarchar(20))
SELECT @numpages = @numpages - sum(ps.used_page_count)
FROM
@work_to_do AS fi
INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and fi.indexid = i.index_id
INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id = ps.object_id and i.index_id = ps.index_id
PRINT 'Estimated number of pages freed: ' + cast(@numpages as nvarchar(20))
END
GO
--Update all statistics
PRINT 'Updating all statistics.' + convert(nvarchar, getdate(), 121)
EXEC sp_updatestats
PRINT 'Done updating statistics.' + convert(nvarchar, getdate(), 121)
GO
Watching the output of this script is quite important. The last 1000 lines provide the most information.
You will want to take note of the level of cleanup that has been achieved as this could indicate the levels of efficiency that you can expect. The easiest way of doing this is to search for the words “have been updated”. Look at the number at the start of that line. If it’s more than 0, the script has found indexes to rebuild.
Sample output is shown below:
Estimated number of pages in fragmented indexes: 393155
Estimated number of pages freed: 69459
Updating all statistics.2018-07-06 09:54:29.657
Updating [dbo].[tbUpdateClassificationInAutoDeploymentRule]
[PK__tbUpdate__EF57E38AB5DB6069], update is not necessary…
[_WA_Sys_00000002_00AA174D], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbEventNamespace]
[PK__tbEventN__D26A6B34F8C5246F] has been updated…
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevisionExtendedProperty]
[cRevisionExtendedProperty], update is not necessary…
[PK__tbRevisi__B4B1E3F0A229664B], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbDcRollupStatus]
[PK__tbDcRoll__3214EC0761B4055F], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbCategoryInAutoDeploymentRule]
[PK__tbCatego__89359C8D3A834AA7], update is not necessary…
[_WA_Sys_00000002_02925FBF], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbKBArticleForRevision]
[PK__tbKBArti__41E15B7381E7F648] has been updated…
[nc1KBArticleForRevision], update is not necessary…
[tbKBArticleForRevision_RevisionID_AK], update is not necessary…
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbTargetGroupInAutoDeploymentRule]
[PK__tbTarget__EF99A0AB57E3CAE9], update is not necessary…
[_WA_Sys_00000002_047AA831], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbMoreInfoURLForRevision]
[PK__tbMoreIn__DF49EF3CD9A1749F], update is not necessary…
[nc_RevisionID_ShortLanguage], update is not necessary…
[_WA_Sys_00000004_04E4BC85] has been updated…
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbDeletedDynamicCategory]
[PK__tbDelete__3214EC072B5F7A37], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [sys].[sqlagent_jobs]
[sqlagent_jobs_clust], update is not necessary…
[sqlagent_jobs_nc1_name], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbSchemaVersion]
[PK__tbSchema__3214EC270B90850F], update is not necessary…
[_WA_Sys_00000002_0662F0A3], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [sys].[sqlagent_jobsteps]
[sqlagent_jobsteps_clust], update is not necessary…
[sqlagent_jobsteps_nc1], update is not necessary…
[sqlagent_jobsteps_nc2], update is not necessary…
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbSecurityBulletinForRevision]
[PK__tbSecuri__2A32F464E5E42E8C] has been updated…
[nc1SecurityBulletinForRevision], update is not necessary…
[tbSecurityBulletinForRevision_RevisionID_AK], update is not necessary…
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [sys].[sqlagent_job_history]
[sqlagent_job_history_clust], update is not necessary…
[sqlagent_job_history_nc1], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [sys].[sqlagent_jobsteps_logs]
[sqlagent_jobsteps_logs_nc1], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbSchemaVersionHistory]
[PK__tbSchema__3214EC27B3BDE56D], update is not necessary…
[_WA_Sys_00000002_093F5D4E], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbLocalizedPropertyForRevision]
[PK__tbLocali__D4CFF398BDB7EF27], update is not necessary…
[_WA_Sys_00000003_09A971A2] has been updated…
[_WA_Sys_00000002_09A971A2] has been updated…
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [sys].[plan_persist_query_text]
[plan_persist_query_text_cidx], update is not necessary…
[plan_persist_query_text_idx1], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbLocaleMap]
[PK__tbLocale__AE84BA92B17C16E3] has been updated…
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [sys].[plan_persist_query]
[plan_persist_query_cidx], update is not necessary…
[plan_persist_query_idx1], update is not necessary…
[_WA_Sys_0000000B_0AD2A005], update is not necessary…
[_WA_Sys_00000007_0AD2A005], update is not necessary…
0 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbFileForRevision]
[PK__tbFileFo__42CF22AD08F0CC92] has been updated…
[nc1FileForRevision], update is not necessary…
[_WA_Sys_00000003_0B91BA14] has been updated…
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [sys].[plan_persist_plan]
[plan_persist_plan_cidx], update is not necessary…
[plan_persist_plan_idx1], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbOSMap]
[PK__tbOSMap__AEE3B0B5D347E461] has been updated…
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [sys].[plan_persist_runtime_stats]
[plan_persist_runtime_stats_cidx], update is not necessary…
[plan_persist_runtime_stats_idx1], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbServerHealth]
[PK__tbServer__DB06D1C0AB2C4E74], update is not necessary…
[_WA_Sys_00000002_0D0FEE32] has been updated…
[_WA_Sys_00000003_0D0FEE32] has been updated…
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [sys].[plan_persist_runtime_stats_interval]
[plan_persist_runtime_stats_interval_cidx], update is not necessary…
[plan_persist_runtime_stats_interval_idx1], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbDownstreamServerRollupConfiguration]
[PK__tbDownst__3214EC27E574F228] has been updated…
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbFileHash]
[PK__tbFileHa__67EC15CEBA35EE03], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [sys].[plan_persist_context_settings]
[plan_persist_context_settings_cidx], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbProgramKeys]
[PK__tbProgra__998876FC76876942], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbEventRollupCounters]
[PK__tbEventR__3214EC274B4E5455] has been updated…
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevisionSupersedesUpdate]
[PK__tbRevisi__4333258303879077], update is not necessary…
[_WA_Sys_00000002_10566F31] has been updated…
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbComputersThatNeedDetailedRollup]
[cComputersThatNeedDetailedRollup], update is not necessary…
[_WA_Sys_00000002_11D4A34F] has been updated…
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbInstalledUpdateSufficientForPrerequisite]
[PK__tbInstal__C3A1622446A6B8C1], update is not necessary…
[nc1InstalledUpdateSufficientForPrerequisite], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbConfigurationA]
[PK__tbConfig__95AA539B6FE6A126], update is not necessary…
[_WA_Sys_0000000E_12FDD1B2] has been updated…
[_WA_Sys_00000018_12FDD1B2] has been updated…
[_WA_Sys_0000000F_12FDD1B2] has been updated…
[_WA_Sys_00000004_12FDD1B2] has been updated…
4 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbBundleAtLeastOne]
[tbBundleAtLeastOne_PK], update is not necessary…
[nc1BundleAtLeastOne], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbDriverTargetingGroup]
[PK_DriverTargetingGroup_DriverTargetingID], update is not necessary…
[AK_TargetGroupID], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbBundleAll]
[tbBundleAll_PK] has been updated…
[nc1BundleAll] has been updated…
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDriverTargetingGroupPrerequisite]
[PK_DriverTargetingGroupPrerequisite_DriverTargetingID_LocalUpdateID], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbPrerequisite]
[PK__tbPrereq__25A953F9D1826CC2] has been updated…
[nc1Prerequisite] has been updated…
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDriver]
[PK__tbDriver__258B78A91057D0C7], update is not necessary…
[nc1Driver], update is not necessary…
[nc2Driver], update is not necessary…
[_WA_Sys_00000008_19DFD96B] has been updated…
1 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbTargetedDriverHwid]
[PK_tbTargetedDriverHwid_TargetGroupID_LocalUpdateID_HardwareID], update is not necessary…
[IX_LocalUpdateID], update is not necessary…
[_WA_Sys_00000003_1B5E0D89], update is not necessary…
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbCompatiblePrinterProvider]
[PK__tbCompat__DA62685F505D11E7], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbDriverClass]
[PK__tbDriver__CB1927A03C8C1D86], update is not necessary…
[_WA_Sys_00000002_1DB06A4F], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbDriverFeatureScore]
[PK_tbDriverFeatureScore_OperatingSystem_FeatureScore_RevisionID_HardwareID], update is not necessary…
[IX_RevisionID], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbTargetGroup]
[PK__tbTarget__73CAF84D12F8EEA1] has been updated…
[_WA_Sys_00000007_1F98B2C1], update is not necessary…
[_WA_Sys_00000001_1F98B2C1], update is not necessary…
[_WA_Sys_00000006_1F98B2C1], update is not necessary…
[_WA_Sys_00000002_1F98B2C1], update is not necessary…
1 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbDistributionComputerHardwareId]
[PK_tbDistributionComputerHardwareId_DistributionComputerHardwareId_RevisionID_HardwareID], update is not necessary…
[IX_RevisionID], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbConfiguration]
[PK__tbConfig__737584F78BF438A6] has been updated…
[_WA_Sys_00000002_24285DB4] has been updated…
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbFlattenedTargetGroup]
[cFlattenedTargetGroup] has been updated…
[_WA_Sys_00000002_245D67DE], update is not necessary…
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbTargetComputerHardwareId]
[PK_tbTargetComputerHardwareId_TargetComputerHardwareId_RevisionID_HardwareID], update is not necessary…
[IX_RevisionID] has been updated…
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbPrerequisiteDependency]
[PK__tbPrereq__4E62540B2259B2A5], update is not necessary…
[nc1PrerequisiteDependency], update is not necessary…
[nc2PrerequisiteDependency], update is not necessary…
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbImplicitCategory]
[PK__tbImplic__D0AB88605C0E4471] has been updated…
[_WA_Sys_00000002_2610A626] has been updated…
[_WA_Sys_00000003_2610A626] has been updated…
[_WA_Sys_00000004_2610A626], update is not necessary…
3 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbTargetGroupType]
[PK__tbTarget__59800DAA3F5C598F], update is not necessary…
[_WA_Sys_00000002_2739D489], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbBundleDependency]
[PK__tbBundle__40BEE6EB50595A26], update is not necessary…
[nc1BundleDependency], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbExpandedTargetInTargetGroup]
[PK__tbExpand__017B08B6EC872E20], update is not necessary…
[nc1ExpandedTargetInTargetGroup], update is not necessary…
[_WA_Sys_00000003_29221CFB] has been updated…
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbUpdateStatusPerComputer]
[cUpdateStatusPerComputer] has been updated…
[nc3UpdateStatusPerComputer] has been updated…
[nc2UpdateStatusPerComputer] has been updated…
[_WA_Sys_00000005_29572725] has been updated…
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbCategoryInSubscription]
[PK__tbCatego__D0AB886033D05F48] has been updated…
[_WA_Sys_00000001_29E1370A] has been updated…
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbUpdateSummaryForAllComputers]
[PK__tbUpdate__41FBF71B437115EA] has been updated…
[_WA_Sys_00000007_2B3F6F97] has been updated…
[_WA_Sys_00000006_2B3F6F97] has been updated…
[_WA_Sys_00000004_2B3F6F97] has been updated…
[_WA_Sys_00000003_2B3F6F97] has been updated…
[_WA_Sys_00000002_2B3F6F97] has been updated…
[_WA_Sys_00000005_2B3F6F97] has been updated…
7 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbLanguageInSubscription]
[PK__tbLangua__709AE7C06D191881], update is not necessary…
[_WA_Sys_00000001_2BC97F7C], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbTargetInTargetGroup]
[PK__tbTarget__017B08B62CCB0ED6], update is not necessary…
[nc1TargetInTargetGroup], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbEulaProperty]
[tbEulaProperty_PK] has been updated…
[nc1EulaProperty], update is not necessary…
[nc2EulaProperty], update is not necessary…
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbSchedule]
[PK__tbSchedu__0AFEF4FFA9B4F84B] has been updated…
[_WA_Sys_00000002_2EA5EC27], update is not necessary…
[_WA_Sys_00000006_2EA5EC27] has been updated…
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbEulaAcceptance]
[PK__tbEulaAc__51426B64679B5E8B], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbLocalizedProperty]
[PK__tbLocali__ED9531CA12605109] has been updated…
[_WA_Sys_00000004_31B762FC] has been updated…
[_WA_Sys_00000002_31B762FC] has been updated…
[_WA_Sys_00000003_31B762FC] has been updated…
4 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbEmailNotificationRecipient]
[_WA_Sys_00000002_32767D0B], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbComputerSummaryForMicrosoftUpdates]
[PK__tbComput__2B1F0FB6578C2A17] has been updated…
[_WA_Sys_00000007_32E0915F] has been updated…
[_WA_Sys_00000006_32E0915F] has been updated…
[_WA_Sys_00000004_32E0915F] has been updated…
[_WA_Sys_00000003_32E0915F] has been updated…
[_WA_Sys_00000002_32E0915F] has been updated…
6 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevisionInCategory]
[PK__tbRevisi__15217053AF5A8197], update is not necessary…
[nc1RevisionInCategory], update is not necessary…
[_WA_Sys_00000003_336AA144] has been updated…
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbFile]
[PK__tbFile__67EC15CE22F0B68E], update is not necessary…
[_WA_Sys_00000005_339FAB6E] has been updated…
[_WA_Sys_0000000A_339FAB6E] has been updated…
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbCategory]
[PK__tbCatego__19093A2B2AB80EBB] has been updated…
[nc1Category], update is not necessary…
[_WA_Sys_00000003_36470DEF] has been updated…
[_WA_Sys_00000001_36470DEF] has been updated…
3 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbXml]
[PK__tbXml__D14A66A92CE68940] has been updated…
[nc1tbXml] has been updated…
[nc2tbXml], update is not necessary…
[_WA_Sys_00000004_395884C4] has been updated…
3 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbRequestedTargetGroup]
[PK__tbReques__4AC8E77DC26A693B] has been updated…
[AK_Name] has been updated…
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevision]
[PK__tbRevisi__B4B1E3F16E301DBD] has been updated…
[UQ__tbRevisi__FFEE74505DA44DE1], update is not necessary…
[ncRevision_LocalUpdateID_RevisionNumber__IsLatestRevision], update is not necessary…
[_WA_Sys_0000000D_3B0BC30C] has been updated…
[_WA_Sys_00000003_3B0BC30C] has been updated…
[_WA_Sys_00000009_3B0BC30C] has been updated…
[_WA_Sys_00000005_3B0BC30C] has been updated…
[_WA_Sys_0000000C_3B0BC30C] has been updated…
[_WA_Sys_0000000E_3B0BC30C] has been updated…
[_WA_Sys_0000000A_3B0BC30C] has been updated…
8 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbRequestedTargetGroupsForTarget]
[PK__tbReques__EFB381C1A483E882] has been updated…
[nc1RequestedTargetGroupNamesForTarget] has been updated…
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbGroupAuthorization]
[PK__tbGroupA__CD594A31A0A1EA75], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbDeletedComputer]
[cDeletedComputer] has been updated…
[_WA_Sys_00000002_3E52440B], update is not necessary…
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbAuthorization]
[PK__tbAuthor__7C10E501989F4D8E], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbFileOnServer]
[c0FileOnServer], update is not necessary…
[PK__tbFileOn__CEB6B0F6C7814EE5], update is not necessary…
[_WA_Sys_00000005_40F9A68C] has been updated…
[_WA_Sys_00000007_40F9A68C] has been updated…
[_WA_Sys_00000006_40F9A68C] has been updated…
[_WA_Sys_00000004_40F9A68C] has been updated…
4 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbComputerTargetDetail]
[PK__tbComput__2B1F0FB62F2A098B] has been updated…
[_WA_Sys_00000019_412EB0B6] has been updated…
[_WA_Sys_00000018_412EB0B6] has been updated…
[_WA_Sys_00000016_412EB0B6] has been updated…
[_WA_Sys_00000015_412EB0B6] has been updated…
[_WA_Sys_00000014_412EB0B6] has been updated…
[_WA_Sys_00000013_412EB0B6] has been updated…
[_WA_Sys_00000011_412EB0B6] has been updated…
[_WA_Sys_0000000D_412EB0B6] has been updated…
[_WA_Sys_00000007_412EB0B6] has been updated…
[_WA_Sys_00000006_412EB0B6] has been updated…
[_WA_Sys_00000005_412EB0B6] has been updated…
[_WA_Sys_00000004_412EB0B6] has been updated…
[_WA_Sys_00000003_412EB0B6] has been updated…
[_WA_Sys_00000002_412EB0B6] has been updated…
[_WA_Sys_00000012_412EB0B6] has been updated…
16 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbRevisionExtendedLanguageMask]
[PK__tbRevisi__B4B1E3F1D654B4CC], update is not necessary…
[_WA_Sys_00000008_467D75B8], update is not necessary…
[_WA_Sys_00000007_467D75B8], update is not necessary…
[_WA_Sys_00000006_467D75B8], update is not necessary…
[_WA_Sys_00000005_467D75B8], update is not necessary…
[_WA_Sys_00000004_467D75B8], update is not necessary…
[_WA_Sys_00000003_467D75B8], update is not necessary…
[_WA_Sys_00000002_467D75B8], 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__tbFileDo__FFEE7450646AF6B0], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbSingletonData]
[PK__tbSingle__3214EC271E8D720D] has been updated…
[_WA_Sys_00000004_489AC854] has been updated…
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbInventoryRule]
[PK__tbInvent__110458C27E00BE95] has been updated…
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbInventoryClass]
[PK__tbInvent__CB1927A0D2414B9F] has been updated…
[UQ__tbInvent__737584F6530A1416], update is not necessary…
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbComputerTarget]
[PK__tbComput__2B1F0FB6AF431FFF] has been updated…
[UQ__tbComput__A6BE3C55B28EB30E] has been updated…
[nc1ComputerTarget] has been updated…
[nc4ComputerTarget], update is not necessary…
[nc5ComputerTarget] has been updated…
[nc_EffectiveLastDetectionTime], update is not necessary…
[ncComputerTarget_FullDomainName] has been updated…
[_WA_Sys_00000004_4CA06362] has been updated…
[_WA_Sys_0000000E_4CA06362] has been updated…
[_WA_Sys_00000006_4CA06362] has been updated…
8 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbReference]
[_WA_Sys_00000003_4D5F7D71], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbInventoryProperty]
[PK__tbInvent__70C9A755BF901251] has been updated…
[nc_ClassID_Name], update is not necessary…
[_WA_Sys_00000004_4E0988E7], update is not necessary…
[_WA_Sys_00000003_4E0988E7], update is not necessary…
1 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbUpdate]
[PK__tbUpdate__41FBF71BABCFDA07] has been updated…
[UQ__tbUpdate__7A0CF324C4CE45ED], update is not necessary…
[nc1UpdateBooleanProperties] has been updated…
[_WA_Sys_00000007_4F12BBB9] has been updated…
[_WA_Sys_00000003_4F12BBB9] has been updated…
[_WA_Sys_00000009_4F12BBB9] has been updated…
[_WA_Sys_00000008_4F12BBB9] has been updated…
[_WA_Sys_00000006_4F12BBB9] has been updated…
[_WA_Sys_0000000C_4F12BBB9] has been updated…
[_WA_Sys_0000000A_4F12BBB9] has been updated…
9 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbInventoryXml]
[PK__tbInvent__2B1F0FB6FB655E45], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbFrontEndServersHealth]
[_WA_Sys_00000002_51300E55], update is not necessary…
[_WA_Sys_00000001_51300E55], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbClientWithRecentNameChange]
[c0ClientWithRecentNameChange] has been updated…
[nc1ClientWithRecentNameChange] has been updated…
[nc2ClientWithRecentNameChange] has been updated…
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbDownstreamServerTarget]
[PK__tbDownst__2B1F0FB6C66CBDA2], update is not necessary…
[ncDownstreamServerTarget_AccountServerID], update is not necessary…
[_WA_Sys_00000003_52593CB8], update is not necessary…
[_WA_Sys_00000008_52593CB8], update is not necessary…
0 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbInventoryClassInstance]
[PK__tbInvent__7B875D378A76BC62], 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].[tbConfigurationC]
[PK__tbConfig__95AA539B5F404C9D] has been updated…
[_WA_Sys_00000007_531856C7] has been updated…
[_WA_Sys_00000006_531856C7] has been updated…
[_WA_Sys_00000010_531856C7] has been updated…
[_WA_Sys_00000013_531856C7], update is not necessary…
4 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbInventoryPropertyInstance]
[PK__tbInvent__3C8BC7424D4DDAB6], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbDownstreamServerSummaryRollup]
[PK__tbDownst__2B1F0FB6840FA8D3], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbUpdateType]
[PK__tbUpdate__C6E976513C143C88], update is not necessary…
[_WA_Sys_00000002_56B3DD81], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbDownstreamServerClientSummaryRollup]
[PK__tbDownst__BB6E14AEA24B5A36] has been updated…
[_WA_Sys_0000000E_571DF1D5] has been updated…
[_WA_Sys_0000000D_571DF1D5] has been updated…
[_WA_Sys_0000000C_571DF1D5] has been updated…
[_WA_Sys_0000000B_571DF1D5] has been updated…
[_WA_Sys_00000009_571DF1D5] has been updated…
[_WA_Sys_00000008_571DF1D5] has been updated…
[_WA_Sys_00000007_571DF1D5] has been updated…
[_WA_Sys_00000006_571DF1D5] has been updated…
[_WA_Sys_00000005_571DF1D5] has been updated…
[_WA_Sys_00000004_571DF1D5] has been updated…
[_WA_Sys_00000003_571DF1D5] has been updated…
[_WA_Sys_00000001_571DF1D5] has been updated…
13 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbUpdateFlag]
[PK__tbUpdate__41FBF71BDB4B740D] has been updated…
[_WA_Sys_00000002_589C25F3] has been updated…
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbHandler]
[PK__tbHandle__9E0BC726AAE4466E] has been updated…
[_WA_Sys_00000002_5A846E65], update is not necessary…
[_WA_Sys_00000003_5A846E65], update is not necessary…
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbLanguage]
[PK__tbLangua__B938558B9AC226DD] has been updated…
[nc1Language], update is not necessary…
[_WA_Sys_00000006_5C6CB6D7], update is not necessary…
[_WA_Sys_00000008_5C6CB6D7], update is not necessary…
1 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbDownstreamServerClientActivityRollup]
[PK__tbDownst__2C79B11A98CD4CE3] has been updated…
[_WA_Sys_00000003_5CD6CB2B] has been updated…
[_WA_Sys_00000002_5CD6CB2B] has been updated…
3 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbTarget]
[PK__tbTarget__2B1F0FB60BB31BD4], update is not necessary…
[nc1Target], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbTargetType]
[PK__tbTarget__B3CB14E1F7BEC913] has been updated…
1 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [dbo].[tbCategoryType]
[PK__tbCatego__0BDC1A59A6ED6486], 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__tbDeploy__5EF8D7168D76D15E] has been updated…
[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_6383C8BA] has been updated…
[_WA_Sys_0000000F_6383C8BA] has been updated…
[_WA_Sys_00000008_6383C8BA] has been updated…
[_WA_Sys_00000002_6383C8BA] has been updated…
[_WA_Sys_00000011_6383C8BA] has been updated…
[_WA_Sys_00000010_6383C8BA] has been updated…
[_WA_Sys_00000004_6383C8BA] has been updated…
[_WA_Sys_00000013_6383C8BA] has been updated…
[_WA_Sys_0000000C_6383C8BA] has been updated…
[_WA_Sys_0000000A_6383C8BA] has been updated…
[_WA_Sys_00000006_6383C8BA] has been updated…
13 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbStateMachine]
[PK__tbStateM__C1BCE470C336BEFA], update is not necessary…
[nc1StateMachine], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbStateMachineState]
[PK__tbStateM__CFFF1AAC3E92B11A], update is not necessary…
[nc1StateMachineState], update is not necessary…
[stateNameUniqueForStateMachineID], update is not necessary…
[_WA_Sys_00000002_65F62111], update is not necessary…
0 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbStateMachineEvent]
[PK__tbStateM__6450F59EDC46160E], update is not necessary…
[nc1StateMachineEvent], update is not necessary…
[eventNameUniqueForStateMachineID], update is not necessary…
[_WA_Sys_00000002_68D28DBC], update is not necessary…
0 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbStateMachineTransition]
[PK__tbStateM__BE865E646E24342D], update is not necessary…
[_WA_Sys_00000003_6BAEFA67], update is not necessary…
[_WA_Sys_00000002_6BAEFA67], update is not necessary…
[_WA_Sys_00000004_6BAEFA67], update is not necessary…
0 index(es)/statistic(s) have been updated, 4 did not require update.
Updating [dbo].[tbStateMachineEventTransitionLog]
[PK__tbStateM__F57BD2D7B31942C0], update is not necessary…
[_WA_Sys_00000007_6D9742D9], update is not necessary…
[_WA_Sys_00000006_6D9742D9], update is not necessary…
[_WA_Sys_00000005_6D9742D9], update is not necessary…
[_WA_Sys_00000003_6D9742D9], update is not necessary…
[_WA_Sys_00000002_6D9742D9], update is not necessary…
0 index(es)/statistic(s) have been updated, 6 did not require update.
Updating [dbo].[tbNotificationEvent]
[PK__tbNotifi__2BA9DFBCF7B7A053], update is not necessary…
[_WA_Sys_00000004_7167D3BD], update is not necessary…
[_WA_Sys_00000003_7167D3BD] has been updated…
[_WA_Sys_00000002_7167D3BD], update is not necessary…
1 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbDeadDeployment]
[PK__tbDeadDe__5EF8D717A7C9E041], update is not necessary…
[nc1DeadDeployment], update is not necessary…
[nc2DeadDeployment], update is not necessary…
[nc3DeadDeployment] has been updated…
[_WA_Sys_00000012_71D1E811] has been updated…
[_WA_Sys_0000000F_71D1E811] has been updated…
[_WA_Sys_0000000D_71D1E811] has been updated…
[_WA_Sys_0000000C_71D1E811] has been updated…
[_WA_Sys_00000003_71D1E811] has been updated…
6 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbChangeTracking]
[c0ChangeTracking], update is not necessary…
[PK__tbChange__DD60B2101F76BE63] has been updated…
1 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbDynamicCategory]
[PK_DynamicCategory], update is not necessary…
[Unique_DynamicCategory_Name_Type], update is not necessary…
[IX_dbDynamicInventoryItem_Name], update is not necessary…
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbFlattenedRevisionInCategory]
[PK__tbFlatte__152170531F10F32F], update is not necessary…
[nc1FlattenedRevisionInCategory], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [sys].[queue_messages_1977058079]
[queue_clustered_index], update is not necessary…
[queue_secondary_index], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbServerSyncResult]
[PK__tbServer__54173E1B10FEBD02], update is not necessary…
[nc1ServerSyncResult], update is not necessary…
[nc2tbServerSyncResult], update is not necessary…
0 index(es)/statistic(s) have been updated, 3 did not require update.
Updating [dbo].[tbEventMessageTemplate]
[PK__tbEventM__24626EC313DE5327], update is not necessary…
[_WA_Sys_00000003_7775B2CE], update is not necessary…
[_WA_Sys_00000002_7775B2CE] has been updated…
1 index(es)/statistic(s) have been updated, 2 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].[tbPreComputedLocalizedProperty]
[PK__tbPreCom__5FF1DDB6B93642F9] has been updated…
[nc1PreComputedLocalizedProperty], update is not necessary…
[ncPreComputedLocalizedProperty_RevisionID_ShortLanguage] has been updated…
[_WA_Sys_00000002_7908F585] has been updated…
[_WA_Sys_00000005_7908F585] has been updated…
[_WA_Sys_00000004_7908F585] has been updated…
[_WA_Sys_00000003_7908F585] has been updated…
6 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbEventInstance]
[PK__tbEventI__94C75A07EDACEB28], 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_795DFB40] has been updated…
[_WA_Sys_00000002_795DFB40] has been updated…
[_WA_Sys_00000005_795DFB40] has been updated…
[_WA_Sys_00000004_795DFB40] has been updated…
4 index(es)/statistic(s) have been updated, 6 did not require update.
Updating [dbo].[tbRevisionLanguage]
[PK__tbRevisi__1F2266A9267FE531], update is not necessary…
[nc1RevisionLanguage], update is not necessary…
[_WA_Sys_00000003_797309D9] has been updated…
1 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbConfigurationB]
[PK__tbConfig__95AA539B7095AC47] has been updated…
[_WA_Sys_00000003_7A3223E8] has been updated…
[_WA_Sys_00000002_7A3223E8] has been updated…
3 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].[tbPrecomputedCategoryLocalizedProperty]
[PK__tbPrecom__2DD8E6FD2944FFFA] has been updated…
[_WA_Sys_00000002_7AF13DF7] has been updated…
2 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [sys].[filestream_tombstone_2073058421]
[FSTSClusIdx], update is not necessary…
[FSTSNCIdx], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbEvent]
[PK__tbEvent__24626EC372C56C94] has been updated…
[_WA_Sys_00000002_7C3A67EB] has been updated…
[_WA_Sys_00000004_7C3A67EB], update is not necessary…
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbProperty]
[PK__tbProper__B4B1E3F17DCC3DA2] has been updated…
[nc1Property] has been updated…
[nc2Property] has been updated…
[_WA_Sys_00000005_7C4F7684] has been updated…
[_WA_Sys_00000006_7C4F7684] has been updated…
[_WA_Sys_0000000B_7C4F7684] has been updated…
[_WA_Sys_00000013_7C4F7684] has been updated…
[_WA_Sys_00000002_7C4F7684] has been updated…
[_WA_Sys_00000015_7C4F7684] has been updated…
[_WA_Sys_00000012_7C4F7684] has been updated…
[_WA_Sys_00000004_7C4F7684] has been updated…
[_WA_Sys_00000003_7C4F7684] has been updated…
12 index(es)/statistic(s) have been updated, 0 did not require update.
Updating [sys].[syscommittab]
[ci_commit_ts], update is not necessary…
[si_xdes_id], update is not necessary…
0 index(es)/statistic(s) have been updated, 2 did not require update.
Updating [dbo].[tbMapping_Target_DynamicCategory]
[PK__tbMappin__90B4D91DC468146D], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbAutoDeploymentRule]
[PK__tbAutoDe__3214EC27FB99FF98], update is not necessary…
[_WA_Sys_00000002_7CD98669] has been updated…
[_WA_Sys_00000003_7CD98669] has been updated…
2 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [sys].[filetable_updates_2105058535]
[FFtUpdateIdx], update is not necessary…
0 index(es)/statistic(s) have been updated, 1 did not require update.
Updating [dbo].[tbEventSource]
[PK__tbEventS__DF51BBD6DB0CB83D] has been updated…
[_WA_Sys_00000002_7F16D496] has been updated…
2 index(es)/statistic(s) have been updated, 0 did not require update.
Statistics for all tables have been updated.
Done updating statistics.2018-07-06 09:54:52.173
0 Comments