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
 SQL Stored Procedure unfortunately Runs Slow

Author  Topic 

mnar0930
Starting Member

1 Post

Posted - 2014-07-16 : 21:21:46
Hi To All,

Good Day,

Im just trying ask for your help.

My Stored procedure have long runs and not having a problem, but in recent days he suddenly slowed, what should be the possibilities of this problems?

I hope somebody can give me advice.

Thank you very much

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-07-16 : 21:33:20
Out-of-date stats
bad parameter sniffing
bad execution plan
heavily fragmented indexes
hardware bottleneck
so many other things
...

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-07-17 : 03:05:19
Perhaps the statements in the procedure is written in RBAR style and not set-based fashion?



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-07-17 : 07:00:30
and there would be no help to you unless you post DML DDL and execution plan

Hope this helps

Regards
Shanky
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-07-19 : 02:43:02
Adding to suggestion above - has the workload increased?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -