I have max memory set. But at least 1 time a day the Sql Server hits over 95% of the ram in the box, and page faults for more. In the meantime the website is throwing very obscure timeouts on simple
select count(1) where id=1
I'm a developer and don't normally get into the server administration to this level of detail. So please go easy on the level of your answers.