Post reply

How much memory uses by single instance in sql server.

  • February 26, 2012 at 11:36 pm

    #257483

    Hi,

    How i can know, how much memory uses by single instance in sql server.

    Regards,

    Sachin.:hehe:

  • February 27, 2012 at 5:04 am

    #1451987

    expect answer from someone.

  • February 27, 2012 at 5:17 am

    #1451991

    Check this article:

    http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/08/24/troubleshooting-the-sql-server-memory-leak-or-understanding-sql-server-memory-usage.aspx

    java

  • February 27, 2012 at 6:03 am

    #1452018

    As much as it needs, up to the limit you set (max server memory)

    p.s. Be patient. Bumping your post after 6 hours is unnecessary. We're all volunteers, we all post in our spare time here.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 28, 2012 at 7:30 am

    #1452593

    If you do not change the memory settings once you start SQL Server it will consume a bare minimum of memory to just keep it up-and-running. Once you start using it it will begin to put more and more data into memory consuming more and more memory. 32 bit SQL Server will use up to almost 2 gig of memory and the 64 bit SQL Server will consume as much memory as it can get. As a best practice you should know how much memory is in your server, which version of SQL Server (32 bit or 64 bit) and configure memory settings within SQL Server so you leave some memory free for Windows and other applications to grab memory as it needs. The reason for this is you don't want the server spending time swapping things in and out of memory. Depending on how much memory you have in your server it is best to cap SQL Server to allow at least 2 gig of memory for the operating system and other apps to use. Without writing a couple of paragraphs about memory and SQL Server that is bare minimum knowledge.

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

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