Home Forums SQL Server 2008 SQL Server 2008 - General Memory usage RE: Memory usage

  • December 8, 2012 at 10:16 pm

    #1566859

    mah_j (12/8/2012)

    HI

    In our server when we have time out in select & insert we have lack of memory.

    the total memory is 24G,and free mem is 800M.

    max server memory is 20480 M

    min server memory is 0

    sqlservr.exe gets 500M

    also MsDtsSrvr.exe gets 5G

    I dont have any idea what to do???!!!

    I would't say it's necessarily a memory problem. Most likely, the timeout is caused by improper indexing which can cause large numbers of frequent page and extent splits along with some performance challenged code.

    Post the offending code and the actual execution plan IAW the second link in my signature line below and someone may be able to help.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)