Why to hang for long query exection ?

Hi,

I have a stored procedure which is quite big.When i run stored procedure on Windows Azure Sql Database, it running and got hang on a particular point of time.

After that it never showing completion status for the running stored procedure.

Sometime it inserted/updated/deleted all requested data but still showing running/ hang.

How i overcome this hanging problem/ or is there any alternate way to know that query execution completed but it showing hang ?

Please provide some suggestions/options with Windows Azure Sql Database.

Thanks!!

January 9th, 2014 9:26am

Hello,

Slow or long running queries can consume significant system resources and lead to poor performance.
Did you review the query plan and estimate plan when execute the Stored Procedure in the SQL Database Management Portal? You can monitor the CUP and I/O cost with these plan and find the most costly query.
Or you can try to DMV which is support in Windows Azure SQL Database to diagnose the performance problems.

Reference:
Monitoring Windows Azure SQL Database Using Dynamic Management Views
Execution Plans on Azure SQL Database Portal

Regards,
Fanny Liu

Free Windows Admin Tool Kit Click here and download it now
January 10th, 2014 4:46am

Hi,

Can you have a good article link where simple steps provided, here i have not understand very clearly.

Thanks.

January 29th, 2014 10:29pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics