Concurrent User Limitations in Warehouse

Anonymous — Thu, 14 Nov 2024 13:52:03 GMT

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.

Re: Concurrent User Limitations in Warehouse

AndyDDC — Thu, 14 Nov 2024 14:22:11 GMT

Hi Anonymous 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.

topic Re: Concurrent User Limitations in Warehouse in Data Warehouse

Concurrent User Limitations in Warehouse

Re: Concurrent User Limitations in Warehouse