jwcolby
jwcolby at colbyconsulting.com
Wed Nov 3 18:02:15 CDT 2010
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. -- John W. Colby www.ColbyConsulting.com