The transmission table structure in database is inconsistent

Question

The transmission table structure in database is inconsistent

WhiteLotus

SSChampion

Points: 12122
More actions
June 1, 2015 at 10:06 pm

#304557

Hi All ,
I have an issue in my production , SQL server 2008 R2 , in Error log it is said “ An error occurred in dialog transmission Error : 9655 , State : 3 and Error : 9736 Severity : 16 State 0
I checked in sysmessages , it is said :” The transmission queue table structure in database is inconsistent. Possible database corruption “
So do you think I need to run DBCC checkdb ? Should I run it after working hours or it is fine within working hours ?
I really appreciate your kind feedback
Cheers

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

WhiteLotus SSChampion Points: 12122 More actions · Answer 1

All,

Some additional information .. I have just run DBCC check DB for all user db and system db but everything is OK . zero consistency error ..

I have no idea what I need to do next ...

cheers

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Run a checkDB on Msdb.

You are running CheckDB regularly on all databases, right?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

WhiteLotus SSChampion Points: 12122 More actions · Answer 3

GilaMonster (6/2/2015)
Run a checkDB on Msdb.
You are running CheckDB regularly on all databases, right?

Thanks so much for the reply , Appreciate it !

I have just run DBCC for msdb this morning but at the end , the result is OK ( I expect some errors there ) :

“CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.”

Here is the detail :

DBCC results for 'msdb'.

Service Broker Msg 9675, State 1: Message Types analyzed: 16.

Service Broker Msg 9676, State 1: Service Contracts analyzed: 7.

Service Broker Msg 9667, State 1: Services analyzed: 6.

Service Broker Msg 9668, State 1: Service Queues analyzed: 6.

Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.

Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.

Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.

Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.

DBCC results for 'sys.sysrscols'.

There are 2349 rows in 27 pages for object "sys.sysrscols".

DBCC results for 'sys.sysrowsets'.

There are 348 rows in 5 pages for object "sys.sysrowsets".

DBCC results for 'sys.sysallocunits'.

There are 437 rows in 7 pages for object "sys.sysallocunits".

DBCC results for 'sys.sysfiles1'.

There are 2 rows in 1 pages for object "sys.sysfiles1".

DBCC results for 'sys.syspriorities'.

There are 0 rows in 0 pages for object "sys.syspriorities".

DBCC results for 'sys.sysfgfrag'.

There are 2 rows in 1 pages for object "sys.sysfgfrag".

DBCC results for 'sys.sysphfg'.

There are 1 rows in 1 pages for object "sys.sysphfg".

DBCC results for 'sys.sysprufiles'.

There are 2 rows in 1 pages for object "sys.sysprufiles".

DBCC results for 'sys.sysftinds'.

There are 0 rows in 0 pages for object "sys.sysftinds".

DBCC results for 'sys.sysowners'.

There are 40 rows in 1 pages for object "sys.sysowners".

DBCC results for 'sys.sysprivs'.

There are 616 rows in 4 pages for object "sys.sysprivs".

DBCC results for 'sys.sysschobjs'.

There are 1347 rows in 28 pages for object "sys.sysschobjs".

DBCC results for 'sys.syscolpars'.

There are 4786 rows in 121 pages for object "sys.syscolpars".

DBCC results for 'sys.sysnsobjs'.

There are 4 rows in 1 pages for object "sys.sysnsobjs".

DBCC results for 'sys.syscerts'.

There are 2 rows in 1 pages for object "sys.syscerts".

DBCC results for 'sys.sysxprops'.

There are 1 rows in 1 pages for object "sys.sysxprops".

DBCC results for 'sys.sysscalartypes'.

There are 35 rows in 1 pages for object "sys.sysscalartypes".

DBCC results for 'sys.systypedsubobjs'.

There are 0 rows in 0 pages for object "sys.systypedsubobjs".

DBCC results for 'sys.sysidxstats'.

There are 610 rows in 12 pages for object "sys.sysidxstats".

