2

I was working on a POC for pushing the database notifications to the UI using SignalR using the following articles:

The article has suggested to enable Service broker on the database level.

SELECT name, is_broker_enabled FROM sys.databases

ALTER DATABASE DemoDatabase SET ENABLE_BROKER
GO

GRANT SUBSCRIBE QUERY NOTIFICATIONS TO "DemoUserTesting"

Is there any impact on the performance at database level or any other issues if I enable Service broker on the database level?

vhu
  • 12,244
  • 11
  • 38
  • 48
santosh kumar patro
  • 7,231
  • 22
  • 71
  • 143
  • This might help you. http://stackoverflow.com/questions/21570337/disadvantages-of-sql-server-service-broker regards, Sachin – user2429070 Aug 18 '14 at 10:49

1 Answers1

2

Service broker is better for performance when using SQL as backplane for signalR, although it does also work with out it.

see here for full explanation http://www.asp.net/signalr/overview/signalr-20/performance-and-scaling/scaleout-with-sql-server

Shachaf.Gortler
  • 5,655
  • 14
  • 43
  • 71