0

As mentioned in the Link below,

For client-side applications, query notification users should not exceed ten concurrent users , in SQL Server 2005.

What is the maximum number of concurrent users allowed while using query notification in SQL 2008,2017 and above?

1 Answer 1

1

Let me preface this by saying you should be using a supported version of SQL Server. SQL Server 2008 ended Extended support in 2019 Microsoft Lifecycle Policy

I haven't found any basis for the claim of not exceeding 10 concurrent users. Seems like that is a personal recommendation.

I also haven't found any error messages referencing the limit on the number of queues (or internal tables that are used for the queues).

Anecdotally we were using more than 100 concurrent users for SQL Dependency since SQL Server 2016 and additional Service Broker queues

I recommend testing your required number of queues on your current system.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.