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 |
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 |
|
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 |
|
|
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 planHope this helpsRegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
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 |
|
|
|
|
|