dbcc memorystatus show me below info, which committed and target are getting the same value
Buffer Counts Buffers
--------------------------
---- --------------------
Committed 871224
Target 871224
Hashed 772616
Stolen Potential 238091
External Reservation 0
Min Free 256
Visible 324096
Available Paging File 789414
and boot.ini has a value as below
[boot loader]
timeout=5
default=multi(0)disk(0)rdi
sk(0)parti
tion(1)\WI
NNT
[operating systems]
multi(0)disk(0)rdisk(0)par
tition(1)\
WINNT="Win
dows Server 2003, Enterprise" /fastdetect /PAE /3GB
C:\CMDCONS\BOOTSECT.DAT="M
icrosoft Windows Recovery Console" /cmdcons
Is this hence that my sql server was configured max to use only this much of ram Target = 871224? can it go larger since I have put 8.5GB of physical ram here
Start Free Trial