\nMore about Service Broker priority in SQL Server 2008.\n<\/p>\n
\nThe books online states, when setting a initiator\/target priority as local service name\/remote service name that the priority affects:\n<\/p>\n
\n1. Sends from the initiator queue
\n2. Receives from the initiator queue
\n3. Getting the next conversation group from the initiator queue.\n<\/p>\n
\nAnd specifies the mirror image priority for target\/initiator as local service name\/remote service name affects:\n<\/p>\n
\n1. Receives from the target queue
\n2. Sends from the target service
\n3. Getting the next conversation group from the target queue\n<\/p>\n
\nSo, in my previous example, where\n<\/p>\n
\nThe initiator\/target as local service name\/remote service name is priority 7
\nThe target\/initiator as local service name\/remote service name is priority 6\n<\/p>\n
\nLet's send a message from the initiator that "sticks" in sys.transmission_queue. Suppose that either the network is slow or we don't have the appropriate setup. But the message is floundering in the transmission queue. Already SENT, waiting to be delivered.\n<\/p>\n
\n"select * from sys.transmission_queue;" shows the message BEING SENT (and transmitted) at priority 7. And, when the message is finally DELIVERED, the priority in the receiveq "select * from receiveq" is priority 6.\n<\/p>\n
\nNormally, you'd likely make both priorities in the initiator\/target pair the same to avoid confusion, but you can make them different for greater granularity. And it DOES help to illustrate where and when priority is used.<\/p>\n","protected":false},"excerpt":{"rendered":"
More about Service Broker priority in SQL Server 2008. The books online states, when setting a initiator\/target priority as local service name\/remote service name that the priority affects: 1. Sends from the initiator queue 2. Receives from the initiator queue 3. Getting the next conversation group from the initiator queue. And specifies the mirror image […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,29],"tags":[],"class_list":["post-728","post","type-post","status-publish","format-standard","hentry","category-service-broker","category-sql-server-2008"],"yoast_head":"\n