service-broker
Specify service_broker_guid instead of getting random one from NEW_BROKER
In SQL 2008, is there a way to specify a service_broker_guid instead of simply taking whatever GUID is given to you by:[详细]
2023-02-15 12:22 分类:问答Where can I find ssbdiagnose
Is there a place where I 开发者_如何学Pythoncan get this utility for diagnosing service broker in sql server.Ssbdiagnose.exe is a command line application that comes with Microsoft SQL Server 2008.[详细]
2023-02-08 02:02 分类:问答Diagnosing poor Sql Server Service Broker forwarding performance
I\'ve been running Service Broker in my development environment for a few months now and have had perfectly adequate performance, toward 1000 message per second (plenty for my needs).[详细]
2023-02-03 20:50 分类:问答SQL Server Service Broker: how to determine overhead or max performance?
We are trying to determine whether we are using Service Broker appropriately and getting the max performance out of it.We have been tweaking our SB conversations and handling, and have gone from 3000/[详细]
2023-02-02 17:13 分类:问答"The notification message type <MessageType> was unexpected." is logged by SSBEA and my app is never called
I am running SQL Server 2005 Standard Edition with External Activator installed. I have the following code in an SSMS tab:[详细]
2023-01-29 07:25 分类:问答to MSMQ or not to MSMQ? (or SQL Table as the Queue)
I\'ve got a distributed system where there will be 1 SQL Server, 1-n processing servers, and 1-n data suppliers (hardware devices across the network).The data being supplied will require processing pr[详细]
2023-01-28 02:14 分类:问答Enqueue each row in a ssb queue from a large table
I have a table that contains 2.5 million rows, each row has one column of type xml. All records should be deleted and enqueu开发者_如何转开发ed in a sqlserver service broker queue when a message arriv[详细]
2023-01-26 18:46 分类:问答Service Broker conversations not closed (staying in CONVERSING state)
I\'m noticing some conversations not getting closed, staying in CONVERSING state. The strange thing is, the queue is configured to process only 1 message at a time. In practice, however, there are 2 c[详细]
2023-01-26 17:47 分类:问答Slow stored procedure when activated from Service Broker
I\'ve written a stored procedure that takes 15 min when executed from Management Studio. When it\'s activated from Service Broker, however, after 4 hours it hasn\'t done even half of its work.[详细]
2023-01-24 09:54 分类:问答MSMQ vs. SQL Server Service Broker
I have an applicati开发者_如何学Con that consists of three parts: a front-end web shop for end-users and business partners[详细]
2023-01-21 09:15 分类:问答