• Try profiler to run a trace and see how long does this SP runs every time, this might give you a clear idea