DBCC results for 'sys.sysiscols'.

There are 858 rows in 5 pages for object "sys.sysiscols".

DBCC results for 'sys.sysbinobjs'.

There are 29 rows in 1 pages for object "sys.sysbinobjs".

DBCC results for 'sys.sysaudacts'.

There are 0 rows in 0 pages for object "sys.sysaudacts".

DBCC results for 'sys.sysobjvalues'.

There are 1565 rows in 499 pages for object "sys.sysobjvalues".

DBCC results for 'sys.sysclsobjs'.

There are 27 rows in 1 pages for object "sys.sysclsobjs".

DBCC results for 'sys.sysrowsetrefs'.

There are 0 rows in 0 pages for object "sys.sysrowsetrefs".

DBCC results for 'sys.sysremsvcbinds'.

There are 0 rows in 0 pages for object "sys.sysremsvcbinds".

DBCC results for 'sys.sysxmitqueue'.

There are 0 rows in 0 pages for object "sys.sysxmitqueue".

DBCC results for 'sys.sysrts'.

There are 1 rows in 1 pages for object "sys.sysrts".

DBCC results for 'sys.sysconvgroup'.

There are 0 rows in 0 pages for object "sys.sysconvgroup".

DBCC results for 'sys.sysdesend'.

There are 0 rows in 0 pages for object "sys.sysdesend".

DBCC results for 'sys.sysdercv'.

There are 0 rows in 0 pages for object "sys.sysdercv".

DBCC results for 'sys.syssingleobjrefs'.

There are 572 rows in 3 pages for object "sys.syssingleobjrefs".

DBCC results for 'sys.sysmultiobjrefs'.

There are 5099 rows in 48 pages for object "sys.sysmultiobjrefs".

DBCC results for 'sys.sysguidrefs'.

There are 0 rows in 0 pages for object "sys.sysguidrefs".

DBCC results for 'sys.syscompfragments'.

There are 0 rows in 0 pages for object "sys.syscompfragments".

DBCC results for 'sys.sysftstops'.

There are 0 rows in 0 pages for object "sys.sysftstops".

DBCC results for 'sys.sysqnames'.

There are 127 rows in 1 pages for object "sys.sysqnames".

DBCC results for 'sys.sysxmlcomponent'.

There are 149 rows in 1 pages for object "sys.sysxmlcomponent".

DBCC results for 'sys.sysxmlfacet'.

There are 112 rows in 1 pages for object "sys.sysxmlfacet".

DBCC results for 'sys.sysxmlplacement'.

There are 85 rows in 1 pages for object "sys.sysxmlplacement".

DBCC results for 'sys.sysobjkeycrypts'.

There are 404 rows in 34 pages for object "sys.sysobjkeycrypts".

DBCC results for 'sys.sysasymkeys'.

There are 0 rows in 0 pages for object "sys.sysasymkeys".

DBCC results for 'sys.syssqlguides'.

There are 0 rows in 0 pages for object "sys.syssqlguides".

DBCC results for 'sys.sysbinsubobjs'.

There are 3 rows in 1 pages for object "sys.sysbinsubobjs".

DBCC results for 'sys.syssoftobjrefs'.

There are 1861 rows in 43 pages for object "sys.syssoftobjrefs".

DBCC results for 'syspolicy_policies_internal'.

There are 0 rows in 0 pages for object "syspolicy_policies_internal".

DBCC results for 'sysproxies'.

There are 0 rows in 0 pages for object "sysproxies".

DBCC results for 'sysdbmaintplan_history'.

There are 0 rows in 0 pages for object "sysdbmaintplan_history".

DBCC results for 'syscollector_execution_stats_internal'.

There are 0 rows in 0 pages for object "syscollector_execution_stats_internal".

DBCC results for 'backupmediaset'.

There are 10925 rows in 137 pages for object "backupmediaset".

DBCC results for 'sysproxysubsystem'.

There are 0 rows in 0 pages for object "sysproxysubsystem".

