Post reply

Memory issue

  • October 22, 2015 at 5:11 pm

    #321715

    Hi All,

    Can any one tell ,how to find the exact memory SQL server is using with in capped memory?

    i.e our SQL 2008 r2 instance is capped with 64 GB(max memory) and i want to know how much Sql is utilizing

    currently memory from the max memory.

    any command and which parameters i need to check.

    Thanks in advance.

  • October 23, 2015 at 2:23 am

    #1835079

    Take a look at sys.dm_os_performance_counters

  • October 30, 2015 at 8:19 am

    #1836702

    I use the command perfmon /report. It should give you everything you need to know about memory. Alternatively, I use Performance Manager, adding counters for SQL Server Databases and SQL Server Memory Manager.

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

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