Home / server / Questions / 118367
In Process
DevelopingChris
Asked: 2010-03-03 08:48:36 +0800 CST

sql server using all the memory on the box and throwing timeouts on pedestrian queries

  • 772

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

type queries

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.

windows-server-2008 sql-server-2008 memory

0 Answers