June 1, 2015 at 10:06 pm
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
June 2, 2015 at 12:00 am
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
June 2, 2015 at 2:28 am
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
June 2, 2015 at 6:33 pm
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.
June 3, 2015 at 1:12 am
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....
June 3, 2015 at 2:33 am
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
June 3, 2015 at 5:39 pm
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 ?
June 3, 2015 at 8:35 pm
Did you provide the entire error message from the error log or just a summary?
June 3, 2015 at 9:09 pm
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
June 4, 2015 at 10:05 am
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?
June 4, 2015 at 6:51 pm
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 🙁
June 5, 2015 at 8:54 am
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.
January 3, 2016 at 8:10 pm
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
January 3, 2016 at 9:37 pm
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
January 3, 2016 at 9:42 pm
Thanks mate ? I also came across that link but it’s not helpful unfortunately
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply