When should I turn on multi-cluster load balancing on SQL Endpoints?

[User16826992666]

I see the option to enable multi-cluster load balancing when creating a SQL Endpoint, but I don't know if I should be using it or not. How do I know when I should enable it?

[Ryan_Chynoweth · Accepted solution]

It is best to enable multi-cluster load balance on sql endpoints when a lot of users will be running queries concurrently. Load balancing will help isolate the queries and ensure the best performance for all users. If you only have a few users running a handful of queries then it will be less useful.