Is there any performance impact by enabling the Service broker at database level?

Posted by Santosh.Impossible under Sql Server on 8/18/2014 | Points: 10 | Views : 3569 | Status : [Member] | Replies : 1
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


Responses

Posted by: Sheonarayan on: 8/18/2014 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
Service broker has many other stuff to do apart from what you needed for your application. It provides several other supporting feature in SQL Server like database caching etc. As this is nothing but a service running on your machine constantly so there would be some performance impact on your server however not major impact.

However if you are struggling with resources on your server you may notice some performance issue.

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Santosh.Impossible, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response