Performance issue from SP

Last Post 03 Jun 2008 09:59 AM by Jiangxi. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

03 Jun 2008 09:59 AM
We have a SP with input parameter of date , but we got huge difference excution time between two date , one ( 5/28/08) return 2 seconds, the other (5/29/08) will take more than 1 minute, anyone has ideas where should i check ?

Here are what we have done:

1) runing multiple times, and DBCC FREEPROCCACHE to make sure that both running from scratch.
2) the returing set almost the same size.

Acceptable Use Policy