none
Time taken for sp execution from ado.net in some time

    Question

  • 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 ado.net, 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 ado.net.After 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 08, 2018 10:36 AM

All replies