Hello everyone,

I have a S0 level Azure Sql database. On my pc, i have also sql express installed which has a stored procedure below;

Insert into [azur].[i-barman-sales].[dbo].[CocktailSales] ([machine_id],[Beverage_Name],[date],[kayt_id]) select [machine_id],[Beverage_Name],[date],[kayt_id] from [ibarman].[dbo].[kaytlar] where Beverage_Type='BEVERAGE' and sent='false'

update ibarman.dbo.kaytlar set sent='true'

I have a linked server on my sqlexpress database and with this sql insert query i am trying to copy my data to sql azure database but its not working good. Its taking longer than 10 min to insert only one column. I have about 500 columns to insert everyday and i could not find the solution. Do i have a problem with the query or do i need to make some settings on azure server ?

Thanks for your help
Ates

Edit: My stored procedure is located in MSDB database and i am calling this procedure from delphi.

• Edited by Ates Gokdemir Friday, August 28, 2015 7:39 AM

I found the problem. The problem was triggers on azure server. I disabled the trigger and now it works fine. DTU level is max %17 now. With triggers DTU level is rising up to %98.

Thank you for your advice.

• Edited by Ates Gokdemir Friday, August 28, 2015 12:58 PM