Abstract
With activation, you can specify that Service Broker starts a service program automatically as soon as a new message arrives at a queue. In this chapter, I’ll present activation in detail and show you how you can use it to implement great Service Broker solutions. I’ll cover the following:
-
Activation basics: Activation allows you to start a service program as soon as a new message arrives in a service queue. With activation, you can process received messages automatically without any additional coding efforts.
-
Internal activation:With internal activation, you have the ability to activate a stored procedure as soon as a new message arrives. As you’192ll see, there are several options, as well as some issues you must be careful of.
-
External activation: External activation allows you to start an external application when a message arrives in a service queue. You can move long-running processing logic away from SQL Server and put it into separate processes for better performance and scalability.
-
Parallel activation: Normally, activated stored procedures are only started when Service Broker encounters receiving new messages. However, there are some tricks to starting more than one stored procedure simultaneously for message processing.
-
Troubleshooting activation: If you’re not careful during activation setup, you could encounter several problems. You’ll learn about common configuration issues introduced with Service Broker activation.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
“Extending Database Impersonation by Using EXECUTE AS,“ SQL Server 2005 Books Online, http://msdn2.microsoft.com/en-us/library/ms188304.aspx.
Rights and permissions
Copyright information
© 2008 Klaus Aschenbrenner
About this chapter
Cite this chapter
(2008). Service Broker Activation. In: Pro SQL Server 2008 Service Broker. Apress. https://doi.org/10.1007/978-1-4302-0865-5_4
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0865-5_4
Publisher Name: Apress
Print ISBN: 978-1-59059-999-0
Online ISBN: 978-1-4302-0865-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books