locked
SQL Memory is configured as dynamic. RRS feed

  • Question

  • Hi All -

    New DB server.  Quad Processor, 8GB memory.  Win2003 enterprise, SQL
    2k Advanced. SQL Server 2000 (SP4 + Fix Awe Memory - version 2040)

    AWE enabled (shows in sql log).

    Ran
    sp_configure 'show advanced options', 1
    RECONFIGURE
    GO
    sp_configure 'awe enabled', 1
    RECONFIGURE
    GO
    sp_configure 'max server memory', 6144
    RECONFIGURE
    GO

    SQL Memory is configured as dynamic.  Min: 1024, Max 6144  
    Reserve Memory - unchecked.

    My worry -

    Prior to doing this, I was used to seeing the sqlservr.exe process use
    approximately 1,700,000KB (as shown in Task Manager).

    Now, it shows 113,000K or so.

    Physical Memory:
    Total 7863628
    Available: 674000
    System Cache: 987216

    PF Usage: 6.36GB

    So, am I configured right?  

    How do I know that SQL is using that memory?  How can I tell if that
    much memory is useful?

    Anything else to do on this box to tweak it?  

    Thanks ahead of time

     

     

    Tuesday, September 12, 2006 12:07 AM

Answers

  • dbcc memorystatus will give you details on sqlserver memory consumption. you can get more info here:
    http://support.microsoft.com/kb/271624

    Tuesday, September 12, 2006 7:35 AM