Hi WebGurus,
I was working on a POC for pushing the database notifications to the UI using SignalR using the following articles:
http://techbrij.com/database-change-notifications-asp-net-signalr-sqldependency
http://gkulshrestha.wordpress.com/2014/05/02/signalr-with-sql-server-query-notification/
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"
Can anyone let me know is there any impact of the performance at database level or any other issues if I enable Service broker on the database level.
Thanks & Regards,
Santosh Kumar Patro
santosh kumar patro