DBCC results for 'sysproxylogin'.

There are 0 rows in 0 pages for object "sysproxylogin".

DBCC results for 'log_shipping_primary_secondaries'.

There are 0 rows in 0 pages for object "log_shipping_primary_secondaries".

DBCC results for 'backupmediafamily'.

There are 10925 rows in 360 pages for object "backupmediafamily".

DBCC results for 'sqlagent_info'.

There are 0 rows in 0 pages for object "sqlagent_info".

DBCC results for 'sysdownloadlist'.

There are 0 rows in 0 pages for object "sysdownloadlist".

DBCC results for 'log_shipping_monitor_primary'.

There are 0 rows in 0 pages for object "log_shipping_monitor_primary".

DBCC results for 'sysjobhistory'.

There are 400 rows in 151 pages for object "sysjobhistory".

DBCC results for 'sysoriginatingservers'.

There are 0 rows in 0 pages for object "sysoriginatingservers".

DBCC results for 'log_shipping_monitor_history_detail'.

There are 0 rows in 0 pages for object "log_shipping_monitor_history_detail".

DBCC results for 'backupset'.

There are 10927 rows in 837 pages for object "backupset".

DBCC results for 'log_shipping_monitor_error_detail'.

There are 0 rows in 0 pages for object "log_shipping_monitor_error_detail".

DBCC results for 'log_shipping_secondary'.

There are 0 rows in 0 pages for object "log_shipping_secondary".

DBCC results for 'sysmail_attachments'.

There are 0 rows in 0 pages for object "sysmail_attachments".

DBCC results for 'backupfilegroup'.

There are 10927 rows in 159 pages for object "backupfilegroup".

DBCC results for 'log_shipping_secondary_databases'.

There are 0 rows in 0 pages for object "log_shipping_secondary_databases".

DBCC results for 'sysmail_send_retries'.

There are 0 rows in 0 pages for object "sysmail_send_retries".

DBCC results for 'log_shipping_monitor_secondary'.

There are 0 rows in 0 pages for object "log_shipping_monitor_secondary".

DBCC results for 'sys.queue_messages_343008303'.

There are 0 rows in 0 pages for object "sys.queue_messages_343008303".

DBCC results for 'log_shipping_primaries'.

There are 0 rows in 0 pages for object "log_shipping_primaries".

DBCC results for 'backupfile'.

There are 21854 rows in 1138 pages for object "backupfile".

DBCC results for 'sysjobs'.

There are 4 rows in 1 pages for object "sysjobs".

DBCC results for 'sysutility_ucp_mi_file_space_health_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_mi_file_space_health_internal".

DBCC results for 'log_shipping_monitor_alert'.

There are 0 rows in 0 pages for object "log_shipping_monitor_alert".

DBCC results for 'sysjobservers'.

There are 4 rows in 1 pages for object "sysjobservers".

DBCC results for 'log_shipping_secondaries'.

There are 0 rows in 0 pages for object "log_shipping_secondaries".

DBCC results for 'sysutility_mi_configuration_internal'.

There are 0 rows in 0 pages for object "sysutility_mi_configuration_internal".

DBCC results for 'syssessions'.

There are 54 rows in 1 pages for object "syssessions".

DBCC results for 'sysmail_log'.

There are 0 rows in 0 pages for object "sysmail_log".

DBCC results for 'restorehistory'.

There are 56 rows in 1 pages for object "restorehistory".

DBCC results for 'sysutility_ucp_mi_database_health_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_mi_database_health_internal".

DBCC results for 'syscollector_blobs_internal'.

There are 1 rows in 1 pages for object "syscollector_blobs_internal".

DBCC results for 'sysjobactivity'.

There are 144 rows in 3 pages for object "sysjobactivity".

DBCC results for 'restorefile'.

There are 111 rows in 6 pages for object "restorefile".

DBCC results for 'syscollector_tsql_query_collector'.

There are 0 rows in 0 pages for object "syscollector_tsql_query_collector".

DBCC results for 'sysjobsteps'.

There are 6 rows in 1 pages for object "sysjobsteps".

DBCC results for 'sysmail_query_transfer'.

There are 0 rows in 0 pages for object "sysmail_query_transfer".

DBCC results for 'restorefilegroup'.

There are 55 rows in 5 pages for object "restorefilegroup".

DBCC results for 'sysjobstepslogs'.

There are 0 rows in 0 pages for object "sysjobstepslogs".

DBCC results for 'sysutility_ucp_dac_file_space_health_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_dac_file_space_health_internal".

DBCC results for 'logmarkhistory'.

There are 0 rows in 0 pages for object "logmarkhistory".

DBCC results for 'suspect_pages'.

There are 0 rows in 0 pages for object "suspect_pages".

DBCC results for 'sysutility_ucp_dacs_stub'.

There are 0 rows in 0 pages for object "sysutility_ucp_dacs_stub".

DBCC results for 'sysmail_attachments_transfer'.

There are 0 rows in 0 pages for object "sysmail_attachments_transfer".

DBCC results for 'sysutility_ucp_volumes_stub'.

There are 0 rows in 0 pages for object "sysutility_ucp_volumes_stub".

DBCC results for 'sysdtscategories'.

There are 3 rows in 1 pages for object "sysdtscategories".

DBCC results for 'syspolicy_target_sets_internal'.

There are 0 rows in 0 pages for object "syspolicy_target_sets_internal".

DBCC results for 'syssubsystems'.

There are 12 rows in 1 pages for object "syssubsystems".

DBCC results for 'sysutility_ucp_computers_stub'.

There are 0 rows in 0 pages for object "sysutility_ucp_computers_stub".

DBCC results for 'sysutility_ucp_mi_volume_space_health_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_mi_volume_space_health_internal".

DBCC results for 'sysschedules'.

There are 11 rows in 1 pages for object "sysschedules".

DBCC results for 'sysutility_ucp_smo_servers_stub'.

There are 0 rows in 0 pages for object "sysutility_ucp_smo_servers_stub".

DBCC results for 'sysutility_ucp_snapshot_partitions_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_snapshot_partitions_internal".

DBCC results for 'TableRowCounts_Primary_B_failover'.

There are 0 rows in 0 pages for object "TableRowCounts_Primary_B_failover".

DBCC results for 'sysutility_ucp_databases_stub'.

There are 0 rows in 0 pages for object "sysutility_ucp_databases_stub".

DBCC results for 'sysdtspackages'.

There are 0 rows in 0 pages for object "sysdtspackages".

DBCC results for 'sysutility_ucp_filegroups_stub'.

There are 0 rows in 0 pages for object "sysutility_ucp_filegroups_stub".

DBCC results for 'syspolicy_target_set_levels_internal'.

There are 0 rows in 0 pages for object "syspolicy_target_set_levels_internal".

DBCC results for 'DTA_input'.

There are 2 rows in 1 pages for object "DTA_input".

DBCC results for 'sysdac_instances_internal'.

There are 0 rows in 0 pages for object "sysdac_instances_internal".

DBCC results for 'sysutility_ucp_datafiles_stub'.

There are 0 rows in 0 pages for object "sysutility_ucp_datafiles_stub".

DBCC results for 'sysssispackages'.

There are 11 rows in 3 pages for object "sysssispackages".

DBCC results for 'sysutility_ucp_computer_cpu_health_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_computer_cpu_health_internal".

DBCC results for 'sysutility_ucp_logfiles_stub'.

There are 0 rows in 0 pages for object "sysutility_ucp_logfiles_stub".

DBCC results for 'sysutility_ucp_cpu_utilization_stub'.

There are 0 rows in 0 pages for object "sysutility_ucp_cpu_utilization_stub".

DBCC results for 'sysutility_mi_volumes_stage_internal'.

There are 0 rows in 0 pages for object "sysutility_mi_volumes_stage_internal".

DBCC results for 'sysssispackagefolders'.

