optimization of stored procedures in sqlserver

5 pts.
Tags:
SQL Server stored procedures
Stored Procedures
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Tools4Sql
    I am using stored procedure generator which generates optimized and efficient SPs & queries so that we dont have to take care of small things.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following