SQL Server Blogs - http://www.sqlcommunity.com

SQL Server 2005 Service Broker References

Apr 14

Written by: Cindy Gross
Monday, April 14, 2008 12:04:41 PM

References

· Service Broker Developer InfoCenter http://msdn2.microsoft.com/en-us/library/ms166100.aspx

· Tech Net Service Broker http://technet.microsoft.com/en-us/sqlserver/bb671396.aspx

· MSDN Virtual Lab: SQL Server 2005 Service Broker http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032291316&EventCategory=3&culture=en-US&CountryCode=US

· MSDN Webcast: Introducing Service Broker in SQL Server 2005—Level 200 http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032263311&CountryCode=US

· Microsoft Queuing Frameworks: SQL Service Broker Vs. MSMQ http://whitepapers.zdnet.com/whitepaper.aspx?&docid=303837&promo=100511 (requires registration)

· http://www.sqlservicebroker.com/

· An Introduction to the Service Broker http://www.sqlservercentral.com/articles/Development/anintroductiontotheservicebroker/1957/

· The Service Broker Alphabet Part 1 http://www.sqlservercentral.com/articles/Service+Broker/2807/

· Service Broker Examples http://www.codeplex.com/MSFTSBProdSamples

· Making SQL Server 2005 Service Broker work between remote instances http://weblogs.sqlteam.com/dmauri/archive/2005/05/29/5357.aspx

KB Articles:

· 915852 How to use certificates for SQL Server 2005 Service Broker remote security on multiple instances of SQL Server 2005 http://support.microsoft.com/default.aspx?scid=kb;EN-US;915852

· 942711 FIX: You receive a time-out error message when you try to send a message to the target service of a Service Broker application that you create in SQL Server 2005 http://support.microsoft.com/default.aspx?scid=kb;EN-US;942711 (Fix in CU4)

· 940286 FIX: A Service Broker endpoint stops passing messages in a database mirroring session of SQL Server 2005 http://support.microsoft.com/default.aspx?scid=kb;EN-US;940286 (fix in CU4)

Case Studies:

· SQL Server 2005 Runs Faster Ad Hoc Queries For Microsoft IT Sales Analysis Support http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=48583

· Retalix Solution Saves Costs, Increases Efficiency, Improves Shopping Experience http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=4000000054

· SQL Server 2005 Gives Microsoft IT FeedStore Group Enterprise-grade ETL and Encryption http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=48596

· Software Company Creates Automated ‘Database Factory’ Using SQL Server 2008 http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=4000001007

Troubleshooting:

· Verify that the service setup, spelling, routes in sys.routes, etc are all correct. Check the SQL Server error log and event logs for any messages. Capture a profiler trace with the Broker events, Query Notifications, Security Broker events, errors/warnings, and RPC/Batch completed events. Query the Broker DMVs and catalog views, especially sys.dm_qn_subscriptions and transmission_status from sys.transmission_queue.

· Verify the database principal has correct permissions, especially

o RECEIVE on QueryNotificationErrorsQueue

o SUBSCRIBE on Query Notification

o SELECT and/or EXECUTE on underlying tables or views involved in the query

· Verify the endpoints don’t use any TCP ports that are in use by any local SQL Server instance or any other application.

· If the queries go across databases, has SET TRUSTWORTHY ON been set with ALTER DATABASE?

· Avoid restoring MSDB from another instance as the GUIDs might not be correct.

· Troubleshooting Service Broker BOL or http://msdn2.microsoft.com/en-us/library/ms166133.aspx

· Service Broker How-to Topics http://msdn2.microsoft.com/en-us/library/ms166047.aspx

· MSDN Service Broker Forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=91&SiteID=1

· Scripts http://sqlcommunity.com/ScriptsTools/SQLServerScriptsCategorized/tabid/56/language/en-US/Default.aspx

Trackback Print

Location: Blogs

Troubleshooting and Tips - Cindy Gross

Tags: