Post reply

Memory Hogger

  • July 18, 2013 at 9:54 am

    #395164

    I'm running Sql Server 2008 R2. Resource center says i have 200mb available on a 12 gb drive. Doing the math i can see what is being used in the resource list, it only adds up to 2gb. So my question is where is the other 10 gb going? Is there a way i can see what is using it? Or a setting i can set to avoid this? One thing i did do is sql management studio, properties and memory and set minimun and maximum to 6 gb each. This freed up some but over the last two weeks it was all hogged up again.

  • July 18, 2013 at 10:02 am

    #1633705

    Are you talking about a "12 GB drive" as you stated, or a RAM memory ?

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths

  • July 18, 2013 at 10:03 am

    #1633707

    I meant a 12 gigs of memory.

  • July 19, 2013 at 12:38 am

    #1633855

    Sysinternals have several tools that might help. One is ProcessExplorer. Look for WorkingSet column. See here.

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths

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

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