Concurrent User Limitations in Warehouse

[animeshdada]

Planning to implement Medallion with Fabric warehouse as the good layer. What's limit of concurrent users trying to access the Fabric warehouse tables? Got F64 capacity in place.

[AndyDDC · Accepted solution]

Hi @animeshdada there are currently no published numbers from Microsoft in terms of concurrent connections.  But the SQL engine that backends the Fabric Warehouse service is based on the Synapse Serverless engine, that engine could support up to 1,000 concurrent active sessions with users running "lightweight" queries.

In the world of Fabric, it's going to depend on how much capacity each user request is going to use.  I would say that capacity would run out and bottelneck way before any SQL concurrency limits would be hit.

In conclusion the more "lightweight" each user workload and few capacity units used, the more concurrent workloads can be run.  Once users are running more CU intensive workloads, if the CU usage bursts significantly past the F64 capacity limits, then throttling will occur.