Sometimes, the server on which my DB resides starts slowing down. At that point, the CPU is at constant 100%. After a while (usually 2-4 hours later), it all start working great. The application we have is a DB intense app. Here are a few observations I have: * When I look at the number of users connected (when server is slow and fast) is around 100 (sp_who 'app name'). * Some of the same queries that take about 1-3 seconds take about 3 minutes when everything is slow. * I have checked the indexes and they all seem to be OK (I run dbcc ShowContig and then dbcc reIndex if needed) * I update the table statistics of a couple of tables regularly that are heavily accessed (insert/updates). * The DB has 2 processors and 2GB ram and the current DB size is 1.5GB I am not sure what else I should be looking when things slow down? Any tips are greatly appreciated. Thanks for your time.