we have a main web site search that averages 200ms-500ms. There are 4 db servers. every now and then the search will start to freak out and jump to 3 secs, 5 secs, etc... then same searchs are happening. nothing unusual about the searches when it "freaks" out. the "fix" is to capture a sp from profiler, run it in query analyzer 2-3 times. then the searches goes back down in the 200ms-500ms range. explain this. i am investigating the execution plan now cause i assume a nested loop is changing to merge or hash. but why does this happen? why is sql server doing this?