Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 optimizing stored procedures

Author  Topic 

Trininole
Yak Posting Veteran

83 Posts

Posted - 2012-11-07 : 16:14:49
what are the different methods of optimizing slow running stored procedures?

Roger DeFour

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-11-07 : 17:29:17
1. Checking execution plans
2. Refactoring code
3. Adding/removing/changing indexes
4. Update stats
5. Possible table redesign
6. Check blocking and wait stats
7. Follow best practices
8. If it's complex, I break it up into smaller chunks and optimize each
9. Check stats IO and time
Etc.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2012-11-07 : 17:47:09
10. Hire consultant.

=================================================
We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-11-07 : 17:52:29
11. Post it here and let visakh or Peso optimize it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -