How to improve execution time for SP

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

How to improve execution time for SP

Author

Topic

GaneshRamanan
Starting Member

40 Posts

Posted - 2011-10-03 : 08:44:39

Hi,

can anyone help me in this issue, my sp is running for one minute, the application gets time out error. can anyone help in this regards, i runned the profiler to trace and as per suggestions, I have created Indexes.

But still I m facing the same issue.

Can any one help me...for increase the execution time.

Thanks,
Ganesh Ramanan

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-03 : 08:51:05

did you analyse the execution plan of sp? were you able to identify the costly steps?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2011-10-03 : 08:54:20

Change the timeout propoerty in your application will solve the problem

SqlCommand1.CommandTimeout = 500000

But, still its not a right way to do it, Its a workaround . You have to fine tune Server/query. Performance degradation may happen because on N number of reason(not only Query).

Senthil.C
------------------------------------------------------
MCTS - [Microsoft][ODBC SQL Server Driver]Operation canceled

GaneshRamanan
Starting Member

40 Posts

Posted - 2011-10-03 : 09:21:53

Dear Senthil,

I m DB Admin, I already gave them suggestion to increase the time limit, as per the Recommandations I solved the issue, but the issue still persists, is there any other solution to increase in DB Level.

Thanks,
Ganesh Ramanan

Kristen
Test

22859 Posts

Posted - 2011-10-03 : 09:59:58

"is there any other solution to increase in DB Level."

yeah, optimise the procedure starting with Visakh's suggestion. Tell us what that reveals, post the code here, and folk will make suggestions.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources