none
Azure insert problem

    Question

  • 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],[kayıt_id]) select [machine_id],[Beverage_Name],[date],[kayıt_id] from [ibarman].[dbo].[kayıtlar] where Beverage_Type='BEVERAGE' and sent='false'

    update ibarman.dbo.kayıtlar 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.
    Friday, August 28, 2015 6:58 AM

Answers

  • 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.


    Friday, August 28, 2015 12:58 PM

All replies