Performance Issue with SQL server
-
You need to look at your indices amongst other things. Try using the Actual Execution Plan in Query Analyser to identify where there are problems and take it from there.
Bob Ashfield Consultants Ltd
-
r aa j wrote:
sometimes I am getting impression....sometimes timeout expired..
So you need to understand where your query is taking too long. Check the execution plan as I said. Nobody can do it for you, and nobody can guess whats wrong - except its probably index related.
Bob Ashfield Consultants Ltd
-
r aa j wrote:
sometimes I am getting impression....sometimes timeout expired..
So you need to understand where your query is taking too long. Check the execution plan as I said. Nobody can do it for you, and nobody can guess whats wrong - except its probably index related.
Bob Ashfield Consultants Ltd
-
Run your stored proc in query analyser, check the Query menu options to turn on Include Actual Execution Plan.
Bob Ashfield Consultants Ltd
-
I done that Execution plan.actually that storedprocedure contains 7 queries....for that execution plan its display query cost one 8% ,another 23% etc.... please can u tell me how we can identify
Raaj
Its at this point you need to consult the help. Once you understand what the execution plan is telling you it will enable you to make the necessary changes. You can try taking the individual queries and putting them into the "Analyse Query In Database Tuning Advisor" Query menu item. This will give you some hints at what could be done. Alternativley you could hire someone who understands sql server performance tuning.
Bob Ashfield Consultants Ltd
-
Its at this point you need to consult the help. Once you understand what the execution plan is telling you it will enable you to make the necessary changes. You can try taking the individual queries and putting them into the "Analyse Query In Database Tuning Advisor" Query menu item. This will give you some hints at what could be done. Alternativley you could hire someone who understands sql server performance tuning.
Bob Ashfield Consultants Ltd
-
You're welcome. Performance tuning is a complex topic - some would say its more of a black art than science!
Bob Ashfield Consultants Ltd
That's true, although I've considered it more like playing chess. Next time I go out consulting this area, I'll take my magic wand with me. It'll make an impression (at least somekind...) :)
The need to optimize rises from a bad design. My articles[^]