Home > IT Answers > SQL Server > optimization of stored procedures in sqlserver
Naresh1226
5 pts.
 optimization of stored procedures in sqlserver
SQL Server stored procedures, Stored Procedures, Stored Procedures Optimization
is there any stored procedure optimization techniques actually my problem is my stored procedure is getting information from 15 tables by joins and have some conditions in where clause to get 15,000 records it is taking 40 sec how can i improve the my stored procedure thanks, naresh

Software/Hardware used:
ASKED: April 16, 2009  6:15 AM
UPDATED: February 10, 2011  2:09 PM
RELATED QUESTIONS
Answer Wiki:
The first thing I would do is identify the commands that are taking longer to execute inside the procedure. Once identified, I would have a look at the execution plans of those commands to see if the problem could be the lack of one or more indexes
Last Wiki Answer Submitted:  April 16, 2009  2:10 pm  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I am using stored procedure generator which generates optimized and efficient SPs & queries so that we dont have to take care of small things.

Tools4Sql
 10 pts.