Can't troubleshoot that query without more details on it.

One specific thing to check, though, is that you have limited SQL's use of RAM via the 'max memory' setting, and not left it at the default of unlimited. Performance can become horrible if SQL uses so much memory that you get into memory thrashing between SQL and Windows.