we are triggering stored procedures in Azure synapse analytics, it is taking 14 hours to success the data transformation .so our concern is Long running Stored procedures will impact on Azure costing facter ?
Long running Stored procedures will impact on Azure costing facter ?
Hello @rajivgandhiveerabathiran-3463,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is ong running Stored procedures will impact on Azure costing facter , please do let us know if its not accurate.
I am assuming that you are refering to dedicated SQL , Yes this will impact the Azure bill . Irrespective of which plan you are going with , since everything is charged at hourly rate , this will increase the azure bill .
More here : https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/
Please do let me if you have any queries.
Thanks
Himanshu
Please don't forget to click on
or upvote 
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is howWant a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
Addendum:
In terms of pipeline activities, the Stored Procedure activity does not care about duration, and is a flat fee. This is because the compute is not being done by the pipeline's compute, but by the SQL's compute where @HimanshuSinha-MSFT 's assessment comes into play.
If you are talking about the stored procedure option in Copy Activity, then yes the pipeline costs increase too.
7 people are following this question.
