Post reply

SQL 2008 R2 on a Win 2008 R2 Server only using 4GB of RAM?

  • January 5, 2012 at 1:07 pm

    #250860

    A customer has a SQL 2008 R2 database server running on a Win 2008 R2 Server.

    The machine has 6GB RAM and the SQL Server is configured with MAX Memory set to the default (very large). But SQL is only using 4GB of RAM?

    Anyone ever run into this since the old 32 bit AWE days?

  • January 5, 2012 at 1:37 pm

    #1429339

    64 bit?

    SQL probably only needs 4GB, and also the OS would use some of the 6GB. you should set a max memory value for SQL or you may starve the OS of memory. 4Gb would be a good value.

    ---------------------------------------------------------------------

  • January 5, 2012 at 1:59 pm

    #1429355

    Yes, 64-bit, sorry.

    I realize the OS needs some memory and that the MAX memory should be set.

    I still don't see what is keeping SQL from going over 4GB - just sounds like a 32-bit problem to me. wasn't sure if there was some known issue of some setting that needed to happen or not. I've never had this happen to me before.

    Thanks!

  • January 5, 2012 at 3:20 pm

    #1429394

    whats the value for available memory in perfmon?

    Are you suffering from memory pressures?

    ---------------------------------------------------------------------

  • January 5, 2012 at 3:23 pm

    #1429396

    No, no memory pressures at all.

    I've requested a dbcc memorystatus (and the @@version, just to be sure)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply