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.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2013-09-19 : 03:08:52
|
| Hi Experts,We have one stored proc which is taking more than 1 hour to complete,i need to identity the cause why its taking so long to run.Please do share any useful links.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-09-19 : 07:10:05
|
You should enable Actual Execution Plan and see where resources are used.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-09-19 : 08:48:17
|
| Microsoft's documentation on query tuning is quite good. http://technet.microsoft.com/en-us/library/ms176005(v=sql.105).aspxYou should also check to make sure that your database is properly maintained - i.e., statistics are upto date and any fragmented indexes are reorganized/rebuilt. |
|
|
|
|
|
|
SP tuning