none
这样调整下配置是否会好点? RRS feed

  • 问题

  • Windows 2003 标准版,SQLServer 2005标准版

    服务器内存 4G,现在通过任务管理器查看可用内存还剩余1300MB。没有启用/PAE参数。

    但是通过性能计数器监控:SQL Server:Buffer Manager Page life Expectancy和Free pages 都很小,基本上都是在200左右。这两个值过小,显示存在内存压力。

    是有有必要通过启用/PAE参数,让SQLServer使用更多点的内存,使得

    SQL Server:Buffer Manager Page life Expectancy和Free pages 的数值变大?


    If you haven't all the things you want,be grateful for the things you don't have that you didn't want.
    2011年6月22日 8:25

全部回复

  • Sql2k5 standared edition can only use 2gb memory, and /pae works on machine with more than 4gb memory.
    2011年6月22日 13:17
  •     1,首先,确定你给sql server分了多少内存,比如,是不是max server memory就限定死了.

        2,如果确认确实sql server有内存压力,当然开启/PAE更好,不过建议设置max server memory,以便防止OS分页. 这样实际也是给SQL server的MemToLeave留出内存


    phil_he
    2011年6月23日 3:21
  •  

    你好 Wison, 

     

    请问您的操作系统和SQL Server是32-bit还是64-bit?请参考下列文章来配置SQL Server Memory:

    http://www.eraofdata.com/blog/sql-server-memory-configuration/ 

     

    /PAE

    To address more than 4 GB of RAM on 32-bit Windows, the OS needs to have the /PAE switch added to the boot.ini file, although if your system supports hot-swappable memory you won’t need to add this as Windows should automatically be able to see the additional memory. If you’re not sure, take a look at how much memory the OS can see via System properties; if you have more than 4 GB installed and the OS is only showing 4 GB, review your boot.ini settings. I’m not mentioning specific Windows versions because the /PAE switch applies to all current 32-bit versions of Windows.

     

     

    Thanks,
    Weilin Qiao

     


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    2011年6月28日 5:44
    版主
  •     1,首先,确定你给sql server分了多少内存,比如,是不是max server memory就限定死了.

        2,如果确认确实sql server有内存压力,当然开启/PAE更好,不过建议设置max server memory,以便防止OS分页. 这样实际也是给SQL server的MemToLeave留出内存


    phil_he

     

    1:给sqlserver是自动分配的内存,所以最大的只能使用到1.7GB

    2:如果开启了/PAE参数,那么肯定会设顶max server memory的,因为机器本身只有4GB的内存。



    If you haven't all the things you want,be grateful for the things you don't have that you didn't want.
    2011年6月28日 8:18
  • /pae does nothing on machine with 4gb memory.

    2011年6月28日 12:51