Post reply

Hight memory usage by SQL SERVER 2008 R2

  • November 12, 2012 at 4:20 pm

    #284705

    Hi Everyone,

    We have SQL SERVER 2008 installed on Windows 2008(server had 512GB memory).I had set the max memory to 480GB.I recieved call about slowness on Recieving data from database and even some useres could not connect to database.When I checked the memory usgae,I noticed that almost all the 512GB was used by SQL SERVER.My Question is Alsthough I had set the Max memory for SQL SERVER(480GB),Why it has passed that limit and used all the 512GB.Second how can I specify what has caused all memory usage ?

    Thanks

  • November 12, 2012 at 4:34 pm

    #1558347

    are you running multiple instances? Also our former server admin had an extra couple of 0's in the max server memory when he first set it up. couple things that have gotten me. as far as seeing why the SQL took up so much ram after the fact its hard to determine but if it happens again you may be able to look at the pages in the buffer pool through sys.dm_os_buffer_descriptors and see what is in the buffer cache.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

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

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