Resolving Very Large MSDB

The following is the a walk-through guide towards how I resolved a problem with a MSDB that went wild.  I strongly recommend never shrinking database files.  I am not alone on this.  If you need more reasons check here (If you don’t like that example see the ones used in that post).

Unfortunately I am in a situation where I didn’t have another option.  We didn’t have a process on a server to delete records from the tables used to log SQL Server Agent job information. This database server in particular has over 400 databases and hourly transactional logs and a full backup.  This alone will create 10,000 rows daily when logging the results.  We actually reached the point where the data drive free space was consumed.

Backup MSDB

First, step is to do a full backup of MSDB.  You should always make a backup before you plan on doing any changes with a system database.  You should also have a plan to restore the system database just in case you have to implement it.

So Where’s the Beef?

Next, I needed to know why this database was so huge.  I ran the following query to see the file size of all database objects within the MSDB database. You can find this query written by Jeremy Kadlec in MSSQLTIP #1461 I also highly recommend reading that tip as it will provide some more helpful information to troubleshoot a large MSDB.

[sourcecode language=”sql”]
SELECT object_name(i.object_id) as objectName,

i.[name] as indexName,
Sum(a.total_pages) as totalPages,

sum(a.used_pages) as usedPages,

sum(a.data_pages) as dataPages,

(sum(a.total_pages) * 8 ) / 1024 as totalSpaceMB,

(sum ( a.used_pages) * 8 ) / 1024 as usedSpaceMB,

(sum(a.data_pages) * 8 ) / 1024 as dataSpaceMB

FROM sys.indexes i

INNER JOIN sys.partitions p

ON i.object_id = p.object_id

AND i.index_id = p.index_id

INNER JOIN sys.allocation_units a

ON p.partition_id = a.container_id

GROUP BY i.object_id, i.index_id, i.[name]

ORDER BY sum(a.total_pages) DESC, object_name(i.object_id)

GO
[/sourcecode]

Dam you sysmaintplan_logdetail

Okay, we tried to using sp_maintplan_delete_log and it failed because the transaction log grew and consumed all the space on the drive for transactional log files.  We are not allowed to take the SQL Server database engine offline so we go with the next best option truncate the tables in question and shrink the database.

Yes I know……  I said shrink the database.  I actually had to slap myself  after typing this.

I found this great post on msdn that walks you through the script to truncate the sysmaintplan_logdetail table.

[sourcecode language=”sql”]

ALTER TABLE [dbo].[sysmaintplan_log] DROP CONSTRAINT [FK_sysmaintplan_log_subplan_id];

ALTER TABLE [dbo].[sysmaintplan_logdetail] DROP CONSTRAINT [FK_sysmaintplan_log_detail_task_id];

truncate table msdb.dbo.sysmaintplan_logdetail;

truncate table msdb.dbo.sysmaintplan_log;

ALTER TABLE [dbo].[sysmaintplan_log] WITH CHECK ADD CONSTRAINT [FK_sysmaintplan_log_subplan_id] FOREIGN KEY([subplan_id])

REFERENCES [dbo].[sysmaintplan_subplans] ([subplan_id]);

ALTER TABLE [dbo].[sysmaintplan_logdetail] WITH CHECK ADD CONSTRAINT [FK_sysmaintplan_log_detail_task_id] FOREIGN KEY([task_detail_id])

REFERENCES [dbo].[sysmaintplan_log] ([task_detail_id]) ON DELETE CASCADE;

[/sourcecode]

Shrink MSDB

Now I know you followed the first step and backed up your MSDB.  Once again you should never consider truncating or shrinking data if you don’t have a working backup that can be restored.

Okay now that we are done with the disclaimer I created the following script to truncate the log and data files.

[sourcecode language="sql"]

--- SHRINK THE MSDB LOG FILE

USE MSDB

GO

DBCC SHRINKFILE(MSDBLog, 512)

GO

 

-- SHRINK THE MSDB Data File

USE MSDB

GO

DBCC SHRINKFILE(MSDBData, 1024)

GO

[/sourcecode]


Rebuild Indexes

Now that you did the nasty and shrinked the database data file you need to rebuild your indexes and update your statistics.   You can find the scripts to do this below.

[sourcecode language=”sql”]

— REBUILD ALL INDEXES

USE MSDB

GO

EXEC sp_MSforeachtable @command1="print ‘?’ DBCC DBREINDEX (‘?’, ‘ ‘, 80)"

GO

— UPDATE STATISTICS

EXEC sp_updatestats

EXEC sp_helpdb @dbname= ‘MSDB’

[/sourcecode]

How do we prevent this from reoccurring?

Well actually there are quite a few things that could have and should have been done.  We could create a maintenance plan to clean up the SQL Agent history, we can also specify in the agent’s properties to also clean up history.  I will show you how to do both below.

The following is the maintenance task that will help cleanup the agent history tables.

Cleanup History

You can also right click on the SQL Server Agent in SSMS and select properties.  Once the properties window comes up select History on the list on the left.  You will then be able to remove data by record size or date.

AgentCleanHistory

  • filipe

    Hi, I execute the select and the answer was
    I work with DB for the past 6 years and I never see this repent

    queue_messages_1824725553 queue_clustered_index 2669190 2668853 2633737 20853 20850 20576
    queue_messages_1824725553 queue_secondary_index 48646 48635 47944 380 379 374
    sysssispackages NULL 379 376 1 2 2 0
    sysobjvalues clst 332 318 255 2 2 1
    syscolpars clst 73 68 66 0 0 0
    syscolpars nc 39 28 26 0 0 0
    sysmultiobjrefs clst 33 26 24 0 0 0
    sysobjkeycrypts cl 33 32 30 0 0 0
    sysrscols clst 25 21 19 0 0 0
    sysschobjs clst 25 19 17 0 0 0
    sysxmitqueue clst 23 9 1 0 0 0
    sysidxstats clst 17 10 8 0 0 0
    sysmultiobjrefs nc1 17 15 13 0 0 0
    sysschobjs nc1 17 10 8 0 0 0
    sysschobjs nc2 17 11 9 0 0 0
    sysiscols clst 8 8 6 0 0 0
    sysallocunits clust 7 7 5 0 0 0
    syscollector_collection_items_internal PK_syscollector_collection_items_internal 7 7 2 0 0 0
    sysidxstats nc 7 7 5 0 0 0
    MSdbms_map pk_MSdbms_map 6 6 4 0 0 0
    sysrowsets clust 6 6 4 0 0 0
    MSdbms_datatype_mapping pk_MSdbms_datatype_mapping 5 5 3 0 0 0
    sysdercv cl 5 5 3 0 0 0
    sysprivs clust 5 5 3 0 0 0
    syssingleobjrefs clst 5 5 3 0 0 0
    backupfile PK__backupfi__57D1800A17C286CF 4 4 2 0 0 0
    MSdbms_datatype pk_MSdbms_datatype 4 4 2 0 0 0
    sysallocunits nc 4 4 2 0 0 0
    sysiscols nc1 4 4 2 0 0 0
    sysschobjs nc3 4 4 2 0 0 0
    syssingleobjrefs nc1 4 4 2 0 0 0
    restorefile NULL 3 3 2 0 0 0
    restorefilegroup NULL 3 3 2 0 0 0
    backupfilegroup PK__backupfi__760CD67A12FDD1B2 2 2 1 0 0 0
    backupmediafamily PK__backupme__0C13C86F0880433F 2 2 1 0 0 0
    backupmediafamily backupmediafamilyuuid 2 2 1 0 0 0
    backupmediaset backupmediasetuuid 2 2 1 0 0 0
    backupmediaset PK__backupme__DAC69E4D04AFB25B 2 2 1 0 0 0
    backupset PK__backupse__21F79AAB0E391C95 2 2 1 0 0 0
    backupset backupsetuuid 2 2 1 0 0 0
    backupset backupsetDate 2 2 1 0 0 0
    MSdbms pk_MSdbms 2 2 1 0 0 0
    restorehistory PK__restoreh__FDC4B0311C873BEC 2 2 1 0 0 0
    restorehistory restorehistorybackupset 2 2 1 0 0 0
    sysbinobjs nc1 2 2 1 0 0 0
    sysbinobjs clst 2 2 1 0 0 0
    sysbinsubobjs clst 2 2 1 0 0 0
    sysbinsubobjs nc1 2 2 1 0 0 0
    syscachedcredentials PK__syscache__F6D56B564CA06362 2 2 1 0 0 0
    syscategories clust 2 2 1 0 0 0
    syscerts cl 2 2 1 0 0 0
    syscerts nc1 2 2 1 0 0 0
    syscerts nc3 2 2 1 0 0 0
    syscerts nc2 2 2 1 0 0 0
    sysclsobjs nc 2 2 1 0 0 0
    sysclsobjs clst 2 2 1 0 0 0
    syscollector_collection_items_internal UQ_syscollector_collection_items_internal_name 2 2 1 0 0 0
    syscollector_collection_sets_internal UQ_syscollector_collection_sets_internal_name 2 2 1 0 0 0
    syscollector_collection_sets_internal PK_syscollector_collection_sets_internal 2 2 1 0 0 0
    syscollector_collector_types_internal PK_syscollector_collector_types_internal 2 2 1 0 0 0
    syscollector_collector_types_internal UQ_syscollector_collection_types_internal_name 2 2 1 0 0 0
    syscollector_config_store_internal PK_syscollector_config_store_internal_paremeter_name 2 2 1 0 0 0
    sysconvgroup clst 2 2 1 0 0 0
    sysdbmaintplans PK__sysdbmai__BE9F8F1D7132C993 2 2 1 0 0 0
    sysdesend cl 2 2 1 0 0 0
    sysdtscategories pk_dtscategories 2 2 1 0 0 0
    sysdtscategories uq_dtscategories_name_parent 2 2 1 0 0 0
    sysfgfrag cl 2 2 1 0 0 0
    sysfiles1 NULL 2 2 1 0 0 0
    sysjobactivity clust 2 2 1 0 0 0
    sysjobhistory clust 2 2 1 0 0 0
    sysjobhistory nc1 2 2 1 0 0 0
    sysjobs nc1 2 2 1 0 0 0
    sysjobs nc4 2 2 1 0 0 0
    sysjobs nc3 2 2 1 0 0 0
    sysjobs clust 2 2 1 0 0 0
    sysjobschedules clust 2 2 1 0 0 0
    sysjobschedules NC_sysjobschedules_schedule_id 2 2 1 0 0 0
    sysjobservers nc1 2 2 1 0 0 0
    sysjobservers clust 2 2 1 0 0 0
    sysjobsteps clust 2 2 1 0 0 0
    sysjobsteps nc1 2 2 1 0 0 0
    sysjobsteps nc2 2 2 1 0 0 0
    sysmail_configuration SYSMAIL_CONFIGURATION_ParamnameMustBeUnique 2 2 1 0 0 0
    sysmail_servertype SYSMAIL_SERVERTYPE_TypeMustBeUnique 2 2 1 0 0 0
    sysmanagement_shared_server_groups_internal UQ_sysmanagement_unique_group_name_per_parent 2 2 1 0 0 0
    sysmanagement_shared_server_groups_internal PK__sysmanag__752ABCF92942188C 2 2 1 0 0 0
    sysmanagement_shared_server_groups_internal IX_sysmanagement_shared_server_groups_name 2 2 1 0 0 0
    sysmanagement_shared_server_groups_internal IX_sysmanagement_shared_server_groups_clustParentGroupID 2 2 1 0 0 0
    sysnsobjs clst 2 2 1 0 0 0
    sysnsobjs nc 2 2 1 0 0 0
    sysowners nc1 2 2 1 0 0 0
    sysowners nc2 2 2 1 0 0 0
    sysowners clst 2 2 1 0 0 0
    sysphfg cl 2 2 1 0 0 0
    syspolicy_configuration_internal PK__syspolic__72E12F1A42CCE065 2 2 1 0 0 0
    syspolicy_facet_events IX_facet_events_target_type_alias 2 2 1 0 0 0
    syspolicy_facet_events UX_facet_events 2 2 1 0 0 0
    syspolicy_management_facets PK__syspolic__66936FB44119A21D 2 2 1 0 0 0
    sysprufiles clst 2 2 1 0 0 0
    sysqnames clst 2 2 1 0 0 0
    sysqnames nc1 2 2 1 0 0 0
    sysrts nc1 2 2 1 0 0 0
    sysrts nc2 2 2 1 0 0 0
    sysrts clst 2 2 1 0 0 0
    sysscalartypes clst 2 2 1 0 0 0
    sysscalartypes nc2 2 2 1 0 0 0
    sysscalartypes nc1 2 2 1 0 0 0
    sysschedules PK__syssched__C46A8A6F2A4B4B5E 2 2 1 0 0 0
    syssessions PK__syssessi__69B13FDC1BFD2C07 2 2 1 0 0 0
    syssessions nonclust 2 2 1 0 0 0
    sysssispackagefolders U_sysssispackagefoldersuniquepath 2 2 1 0 0 0
    sysssispackagefolders PK_sysssispackagefolders 2 2 1 0 0 0
    sysssispackagefolders NULL 2 2 1 0 0 0
    sysssispackages pk_sysssispackages 2 2 1 0 0 0
    syssubsystems nc1 2 2 1 0 0 0
    syssubsystems clust 2 2 1 0 0 0
    sysxmlcomponent cl 2 2 1 0 0 0
    sysxmlcomponent nc1 2 2 1 0 0 0
    sysxmlfacet cl 2 2 1 0 0 0
    sysxmlplacement cl 2 2 1 0 0 0
    sysxmlplacement nc1 2 2 1 0 0 0
    filestream_tombstone_2073058421 FSTSClusIdx 0 0 0 0 0 0
    filestream_tombstone_2073058421 FSTSNCIdx 0 0 0 0 0 0
    log_shipping_monitor_alert PK__log_ship__BD57EA5768F2894D 0 0 0 0 0 0
    log_shipping_monitor_error_detail nc2lsmonitor_error_detail 0 0 0 0 0 0
    log_shipping_monitor_error_detail nc3lsmonitor_error_detail 0 0 0 0 0 0
    log_shipping_monitor_error_detail c1lsmonitor_error_detail 0 0 0 0 0 0
    log_shipping_monitor_history_detail c1lsmonitor_history_detail 0 0 0 0 0 0
    log_shipping_monitor_history_detail nc3lsmonitor_history_detail 0 0 0 0 0 0
    log_shipping_monitor_history_detail nc2lsmonitor_history_detail 0 0 0 0 0 0
    log_shipping_monitor_primary uc1lsmonitor_primary 0 0 0 0 0 0
    log_shipping_monitor_primary PK__log_ship__ED3BE11159B045BD 0 0 0 0 0 0
    log_shipping_monitor_secondary pklsmonitor_secondary 0 0 0 0 0 0
    log_shipping_monitor_secondary uc1lsmonitor_secondary 0 0 0 0 0 0
    log_shipping_monitor_secondary nc2lsmonitor_secondary 0 0 0 0 0 0
    log_shipping_monitor_secondary nc1lsmonitor_secondary 0 0 0 0 0 0
    log_shipping_monitor_secondary nc3lsmonitor_secondary 0 0 0 0 0 0
    log_shipping_primaries PK__log_ship__ED3BE1111758727B 0 0 0 0 0 0
    log_shipping_primary_databases PK__log_ship__ED3BE1115026DB83 0 0 0 0 0 0
    log_shipping_primary_databases nc2lsprimary_databases 0 0 0 0 0 0
    log_shipping_primary_databases nc1lsprimary_databases 0 0 0 0 0 0
    log_shipping_primary_databases uc1lsprimary_databases 0 0 0 0 0 0
    log_shipping_primary_databases UQ__log_ship__2A5EF6DC5303482E 0 0 0 0 0 0
    log_shipping_primary_secondaries nc1lsprimary_secondaries 0 0 0 0 0 0
    log_shipping_primary_secondaries pklsprimary_secondaries 0 0 0 0 0 0
    log_shipping_secondaries NULL 0 0 0 0 0 0
    log_shipping_secondary PK__log_ship__DB57D5B25F691F13 0 0 0 0 0 0
    log_shipping_secondary uc1lssecondary 0 0 0 0 0 0
    log_shipping_secondary nc1lssecondary 0 0 0 0 0 0
    log_shipping_secondary nc2lssecondary 0 0 0 0 0 0
    log_shipping_secondary_databases nc1lssecondary_databases 0 0 0 0 0 0
    log_shipping_secondary_databases PK__log_ship__093E1AB56339AFF7 0 0 0 0 0 0
    logmarkhistory NULL 0 0 0 0 0 0
    logmarkhistory logmarkhistory2 0 0 0 0 0 0
    logmarkhistory logmarkhistory1 0 0 0 0 0 0
    queue_messages_1040722760 queue_secondary_index 0 0 0 0 0 0
    queue_messages_1040722760 queue_clustered_index 0 0 0 0 0 0
    queue_messages_1627152842 queue_clustered_index 0 0 0 0 0 0
    queue_messages_1627152842 queue_secondary_index 0 0 0 0 0 0
    queue_messages_1659152956 queue_secondary_index 0 0 0 0 0 0
    queue_messages_1659152956 queue_clustered_index 0 0 0 0 0 0
    queue_messages_1977058079 queue_secondary_index 0 0 0 0 0 0
    queue_messages_1977058079 queue_clustered_index 0 0 0 0 0 0
    queue_messages_2009058193 queue_clustered_index 0 0 0 0 0 0
    queue_messages_2009058193 queue_secondary_index 0 0 0 0 0 0
    queue_messages_2041058307 queue_secondary_index 0 0 0 0 0 0
    queue_messages_2041058307 queue_clustered_index 0 0 0 0 0 0
    sqlagent_info NULL 0 0 0 0 0 0
    suspect_pages NULL 0 0 0 0 0 0
    sysalerts ByName 0 0 0 0 0 0
    sysalerts ByID 0 0 0 0 0 0
    sysasymkeys nc3 0 0 0 0 0 0
    sysasymkeys nc1 0 0 0 0 0 0
    sysasymkeys cl 0 0 0 0 0 0
    sysaudacts clust 0 0 0 0 0 0
    syscollector_blobs_internal PK_syscollector_blobs_internal_paremeter_name 0 0 0 0 0 0
    syscollector_execution_log_internal PK_syscollector_execution_log 0 0 0 0 0 0
    syscollector_execution_stats_internal PK_syscollector_execution_stats 0 0 0 0 0 0
    syscollector_tsql_query_collector NULL 0 0 0 0 0 0
    syscommittab ci_commit_ts 0 0 0 0 0 0
    syscommittab si_xdes_id 0 0 0 0 0 0
    syscompfragments clst 0 0 0 0 0 0
    sysdbmaintplan_databases UQ__sysdbmai__AEEEF1DB7E8CC4B1 0 0 0 0 0 0
    sysdbmaintplan_history UQ__sysdbmai__B2649B25035179CE 0 0 0 0 0 0
    sysdbmaintplan_history clust 0 0 0 0 0 0
    sysdbmaintplan_jobs UQ__sysdbmai__F87CA47779C80F94 0 0 0 0 0 0
    sysdownloadlist nc1 0 0 0 0 0 0
    sysdownloadlist nc2 0 0 0 0 0 0
    sysdownloadlist clust 0 0 0 0 0 0
    sysdtspackagelog PK__sysdtspa__5C158ECB3EDC53F0 0 0 0 0 0 0
    sysdtspackages pk_dtspackages 0 0 0 0 0 0
    sysdtspackages UQ__sysdtspa__E77790D92CBDA3B5 0 0 0 0 0 0
    sysdtssteplog PK__sysdtsst__58E1496643A1090D 0 0 0 0 0 0
    sysdtstasklog PK__sysdtsta__FDDFDAA74865BE2A 0 0 0 0 0 0
    sysftinds clst 0 0 0 0 0 0
    sysftstops clst 0 0 0 0 0 0
    sysguidrefs cl 0 0 0 0 0 0
    sysguidrefs nc 0 0 0 0 0 0
    sysjobstepslogs PK__sysjobst__9E2397E0239E4DCF 0 0 0 0 0 0
    sysmail_account SYSMAIL_ACCOUNT_IDMustBeUnique 0 0 0 0 0 0
    sysmail_account SYSMAIL_ACCOUNT_NameMustBeUnique 0 0 0 0 0 0
    sysmail_attachments NULL 0 0 0 0 0 0
    sysmail_attachments_transfer PK__sysmail___78E6FD3327C3E46E 0 0 0 0 0 0
    sysmail_log sysmail_log_id_MustBeUnique 0 0 0 0 0 0
    sysmail_mailitems sysmail_mailitems_id_MustBeUnique 0 0 0 0 0 0
    sysmail_principalprofile SYSMAIL_PRINCIPALPROFILE_ProfilePrincipalMustBeUnique 0 0 0 0 0 0
    sysmail_profile SYSMAIL_PROFILE_IDMustBeUnique 0 0 0 0 0 0
    sysmail_profile SYSMAIL_PROFILE_NameMustBeUnique 0 0 0 0 0 0
    sysmail_profileaccount SYSMAIL_ACCOUNT_ProfileAccountMustBeUnique 0 0 0 0 0 0
    sysmail_query_transfer PK__sysmail___DD70126422FF2F51 0 0 0 0 0 0
    sysmail_send_retries PK__sysmail___C010B7E115A53433 0 0 0 0 0 0
    sysmail_server SYSMAIL_ACCOUNT_AccountServerTypeMustBeUnique 0 0 0 0 0 0
    sysmaintplan_log PK_sysmaintplan_taskdetail_id 0 0 0 0 0 0
    sysmaintplan_logdetail NULL 0 0 0 0 0 0
    sysmaintplan_subplans PK_sysmaintplan_subplan 0 0 0 0 0 0
    sysmanagement_shared_registered_servers_internal IX_sysmanagement_shared_registered_servers_clustGroupID 0 0 0 0 0 0
    sysmanagement_shared_registered_servers_internal UQ_sysmanagement_unique_server_name_per_group 0 0 0 0 0 0
    sysmanagement_shared_registered_servers_internal PK__sysmanag__ED5B5C592FEF161B 0 0 0 0 0 0
    sysmanagement_shared_registered_servers_internal IX_sysmanagement_shared_registered_servers_name 0 0 0 0 0 0
    sysnotifications ByAlertIDAndOperatorID 0 0 0 0 0 0
    sysoperators ByName 0 0 0 0 0 0
    sysoperators ByID 0 0 0 0 0 0
    sysoriginatingservers UQ__sysorigi__57F15AAC0EA330E9 0 0 0 0 0 0
    sysoriginatingservers UQ__sysorigi__D65E569C0BC6C43E 0 0 0 0 0 0
    syspolicy_conditions_internal PK_syspolicy_conditions 0 0 0 0 0 0
    syspolicy_conditions_internal UQ_syspolicy_conditions_name 0 0 0 0 0 0
    syspolicy_execution_internal NULL 0 0 0 0 0 0
    syspolicy_object_sets_internal PK_syspolicy_object_sets 0 0 0 0 0 0
    syspolicy_object_sets_internal UQ_syspolicy_object_sets_name 0 0 0 0 0 0
    syspolicy_policies_internal UQ_syspolicy_policies_name 0 0 0 0 0 0
    syspolicy_policies_internal PK_syspolicy_policies 0 0 0 0 0 0
    syspolicy_policy_categories_internal PK_syspolicy_policy_categories 0 0 0 0 0 0
    syspolicy_policy_categories_internal UQ_syspolicy_policy_categories_name 0 0 0 0 0 0
    syspolicy_policy_category_subscriptions_internal UX_syspolicy_policy_category_subscriptions 0 0 0 0 0 0
    syspolicy_policy_category_subscriptions_internal PK_syspolicy_policy_category_subscriptions 0 0 0 0 0 0
    syspolicy_policy_execution_history_details_internal PK__syspolic__38E9A22431A25463 0 0 0 0 0 0
    syspolicy_policy_execution_history_details_internal IX_syspolicy_policy_execution_history_details_internal_result 0 0 0 0 0 0
    syspolicy_policy_execution_history_internal IX_syspolicy_policy_execution_history_internal_end_date_policy_id 0 0 0 0 0 0
    syspolicy_policy_execution_history_internal IX_syspolicy_policy_execution_history_internal_policy_id 0 0 0 0 0 0
    syspolicy_policy_execution_history_internal PK__syspolic__096AA2E92818EA29 0 0 0 0 0 0
    syspolicy_system_health_state_internal PK__syspolic__409BC9E5226010D3 0 0 0 0 0 0
    syspolicy_system_health_state_internal IX_syspolicy_system_health_state_internal_target_query_expression_with_id 0 0 0 0 0 0
    syspolicy_system_health_state_internal IX_syspolicy_system_health_state_internal_policy_id 0 0 0 0 0 0
    syspolicy_target_set_levels_internal PK_syspolicy_target_set_levels_internal 0 0 0 0 0 0
    syspolicy_target_sets_internal PK_syspolicy_target_sets 0 0 0 0 0 0
    syspolicy_target_sets_internal UX_syspolicy_target_sets 0 0 0 0 0 0
    syspolicy_target_sets_internal UX_syspolicy_levels 0 0 0 0 0 0
    syspriorities nc2 0 0 0 0 0 0
    syspriorities nc 0 0 0 0 0 0
    syspriorities cl 0 0 0 0 0 0
    sysproxies clust 0 0 0 0 0 0
    sysproxies nc1 0 0 0 0 0 0
    sysproxylogin clust 0 0 0 0 0 0
    sysproxysubsystem clust 0 0 0 0 0 0
    sysremsvcbinds clst 0 0 0 0 0 0
    sysremsvcbinds nc1 0 0 0 0 0 0
    sysremsvcbinds nc2 0 0 0 0 0 0
    sysrowsetrefs clust 0 0 0 0 0 0
    syssoftobjrefs clst 0 0 0 0 0 0
    syssoftobjrefs nc1 0 0 0 0 0 0
    syssqlguides nc1 0 0 0 0 0 0
    syssqlguides nc2 0 0 0 0 0 0
    syssqlguides clst 0 0 0 0 0 0
    sysssislog PK__sysssisl__3213E83F34E8D562 0 0 0 0 0 0
    systargetservergroupmembers clust 0 0 0 0 0 0
    systargetservergroupmembers nc1 0 0 0 0 0 0
    systargetservergroups clust 0 0 0 0 0 0
    systargetservers clust 0 0 0 0 0 0
    systargetservers nc1 0 0 0 0 0 0
    systaskids clust 0 0 0 0 0 0
    systypedsubobjs clst 0 0 0 0 0 0
    systypedsubobjs nc 0 0 0 0 0 0
    sysxprops clust 0 0 0 0 0 0