Post reply

Finding memory on sql server instance

  • April 6, 2012 at 2:55 am

    #271591

    Hi Friends,

    in my sql server there are 10 named instances are there in that How to find out how much memory each instance is using on a sql server 2008?

    i don't want to go to each instance find " select serverproperty ('process id')

    i want to get the data memory in easy way?

    Thanks

    Venkat

  • April 6, 2012 at 8:43 am

    #1470137

    If they are on the same physical server you can use task manager (processes tab) to see the memory that is allocated to each sqlservr.exe. May need to click on "Show processes from all users" to see them. If each service is running with a different user, it will be easy to tell which instance is which.

  • April 6, 2012 at 8:50 am

    #1470142

    with 10 instances, i would also be concerned about how much RAM is on the server plus what each instance has its Maximum server memory settings to.

    if you are asking how to look because of issues, the Maximum server memory should be set on each instance with the totals not exceeding the server memory limits minus 2 GB.

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

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