Post reply

amount of free memory in sqlserver?

  • January 23, 2012 at 11:42 pm

    #255343

    Hi,

    How to calculate the total amount of free memory (when the system is idle and SQL Server is running)

    Total RAM 4 GB,

    Max memory setting 3200 MB in SQL server,

    Min memory setting by default 0.

    other memory option

    Min memory per query execution 1024 KB.

    thanks

    ananda

  • January 24, 2012 at 9:36 am

    #1437771

    Take a look at Perfmon counter 'Memory\Available MBytes' to find how much memory is free on the system. It is nice to have at least 1 GB of free memory but given the your configuration I doubt if you will see that.

    Regardless of how much you have set the max server memory, there are some restrictions on how much memory SQL Server can use. These restrictions are based on the OS/SQL Server version and edition. If you can give that info then it would be easy to tell you the max memory SQL Server can use.

    Based on the fact that you have posted on SQL Server 2008 Admin forum, I assume that you have SQL Server 2008 on a Windows 2008 server.

    http://saveadba.blogspot.com/

    Blog
    http://saveadba.blogspot.com/

  • January 25, 2012 at 2:43 am

    #1438143

    Here are some queries to get memory usage details.

    SELECT cntr_value/1024 as 'Memory used in mb'

    from master.dbo.sysperfinfo

    where object_name = 'SQLServer:Memory Manager' and

    counter_name = 'Total Server Memory (KB)'

    DBCC memorystatus() --this gives overall view of memory consumption

Viewing 3 posts - 1 through 2 (of 2 total)

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