In SQL 2008, is there a way to specify a service_broker_guid instead of simply taking whatever GUID is given to you by:
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.
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).
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/
I am running SQL Server 2005 Standard Edition with External Activator installed. I have the following code in an SSMS tab:
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
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
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
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.
I have an applicati开发者_如何学Con that consists of three parts: a front-end web shop for end-users and business partners
加载中,请稍侯......