jwcolby
jwcolby at colbyconsulting.com
Wed Nov 3 18:57:43 CDT 2010
OK, I did pare back the memory to 24 gigs and now the same query only uses 90% of the memory. Of course it is back to back runs so it may already have cached some stuff. John W. Colby www.ColbyConsulting.com On 11/3/2010 7:02 PM, jwcolby wrote: > My SQL Server machine currently has 32 gigs of RAM and 8 processors. In the properties for the > server, memory tab, I am telling SQL Server that it can have 26 gigs and 6 processors. I am > currently running a microsoft VM on that server which needs 3 gigs and one processor, and I also > want to leave the OS itself some memory (let's say 3 gigs). > > When I run a complex query I get physical memory usage climbing to 30.9 gigs (96%). I am wondering > if I need to drop the memory assigned to SQL Server. >