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
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