Service Broker Queues

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 719130

    Comments posted to this topic are about the item Service Broker Queues

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71767

    Nice question to end the week on, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • Shayn Thomas

    SSCertifiable

    Points: 5602

    good question, cheers Steve

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

  • Marcia J

    SSCertifiable

    Points: 5649

    I haven't used these yet.  Just wondering, what are some of the things people in this group have used Service Broker queues for?

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71767

    Marcia J wrote:

    I haven't used these yet.  Just wondering, what are some of the things people in this group have used Service Broker queues for?

    With my current, it is used to transfer data between databases in different netork domains, where domain trust goes against company policy, in seperate locations in our country

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • Mr. Brian Gale

    SSC-Insane

    Points: 22780

    We use it to transfer realtime data from one system to another.  Mostly as a way to break reliance on linked servers where possible.

    We pull data from system X into system Y.  Application A uses system X and Application B uses system Y.  Application A relies heavily on the tables not being locked and blocking needs to be minimized as much as possible to prevent slowdown on the system.  Application B needs to validate data from system X with the data being as near to real time as possible so SSIS isn't an option.  It works well for us for the most part.

    Database mirroring also uses service broker in the back end to do its magic.

    You can also do a 1 to many with service broker by sending multiple messages on table change.  If you have a busy server with high CPU, high memory and high disk I/O, you may want to offload some of the auditing data to a less busy server.  Or really, any cross database/instance/server communication you want to do.

Viewing 6 posts - 1 through 6 (of 6 total)

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