Time taken for sp execution from in some time


  • Hi,

    I have a sql server 2012.I have one SP. If I execute that SP alone in query analyser, the execution happened with in 2 sec.

    But I have used the same SP from, then it will take too much slow to complete execution. This is also happening in in

    some time only, not on every time.

    However, after made SET ARITHABORT ON in database properties, then it was executing very fast like lightening from made as ON, was executing very fast up to 5 days. After 5 days, again it back to too much slow, then again I changed back as    SET ARITHABORT OFF, then again executing very fast like rocket...Why this behaving like inconsistently. Please help to resolve this issue?                                                                                                                                Thanks & Regards, Dileep

    Thursday, February 8, 2018 10:36 AM

All replies