jwa082276 (3/13/2010)
...a query went from taking 6 secs to 1 min and 45 seconds. I set the max server memory back to 26 gig and now the query runs in 6 seconds.
It is probably not related to the memory change. Have you checked the server error log?
The thing to do here is to compare the actual execution plans. There should be an obvious difference between the two runs. If you are able to post those two .sqlplan files, I would be happy to take a look.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi