Krasavita (5/1/2012)
PhysicalMemoryGBVasGBBufferPoolCommittedMemoryGB BufferPoolTargetMemoryGB5.99 8192.00 2.21 3.79
MinServerMemoryGBMaxServerMemoryGB IsAweEnabled
0.00 2097152.00 0
LogicalCpuCountHyperthreadCoreRatioPhysicalCpuCountLogicalCpuOnline
16 8 2 16
Most likely issue is bolded above. You need to set max memory immediately. It does not require a restart and takes effect immediately. Some guidance: Suggested Max Memory Settings for SQL Server 2005/2008[/url]
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato