Post reply

do i have a memory problem on the server

  • June 16, 2008 at 1:48 pm

    #829463

    colin Leversuch-Roberts (6/16/2008)

    ok - forget task manager and get process explorer - never understand why so many dba's look to task manager for memory usage - it doesn't get it right!

    There are some good blog posts about x64, including my own blog, http://sqlblogcasts.com/blogs/grumpyolddba/

    I figure that 4gb for the o/s is the bare minimum you should allow, I usually allocate 6gb - it's quite an interesting subject and disabling HT would probably free up around a gb of ram allocated to the schedulers and worker threads.

    Colin - note, the OP only has 6GB of memory available on this server so I think allocating no more than 4GB to SQL Server should leave enough memory for the OS. The original memory setting was 5200MB which definitely was not leaving enough for the OS (IMHO).

    I definitely agree about HT - never have found a reason to keep it turned on, but have found multiple reasons to turn it off.

    Jeff

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • June 19, 2008 at 12:53 am

    #830918

    colin Leversuch-Roberts (6/16/2008)

    ok - forget task manager and get process explorer - never understand why so many dba's look to task manager for memory usage - it doesn't get it right!

    There are some good blog posts about x64, including my own blog, http://sqlblogcasts.com/blogs/grumpyolddba/

    I figure that 4gb for the o/s is the bare minimum you should allow, I usually allocate 6gb - it's quite an interesting subject and disabling HT would probably free up around a gb of ram allocated to the schedulers and worker threads.

    I must admit using task manager is one of the bad habits I can't get rid off.

    Off course process explorer is more reliable.

    http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

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

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