• Did you run the SP or did you run the T-SQL code which is part of SP?

    If it is latter, I'll agree with Lowell's second point. It's highly likely due to parameter sniffing.



    Pradeep Singh