Windows Server 2008 SBS (SQL Server 2008 service uses 1.4 GB RAM). Why??? RRS feed

  • Question

  • Hey!

    I installed my first server system (win server 2008 SBS). Yupie! Well I must have missed something, since I am having problem with SQL Server service.
    I installed:
    - Win server 2008 SBS x64 (premium license)
    - Exchange 2007
    - SQL Server 2008

    Everything works well, but:
    My server machine has 8GB of RAM installed. After I restart, all my services are using  2.29 GB of RAM. After a while (few hours) around 7.3GB is used.
    Checking task manager and services running shows:

    sqlservr.exe (NETWORK SERVICE)    1.410.500K (RAM)       SQL Server Windows NT - 64 Bit
    store.exe  (SYSTEM)                           623.568K (RAM)       Microsoft Exchange MDB Store
    sqlservr.exe*32 (SYSTEM)                  605.704K (RAM)        SQL Server Windows NT
    sqlservr.exe (ServiceSQL)                   547.220K (RAM)       SQL Server Windows NT - 64 Bit

    There are even more services using around 200MB, 100MB,.... but I think those above are the most important.

    I think I need to check the sql server configuration, but I am lost...

    There are no other SQL Databases on the server (just those needed for exchange).
    CPU usage is low: 2-8%
    Server's current rolles are:
    - AD Certificate services
    - AD Domain services
    - DNS
    - DHCP
    - File services
    - Web (IIS)

    btw: I set sql server to use max 700 MB RAM (using sql server enterprise manager). But it seems that this doesn't work either.

    Am I missing something here or is this normal behavior.

    Tuesday, September 1, 2009 11:23 AM

All replies

  • Hi Beer,

    If you restart SQL Services then SQL Server will take Max 700 MB RAM.

    Deepak Goyal
    Monday, September 7, 2009 7:12 AM
  • Hey,

    I have restarted my machine (because of hardware upgrade).
    I believe all SQL services were restarted.

    What would be the normal memory usage if only exchange 2007 is running and using sql server.
    No databases.
    There are max 10 clients (mailboxes), 400 mails (average) per mailbox (size max 50 MB).

    I guess there should be a log file on sql server to explain what is happening.
    I need to explore that.

    Thanks for your answer.
    Wednesday, September 9, 2009 7:02 AM