Performance issue from SP

Last Post 03 Jun 2008 10:59 AM by Jiangxi. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Jiangxi
New Member
New Member

--
03 Jun 2008 10: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.
You are not authorized to post a reply.

Acceptable Use Policy