LifeinAsia - 5:28 pm on Feb 12, 2013 (gmt 0)
If it's actually memory related, I would expect SQL to be maxing out the memory.
Depending on which version of SQL you have, fire up Profiler.
Is there a way I can test for long-running queries?
In SSMS, right click on an index, select Properties, and go to Fragmentation. To look at all the indexes on a table, use DBCC SHOWCONTIG (although it's a bit more difficult to decipher):
How can I check index fragmentation levels
DBCC SHOWCONTIG (TableName) WITH ALL_INDEXES