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
