Meomory

  • Hi,

    I do have 64 bit operating system and have 64 bit SQL server. Only SQL server is the only one application running in my machine but still SQL server is not utilizing the available memory. Please let me know, What I have to do?

  • How are you determining that SQL Server is not using all the memory you think it should be using?

    Run DBCC memorystatus and search online for the documentation for it and see if you feel differently after reviewing that.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • Sure. Thanks.

  • How much memory is on the server, and what are your min/max memory settings?

  • ramana3327 (1/7/2014)


    ...but still SQL server is not utilizing the available memory.

    This is the expected behaviour of SQL Server. It won't utilize memory unnecessarily.

    Memory utilization depends on load.

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

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