SQL2008 强烈要求限制最大内存

64位开了AWE没什么潜在问题,另外最大内存设置强烈要求改掉,不要用默认的,一般留2~3G内存给操作系统。你是怎么看到20多G是被awe用了的?

 

如果内存大的话,只留1GB给OS会有问题,可以参考下面的设置:
Physical RAM                        MaxServerMem Setting 
2GB                                           1500 
4GB                                           3200 
6GB                                           4800 
8GB                                           6400 
12GB                                         10000 
16GB                                         13500 
24GB                                         21500 
32GB                                         29000 
48GB                                         44000 
64GB                                         60000
72GB                                         68000
96GB                                         92000
128GB                                       124000 

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。