Running SQL2008 R2 32bit on Windows Server 2003 Enterprise with 12GB of RAM. Inside the Memory settings of the SQL instance I've got max memory set to 10000MB but it isn't going past 1.6GB according to the following query.
SELECT object_name,counter_name,instance_name, (cntr_value/1024) as Memory_in_MB, cntr_type FROM sys.dm_os_performance_counters WHERE counter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)')
Am I running into an issue due to the 32 bit OS/SQL install? Or do I need to configure something additional to allow it access to more than the 3GB? Windows is detecting 12GB.