Long running queries.
-
Could any one help me.what are the necessary steps to be followed to face the long running queries.please help me. Thanks in Advance.
sathish48 wrote:
what are the necessary steps to be followed to face the long running queries
That depends. Is this a web app? Then you'll want to call it asynchronously so that you can provide feedback to client. Most important, do what you can to increase performance.
There are only 10 types of people in the world, those who understand binary and those who don't.
-
Could any one help me.what are the necessary steps to be followed to face the long running queries.please help me. Thanks in Advance.
Assuming it is SQL server AND you are using a stored procedure! Use the execution plan to identify indexes that may be required and identify the high cost parts of the query. You then need to look into the structure of your query.
Never underestimate the power of human stupidity RAH
-
Could any one help me.what are the necessary steps to be followed to face the long running queries.please help me. Thanks in Advance.
Well it's not a step by step process. It all depnds on what are you trying to execute and how the layer is structured. Check for SQL server / query optimization and understand the ways to increase the performance. Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]