Home Forums Article Discussions Article Discussions by Author Discuss content posted by Marios Philippopoulos Turbocharge Your Database Maintenance With Service Broker: Part 1 RE: Turbocharge Your Database Maintenance With Service Broker: Part 1

  • November 12, 2013 at 10:58 am

    #1665816

    srinath.m (11/12/2013)

    Good morning, Marios!! Here is the result of the query:

    ServiceQueueContract

    //UTILITY/UpdStats/InitiatorServiceUpdStats_InitiatorQueueNULL

    //UTILITY/UpdStats/TargetServiceUpdStats_TargetQueue//UTILITY/Contract

    http://schemas.microsoft.com/SQL/Notifications/EventNotificationServiceEventNotificationErrorsQueueNULL

    http://schemas.microsoft.com/SQL/Notifications/QueryNotificationServiceQueryNotificationErrorsQueueNULL

    http://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerServiceBrokerQueuehttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho

    http://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerServiceBrokerQueuehttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic

    Any clue, where did I go wrong 🙂

    Hmm, that output is correct.

    Can you go through the tips I mention in part 2[/url] and see if you can identify the issue?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]