Forum Discussion

jamesneal's avatar
jamesneal
New Member
2 years ago

Limiting Distributed Requests

I have quite a few dynamic sql statements that are being executed via sp_executesql and would like to limit the number of distributed requests when they are submitted.   It appears MAXDOP doesn't wo...
Data Warehouse
jamesneal6927's avatar
jamesneal6927
New Member
2 years ago

No, I'm not trying to work with MAXDOP. 

Since Fabric, as it is today, shares a connection pool to pass 'Distributed Transactions' to the backend processors I would like to manage the throttling of those calls per thread.  I'm using 20 thread FOREACH loops that need to be able to limit how many connections each can use.  That is a simple MAXDOP call in SQL Server; not in Fabric so...

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi jamesneal6927 

 

Thanks for using the Fabric community and reporting this . 

I have reached to the internal team for help on this. I will update you once I hear from them.

 

Appreciate your patience.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi jamesneal jamesneal6927 

     

    Apologies for the delay in reply from our side.  

    Sorry for the inconvenience, currently MAXDOP is not a Fabric (or Synapse) concept. There are no plans to support request limiting at this time. We can certainly keep an eye on it for upvote.

     

    Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.