There are 4 rows in 1 pages for object "sysssispackagefolders".

DBCC results for 'sysdac_history_internal'.

There are 0 rows in 0 pages for object "sysdac_history_internal".

DBCC results for 'MSdbms'.

There are 8 rows in 1 pages for object "MSdbms".

DBCC results for 'sysjobschedules'.

There are 4 rows in 1 pages for object "sysjobschedules".

DBCC results for 'sysutility_ucp_space_utilization_stub'.

There are 0 rows in 0 pages for object "sysutility_ucp_space_utilization_stub".

DBCC results for 'sysutility_mi_cpu_stage_internal'.

There are 0 rows in 0 pages for object "sysutility_mi_cpu_stage_internal".

DBCC results for 'MSdbms_datatype'.

There are 180 rows in 2 pages for object "MSdbms_datatype".

DBCC results for 'sysssislog'.

There are 0 rows in 0 pages for object "sysssislog".

DBCC results for 'sysutility_ucp_aggregated_dac_health_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_aggregated_dac_health_internal".

DBCC results for 'DTA_progress'.

There are 6 rows in 1 pages for object "DTA_progress".

DBCC results for 'syscategories'.

There are 21 rows in 1 pages for object "syscategories".

DBCC results for 'MSdbms_map'.

There are 374 rows in 5 pages for object "MSdbms_map".

DBCC results for 'systargetservers'.

There are 0 rows in 0 pages for object "systargetservers".

DBCC results for 'systargetservergroups'.

There are 0 rows in 0 pages for object "systargetservergroups".

DBCC results for 'systargetservergroupmembers'.

There are 0 rows in 0 pages for object "systargetservergroupmembers".

DBCC results for 'syspolicy_policy_category_subscriptions_internal'.

There are 0 rows in 0 pages for object "syspolicy_policy_category_subscriptions_internal".

DBCC results for 'DTA_output'.

There are 2 rows in 1 pages for object "DTA_output".

DBCC results for 'sysalerts'.

There are 0 rows in 0 pages for object "sysalerts".

DBCC results for 'sysoperators'.

There are 0 rows in 0 pages for object "sysoperators".

DBCC results for 'sys.queue_messages_989962603'.

There are 0 rows in 0 pages for object "sys.queue_messages_989962603".

DBCC results for 'sysnotifications'.

There are 0 rows in 0 pages for object "sysnotifications".

DBCC results for 'sysdtspackagelog'.

There are 0 rows in 0 pages for object "sysdtspackagelog".

DBCC results for 'sysmaintplan_subplans'.

There are 3 rows in 1 pages for object "sysmaintplan_subplans".

DBCC results for 'sys.queue_messages_1021962717'.

There are 0 rows in 0 pages for object "sys.queue_messages_1021962717".

DBCC results for 'syspolicy_system_health_state_internal'.

There are 0 rows in 0 pages for object "syspolicy_system_health_state_internal".

DBCC results for 'DTA_tuninglog'.

There are 419114 rows in 5374 pages for object "DTA_tuninglog".

DBCC results for 'sysdtssteplog'.

There are 0 rows in 0 pages for object "sysdtssteplog".

DBCC results for 'sysutility_ucp_aggregated_mi_health_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_aggregated_mi_health_internal".

DBCC results for 'DTA_reports_database'.

There are 4 rows in 1 pages for object "DTA_reports_database".

DBCC results for 'MSdbms_datatype_mapping'.

There are 493 rows in 4 pages for object "MSdbms_datatype_mapping".

DBCC results for 'syscollector_config_store_internal'.

There are 5 rows in 1 pages for object "syscollector_config_store_internal".

DBCC results for 'sysutility_mi_smo_stage_internal'.

There are 0 rows in 0 pages for object "sysutility_mi_smo_stage_internal".

DBCC results for 'sysmanagement_shared_server_groups_internal'.

There are 5 rows in 1 pages for object "sysmanagement_shared_server_groups_internal".

