博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

SQL2008 强烈要求限制最大内存

Posted on 2015-01-26 16:54  快乐家++  阅读(778)  评论(0编辑  收藏  举报

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