Surprisingly I've got a problem. Partly compounded by the fact that my production box is in a colo and I can't get great stats on it. The symptoms are under certain conditions the sql engine grows to about 80% of physical memory and then sits there with about 10Mb free, able to perform very light queries but totally unable to run larger queries. Memory is currently set to dynamic and my suspicion is that I am getting stuck on the edge of paging but unused pages are not being aged out because we have plenty of hard drive for virtual memory to grow into. Does anyone have a good reference on the pros & cons of dynamic vs static allocation and any metrics on how much to allocate on a server dedicated to SQLServer.