Service Broker Health - DEV01

Erstellt: 2026-07-19 18:33:24
Quelle: www.powershelldba.de | sqmSQLTool v1.9.26.1

Configuration: Single System

Service Broker Endpoints

No Service Broker endpoints found

Service Broker Status per Database

Enabled: 7 | Disabled: 3

DatabaseStatus
ActiveSourceDBENABLED
AdventureWorksENABLED
ArchiveTestDBENABLED
masterDISABLED
modelDISABLED
msdbENABLED
PartitionTestDBENABLED
SQLLiveDiagnoseENABLED
sqmRestoreTestDISABLED
tempdbENABLED

Service Queues

DatabaseQueueEnqueueReceiveActivation
ActiveSourceDBEventNotificationErrorsQueueONONOFF
ActiveSourceDBQueryNotificationErrorsQueueONONOFF
ActiveSourceDBServiceBrokerQueueONONOFF
AdventureWorksEventNotificationErrorsQueueONONOFF
AdventureWorksQueryNotificationErrorsQueueONONOFF
AdventureWorksServiceBrokerQueueONONOFF
ArchiveTestDBEventNotificationErrorsQueueONONOFF
ArchiveTestDBQueryNotificationErrorsQueueONONOFF
ArchiveTestDBServiceBrokerQueueONONOFF
msdbEventNotificationErrorsQueueONONOFF
msdbExternalMailQueueONONON
msdbInternalMailQueueONONON
msdbQueryNotificationErrorsQueueONONOFF
msdbServiceBrokerQueueONONOFF
msdbsyspolicy_event_queueONONON
PartitionTestDBEventNotificationErrorsQueueONONOFF
PartitionTestDBQueryNotificationErrorsQueueONONOFF
PartitionTestDBServiceBrokerQueueONONOFF
SQLLiveDiagnoseEventNotificationErrorsQueueONONOFF
SQLLiveDiagnoseQueryNotificationErrorsQueueONONOFF
SQLLiveDiagnoseServiceBrokerQueueONONOFF
tempdbEventNotificationErrorsQueueONONOFF
tempdbQueryNotificationErrorsQueueONONOFF
tempdbServiceBrokerQueueONONOFF

Undeliverable Messages (Transmission Queue)

DatabaseUndeliverable
ActiveSourceDB
AdventureWorks
ArchiveTestDB
msdb
PartitionTestDB
SQLLiveDiagnose
tempdb

Service Pairs and Contracts

DatabaseServiceContract
ActiveSourceDBhttp://schemas.microsoft.com/SQL/Notifications/EventNotificationService
ActiveSourceDBhttp://schemas.microsoft.com/SQL/Notifications/QueryNotificationService
ActiveSourceDBhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho
ActiveSourceDBhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic
AdventureWorkshttp://schemas.microsoft.com/SQL/Notifications/EventNotificationService
AdventureWorkshttp://schemas.microsoft.com/SQL/Notifications/QueryNotificationService
AdventureWorkshttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho
AdventureWorkshttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic
ArchiveTestDBhttp://schemas.microsoft.com/SQL/Notifications/EventNotificationService
ArchiveTestDBhttp://schemas.microsoft.com/SQL/Notifications/QueryNotificationService
ArchiveTestDBhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho
ArchiveTestDBhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic
msdbExternalMailService//www.microsoft.com/databasemail/contracts/SendMail/v1.0
msdbInternalMailService//www.microsoft.com/databasemail/contracts/SendMail/v1.0
msdbhttp://schemas.microsoft.com/SQL/Notifications/EventNotificationService
msdbhttp://schemas.microsoft.com/SQL/Notifications/QueryNotificationService
msdbhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho
msdbhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic
msdbsyspolicy_event_listenerhttp://schemas.microsoft.com/SQL/Notifications/PostEventNotification
PartitionTestDBhttp://schemas.microsoft.com/SQL/Notifications/EventNotificationService
PartitionTestDBhttp://schemas.microsoft.com/SQL/Notifications/QueryNotificationService
PartitionTestDBhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho
PartitionTestDBhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic
SQLLiveDiagnosehttp://schemas.microsoft.com/SQL/Notifications/EventNotificationService
SQLLiveDiagnosehttp://schemas.microsoft.com/SQL/Notifications/QueryNotificationService
SQLLiveDiagnosehttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho
SQLLiveDiagnosehttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic
tempdbhttp://schemas.microsoft.com/SQL/Notifications/EventNotificationService
tempdbhttp://schemas.microsoft.com/SQL/Notifications/QueryNotificationService
tempdbhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho
tempdbhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerhttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic
sqmSQLTool  |  dtcSoftware / Uwe Janke  |  www.powershelldba.de   –   2026-07-19 18:33:24