DBCC results for 'sysmaintplan_log'.

There are 2274 rows in 35 pages for object "sysmaintplan_log".

DBCC results for 'sysutility_mi_smo_objects_to_collect_internal'.

There are 5 rows in 1 pages for object "sysutility_mi_smo_objects_to_collect_internal".

DBCC results for 'sysdtstasklog'.

There are 0 rows in 0 pages for object "sysdtstasklog".

DBCC results for 'syspolicy_policy_execution_history_internal'.

There are 0 rows in 0 pages for object "syspolicy_policy_execution_history_internal".

DBCC results for 'DTA_reports_partitionfunction'.

There are 0 rows in 0 pages for object "DTA_reports_partitionfunction".

DBCC results for 'sysmaintplan_logdetail'.

There are 4702 rows in 121 pages for object "sysmaintplan_logdetail".

DBCC results for 'sysutility_mi_smo_properties_to_collect_internal'.

There are 84 rows in 1 pages for object "sysutility_mi_smo_properties_to_collect_internal".

DBCC results for 'systaskids'.

There are 0 rows in 0 pages for object "systaskids".

DBCC results for 'sysmanagement_shared_registered_servers_internal'.

There are 0 rows in 0 pages for object "sysmanagement_shared_registered_servers_internal".

DBCC results for 'syscachedcredentials'.

There are 0 rows in 1 pages for object "syscachedcredentials".

DBCC results for 'DTA_reports_partitionscheme'.

There are 0 rows in 0 pages for object "DTA_reports_partitionscheme".

DBCC results for 'sysutility_mi_dac_execution_statistics_internal'.

There are 0 rows in 0 pages for object "sysutility_mi_dac_execution_statistics_internal".

DBCC results for 'syscollector_collection_sets_internal'.

There are 4 rows in 1 pages for object "syscollector_collection_sets_internal".

DBCC results for 'syspolicy_policy_execution_history_details_internal'.

There are 0 rows in 0 pages for object "syspolicy_policy_execution_history_details_internal".

DBCC results for 'sysutility_ucp_dac_health_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_dac_health_internal".

DBCC results for 'DTA_reports_table'.

There are 673 rows in 8 pages for object "DTA_reports_table".

DBCC results for 'sysutility_mi_session_statistics_internal'.

There are 0 rows in 0 pages for object "sysutility_mi_session_statistics_internal".

DBCC results for 'DTA_reports_tableview'.

There are 0 rows in 0 pages for object "DTA_reports_tableview".

DBCC results for 'sysutility_ucp_supported_object_types_internal'.

There are 8 rows in 1 pages for object "sysutility_ucp_supported_object_types_internal".

DBCC results for 'sysmail_profile'.

There are 0 rows in 0 pages for object "sysmail_profile".

DBCC results for 'sysutility_ucp_managed_instances_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_managed_instances_internal".

DBCC results for 'DTA_reports_query'.

There are 184 rows in 3 pages for object "DTA_reports_query".

DBCC results for 'syspolicy_execution_internal'.

There are 0 rows in 0 pages for object "syspolicy_execution_internal".

DBCC results for 'sysmail_principalprofile'.

There are 0 rows in 0 pages for object "sysmail_principalprofile".

DBCC results for 'DTA_reports_querytable'.

There are 929 rows in 5 pages for object "DTA_reports_querytable".

DBCC results for 'syspolicy_management_facets'.

There are 83 rows in 1 pages for object "syspolicy_management_facets".

DBCC results for 'sysutility_ucp_mi_health_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_mi_health_internal".

DBCC results for 'syscollector_collector_types_internal'.

There are 4 rows in 1 pages for object "syscollector_collector_types_internal".

DBCC results for 'DTA_reports_querydatabase'.

There are 184 rows in 1 pages for object "DTA_reports_querydatabase".

DBCC results for 'syspolicy_configuration_internal'.

There are 4 rows in 1 pages for object "syspolicy_configuration_internal".

