windows Server 2008EE(x64)+SQL Server2008(x64),64G内存重启后两天就被SQL占用79%系统刚装起来,准备搭建业务系统的测试环境,可是过了两天去看。内存利用率高得不行。重启了几次,再过两天去看,又是这样。
求招~
求招~
解决方案 »
- 设置数据库时学号第一个数是0怎么办?
- 问一下DBA薪酬
- 请教SQL查询符合条件的重复记录的方法。例如有数据表有数据列N列假设为A1、A2、A3、A4、....An,有2万条记录,如果......
- [求助 请问 SQL Server 2000 怎样在 Windows Server 2003 SP1 中安装????
- 有关按月份汇总数据的问题
- 13岁小弟学习ASP,找大哥哥帮忙,奖励是充值5元手机话费,呵呵
- SQL SERVER 与oracel连接问题,为什么查不到表?
- 视图问题,请帮忙!
- 横竖字段值交叉问题
- 怎么将纯真数据库导入到SQL SERVER中?
- 关于差异更新问题,求解啊 求解...
- 【万分着急】各位老师,如何跟踪出RDL里面执行的sql???
GO
EXEC sys.sp_configure N'min server memory (MB)', N'1024'
GO
EXEC sys.sp_configure N'max server memory (MB)', N'40960'
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'show advanced options', N'0' RECONFIGURE WITH OVERRIDE
GO
重启什么的完全没有必要
64位的不必AWE
设置10G,留54G太浪费,至少设置55G+
2008设置后不必重启不知道?
应该说64位开AWE不是必须的。
如果log里有page out,还是需要AWE的.
AWE管理内存可以提高sql server安全和性能。
64 位操作系统上不需要 AWE,也不能在该系统上配置 AWE。
这段摘自:http://technet.microsoft.com/zh-cn/library/ms190731.aspx
但SQL Server 2005/2008在设计时,如果配置了锁定内存页,不论你是否配置AWE,都会自动使用AWE管理内存。
通过Select sum(awe_allocated_kb)*1.0/1024/1024 as [AWE allocated, Gb] From sys.dm_os_memory_clerks
可查看awe是否开启。
为什么AWE无法配置?因为启动帐号拥用锁定内存页权限后,AWE会自动配置。
所以说,64位操作系统不必也不能配置AWE
Given what you know about memory and AWE, it would seem that there is no reason for using AWE
on a 64-bit system. After all, a 64-bit system has enough address space to address as much memory as it
needs, so why would you want AWE on a 64-bit system? You can’t even enable AWE in a 64-bit version
of SQL Server; the option is disabled in the user interface.
It turns out that there are some great reasons for using AWE to access your memory, even on a 64-bit
system. The SQL Server team realized that on 64-bit systems they could improve overall performance by
using AWE in a 64-bit environment. They found that using AWE memory allows memory to be allocated
and accessed a lot faster. In addition, the memory cannot be paged out by the operating system.
Because of this, 64-bit SQL Server was changed so even though you can’t enable AWE on 64-bit versions
of SQL Server, if the SQL Server service account has the Lock Pages in Memory advanced user right, SQL
Server will automatically use AWE to access buffer pool memory.
而且最早的标准版不支持锁定内存页而导无法启用AWE的问题,后来也都有了解决办法。
http://www.cnblogs.com/nzperfect/archive/2010/03/29/1699316.html
64位系统+64位sqlserver
64位系统+32位sqlserver(2005 2008 2008r2 略不同)
这个结论是不一样的,32位的sqlserver也可以工作在64位的系统上,wow的问题也需要考虑进去