I have a sql server database that is about 10gb, some table are in excess of 10million records. The server has 12gb of ram. There are queries that use indexes and indexed views and most of the time the server hums along nicely.
Occasionally something will happen and the server will lock up for a period of time. I have analysed all the queries that are running on the server and evaluated the execution plans on each - they are fine and usually run fast. However, sometimes the server locks up and I am not sure how to figure out why.