An example:

I've got a stored procedure with 15 select queries. Normally its execution is two seconds; sometimes it becomes 20 seconds. The last time it happend I solved the problem...