I have SQL Server Express on an AWS micro instance. These instances have only 615MB of RAM. For the most part it performs fine. My application can make up to about 15 db connections. However, every once in a while it just freezes for a couple of minutes.. my own application logs show all kinds of query time-outs, new db connection attempts failing because of an incorrect pwd (even though I am sure the attempt is using the correct pwd). But after a couple minutes everything turns out fine again.
I have checked
eventvwr.msc logs but it doesn't reveal anything. I know there are not backups running at the time. And I have inspected SQL Server logs from SQL Server Management Studio but these too don't reveal anything.
Any ideas? Am I pushing the limits of SQL Server? I have read before the Express Editions run fine until certain connection thresholds get met. Could the number of db connections be an issue?