giggle - 3:46 am on Feb 12, 2013 (gmt 0)
Thanks LifeinAsia (I'm in Bangkok - fancy calling around and sorting out the problem yourself! :) )
We have 4gb of memory when I look at the task manager it sits at about 2.7GB usage constantly (don't know if this is normal)
SQLSERVR.exe is top of the list in the Resource Monitor. In the Commit column it's sitting at 1,514,912 - is this figure too high?
Is there a way I can test for long-running queries?
How can I check index fragmentation levels (I run a rebuild indexes process every Wednesday)
Scratching my head!