If we do that, do you think that once we manually run the SPROC, it will have to create an execution plan, which will take the 2 min. that it...

That's what we thought too, so we ran this command to clear the buffers.

DBCC DROPCLEANBUFFERS

I've research a bit more and it seems that maybe we also need to...

I also thought that the duration was displayed in milliseconds not microseconds in Profiler.

Either way, i'm more concerned with finding out why the SPROC runs for 0 seconds...