为什么服务器增加了内存,结果用不起来!
先行者79 2005-01-01 03:25:36 原来服务器内存有2G的,现在增加到3G,目前sp_configure的配置如下:
affinity mask -2147483648 2147483647 0 0
allow updates 0 1 0 0
awe enabled 0 1 0 0
c2 audit mode 0 1 0 0
cost threshold for parallelism 0 32767 5 5
Cross DB Ownership Chaining 0 1 0 0
cursor threshold -1 2147483647 -1 -1
default full-text language 0 2147483647 2052 2052
default language 0 9999 30 30
fill factor (%) 0 100 0 0
index create memory (KB) 704 2147483647 0 0
lightweight pooling 0 1 0 0
locks 5000 2147483647 0 0
max degree of parallelism 0 32 0 0
max server memory (MB) 4 2147483647 2867 2867
max text repl size (B) 0 2147483647 65536 65536
max worker threads 32 32767 255 255
media retention 0 365 0 0
min memory per query (KB) 512 2147483647 10240 10240
min server memory (MB) 0 2147483647 2867 2867
nested triggers 0 1 1 1
network packet size (B) 512 65536 4096 4096
open objects 0 2147483647 0 0
priority boost 0 1 1 1
query governor cost limit 0 2147483647 0 0
query wait (s) -1 2147483647 -1 -1
recovery interval (min) 0 32767 0 0
remote access 0 1 1 1
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 600 600
scan for startup procs 0 1 0 0
set working set size 0 1 1 1
show advanced options 0 1 1 1
two digit year cutoff 1753 9999 2049 2049
user connections 0 32767 0 0
user options 0 32767 64 64
由于以前由数据库自动分配内存,内存始终用不起来,我就强制设置为使用固定内存,可是在服务器上任务管理器那里显示,还是没有用起来(内存占用还是以前2G的时候的情况-sql server占用1.8g;现在内存加到3G以后,内存使用还是1.8G,明显不正常)。但是数据库查询里面运行sp_configure得到的结果又是对的。
有人知道为什么嘛?谢谢