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

  • January 30, 2015 at 9:22 am

    #1774383

    A better way of terminating all Service-Broker activity in a given database:

    ALTER DATABASE [dbName] SET NEW_BROKER WITH ROLLBACK IMMEDIATE;

    See:

    http://stackoverflow.com/questions/22392341/alter-database-db-name-set-enable-broker-with-rollback-immediate

    http://stackoverflow.com/questions/6931001/how-to-quickly-shut-down-all-elements-of-microsoft-sql-server-service-broker

    __________________________________________________________________________________
    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]