DBCC results for 'syspolicy_facet_events'.

There are 84 rows in 4 pages for object "syspolicy_facet_events".

DBCC results for 'sysutility_ucp_processing_state_internal'.

There are 1 rows in 1 pages for object "sysutility_ucp_processing_state_internal".

DBCC results for 'sysmail_account'.

There are 0 rows in 0 pages for object "sysmail_account".

DBCC results for 'DTA_reports_index'.

There are 1123 rows in 16 pages for object "DTA_reports_index".

DBCC results for 'syspolicy_conditions_internal'.

There are 0 rows in 0 pages for object "syspolicy_conditions_internal".

DBCC results for 'sysutility_ucp_health_policies_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_health_policies_internal".

DBCC results for 'sysmail_profileaccount'.

There are 0 rows in 0 pages for object "sysmail_profileaccount".

DBCC results for 'syscollector_collection_items_internal'.

There are 6 rows in 2 pages for object "syscollector_collection_items_internal".

DBCC results for 'sysmail_servertype'.

There are 1 rows in 1 pages for object "sysmail_servertype".

DBCC results for 'DTA_reports_queryindex'.

There are 2313 rows in 13 pages for object "DTA_reports_queryindex".

DBCC results for 'sysutility_ucp_filegroups_with_policy_violations_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_filegroups_with_policy_violations_internal".

DBCC results for 'sysutility_ucp_policy_check_conditions_internal'.

There are 12 rows in 1 pages for object "sysutility_ucp_policy_check_conditions_internal".

DBCC results for 'sysutility_ucp_configuration_internal'.

There are 13 rows in 1 pages for object "sysutility_ucp_configuration_internal".

DBCC results for 'sysdbmaintplans'.

There are 1 rows in 1 pages for object "sysdbmaintplans".

DBCC results for 'DTA_reports_column'.

There are 2287 rows in 16 pages for object "DTA_reports_column".

DBCC results for 'sysutility_ucp_policy_target_conditions_internal'.

There are 24 rows in 1 pages for object "sysutility_ucp_policy_target_conditions_internal".

DBCC results for 'sysmail_server'.

There are 0 rows in 0 pages for object "sysmail_server".

DBCC results for 'syspolicy_policy_categories_internal'.

There are 0 rows in 0 pages for object "syspolicy_policy_categories_internal".

DBCC results for 'sysutility_ucp_policy_violations_internal'.

There are 0 rows in 0 pages for object "sysutility_ucp_policy_violations_internal".

DBCC results for 'DTA_reports_indexcolumn'.

There are 128 rows in 1 pages for object "DTA_reports_indexcolumn".

DBCC results for 'sys.queue_messages_1977058079'.

There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".

DBCC results for 'syspolicy_object_sets_internal'.

There are 0 rows in 0 pages for object "syspolicy_object_sets_internal".

DBCC results for 'sysdbmaintplan_jobs'.

There are 0 rows in 0 pages for object "sysdbmaintplan_jobs".

DBCC results for 'sys.queue_messages_2009058193'.

There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".

DBCC results for 'DTA_reports_querycolumn'.

There are 3278 rows in 18 pages for object "DTA_reports_querycolumn".

DBCC results for 'sys.queue_messages_2041058307'.

There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".

DBCC results for 'sysmail_configuration'.

There are 7 rows in 1 pages for object "sysmail_configuration".

DBCC results for 'sys.filestream_tombstone_2073058421'.

There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".

DBCC results for 'sys.syscommittab'.

There are 0 rows in 0 pages for object "sys.syscommittab".

DBCC results for 'sysdbmaintplan_databases'.

There are 0 rows in 0 pages for object "sysdbmaintplan_databases".

DBCC results for 'syscollector_execution_log_internal'.

There are 0 rows in 0 pages for object "syscollector_execution_log_internal".

DBCC results for 'log_shipping_primary_databases'.

There are 0 rows in 0 pages for object "log_shipping_primary_databases".

DBCC results for 'sysmail_mailitems'.

There are 0 rows in 0 pages for object "sysmail_mailitems".

CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

WhiteLotus SSChampion Points: 12122 More actions · Answer 4

GilaMonster (6/2/2015)
Run a checkDB on Msdb.
You are running CheckDB regularly on all databases, right?

I don't do DBCC in my servers honestly . Do you think I need to run it daily or weekly ?

What should I check next since DBCC in MSDB showed OK ?

Thanks so much for your guidance ..

cheers....

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

WhiteLotus (6/3/2015)
GilaMonster (6/2/2015)
Run a checkDB on Msdb.
You are running CheckDB regularly on all databases, right?
I don't do DBCC in my servers honestly .

What???

You prefer to find out about corruption when the users complain, with no idea when it actually occurred and probably well after you could fix it without data loss? Really?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

WhiteLotus SSChampion Points: 12122 More actions · Answer 6

GilaMonster (6/3/2015)
WhiteLotus (6/3/2015)
GilaMonster (6/2/2015)
Run a checkDB on Msdb.
You are running CheckDB regularly on all databases, right?
I don't do DBCC in my servers honestly .
What???
You prefer to find out about corruption when the users complain, with no idea when it actually occurred and probably well after you could fix it without data loss? Really?

Of course I won’t prefer that way , The error has been there before I join that company so I need to fix it , but unfortunately I have no idea how to fix it really ..

I will also set up DBCC check DB for that server today ..running every day ? . But at the moment I need to fix the issue soon .

Any other idea apart from checking DBCC in MSDB ?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Did you provide the entire error message from the error log or just a summary?

WhiteLotus SSChampion Points: 12122 More actions · Answer 8

Lynn Pettis (6/3/2015)
Did you provide the entire error message from the error log or just a summary?

thx for the reply

in sql error log only says

Error : 9655 , State : 3 and Error : 9736 Severity : 16 State 0

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

WhiteLotus (6/3/2015)
Lynn Pettis (6/3/2015)
Did you provide the entire error message from the error log or just a summary?
thx for the reply
in sql error log only says
Error : 9655 , State : 3 and Error : 9736 Severity : 16 State 0

What does the log say around that error?

WhiteLotus SSChampion Points: 12122 More actions · Answer 10

Lynn Pettis (6/4/2015)
WhiteLotus (6/3/2015)
Lynn Pettis (6/3/2015)
Did you provide the entire error message from the error log or just a summary?
thx for the reply
in sql error log only says
Error : 9655 , State : 3 and Error : 9736 Severity : 16 State 0
What does the log say around that error?

I checked in select * from sysmessages , it is said :” The transmission queue table structure in database is inconsistent. Possible database corruption “

Then I did DBCC Checkdb for all databases ( system and user databases ) but the result is OK .. I just it twice until today .

Don't know what I need to do now 🙁

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

There may be other messages around the error that may help diagnose the error. That's why I asked what else was in the error log around the error itself.

WhiteLotus SSChampion Points: 12122 More actions · Answer 12

Hi Guys ..

I have an issue with this error again in the different server … I guess this is SQL service Broker error but until now I have no idea what to do

Error : An error occurred in dialog transmission: Error: 9655, State: 3" repeated every few seconds “ . The error messages is ONLY SAYING that !

I already run DBCC Checkdb for all system databases as well as user db but I got Zero Error !

Any feedback are much appreciated

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 13

I found another thread with the same error:https://social.technet.microsoft.com/Forums/sqlserver/en-US/b303f0f6-2966-4fcc-aa46-20b31c56bfd7/troubleshooting-service-bropker-error?forum=sqlservicebroker"> https://social.technet.microsoft.com/Forums/sqlserver/en-US/b303f0f6-2966-4fcc-aa46-20b31c56bfd7/troubleshooting-service-bropker-error?forum=sqlservicebroker

WhiteLotus SSChampion Points: 12122 More actions · Answer 14

Thanks mate ? I also came across that link but it’s not helpful unfortunately