Q: SQL Performs Slower on Azure I deployed my application on Azure, The database I created on Azure runs query slower. On Actual Server My query runs in 0.45 seconds and on SQL Azure My query runs in 14 second. Following is my query
DECLARE @serialNum NVARCHAR(MAX) = '0075'
DECLARE @serialNumSelected NVARCHAR(20) ,
@sku NVARCHAR(20) ,
@description NVARCHAR(100) ,
SELECT  @serialNumSelected = t1.SerialNum ,
    @sku = t2.SKU ,
    @description = t2.Description ,
    @animateAssigneeId = t1.AnimateAssigneeId ,
    @inanimateAssigneeId = t1.InanimateAssigneeId ,
    @numLabels = t3.NumLabelsPrinted ,
    @isPersonal = ( CASE WHEN LOWER(t4.Name) = 'personal' THEN 1
                         ELSE 0
                    END ) ,
    @dateDueBy = t1.DateDueBy
FROM    ( SELECT    t1.SerialNum ,
                t1.RubberGoodSKUId ,
                t2.AnimateAssigneeId ,
                t2.InanimateAssigneeId ,
                t2.DateDueBy
      FROM      dbo.SerializedRubberGoods t1 WITH ( NOLOCK )
                LEFT JOIN ( SELECT  * ,
                                    ROW_NUMBER() OVER ( PARTITION BY SerializedRubberGoodId ORDER BY DateTested DESC ) AS rn
                            FROM    dbo.SerializedRubberGoodsCycles c WITH (NOLOCK)
                          ) t2 ON t1.SerializedRubberGoodId = t2.SerializedRubberGoodId
                                  AND t2.rn = 1
    ) t1
    INNER JOIN dbo.RubberGoodSKUs  t2 ON t1.RubberGoodSKUId = t2.RubberGoodSKUId
    INNER JOIN dbo.RubberGoodTypes t3 ON t2.RubberGoodTypeId = t3.RubberGoodTypeId
    INNER JOIN dbo.RubberGoodCategories t4 ON t3.RubberGoodCategoryId = t4.RubberGoodCategoryId
WHERE   t1.SerialNum = @serialNum
OPTION  ( RECOMPILE )

Can anyone help please as soon as possible
I shall be thankful
Thankx

A: You need to increase the DTUs on your Azure SQL Server instance or use a bigger virtual machine.  I am guessing here, but likely your on site server is beefier than the one you allocated in Azure.
