Post reply

16 GB of RAM but server slower then ever.

  • June 24, 2005 at 2:03 am

    #152446

    Hi,

    Upgraded our SQL server to 16 GB enterprise version runnin on Win 2003.

    Enabled all the memory which was quicly snapped up by the cache.

    I tested a few processes, which ran at least twice as fast then on the old 4GB machine. There is howeevr a problem somewhere which makes the server run extremly slow for some processes.

    1) Killed an Update process 20 min into it. Expecte the server to recover quickly... but 6 hours later it was still rolling back the transaction. Why?

    2) Used DTS to transfer text files into a temporary databse for processing before they are uploaded into the main DB. While normally it runs very fast, at one time it jsut stood there, hardly moving at all.

    I saw CHECKPOINT process constantly showing in the procees list. And judging by its CPU usage, ti was the only process that actually did any work.

    Is the server having trouble using the memory?

    maybe somethig's wrong with the cache ... or perhaps the phisical memory is damaged?... I can't work that one out.

  • June 24, 2005 at 2:12 am

    #568197

    Hi,

    Have you changed the Boot.ini file to make sure that it uses the available memory

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • June 25, 2005 at 5:45 pm

    #568460

    All the switches are enabled in boot.ini and server config max memory set to 15GB.

    Monitoring software that we use is reporting almost all of it being used for cache.

    this is a really strange one.

    it seems like it has trouble writing dirty pages onto disk.

  • June 27, 2005 at 7:18 am

    #568564

    Hi,

    As you increase the amount of SQL Server memory, ensure that there is sufficient disk space to grow the operating system’s virtual memory support file (Pagefile.sys) to accommodate additional memory.

    Please take care of this. I think 1 GB will not be sufficient for OS.


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • June 27, 2005 at 7:52 am

    #568576

    To further our discussion let me give you a link

    http://regions.cmg.org/regions/mcmg/Virtual%20memory%20constraints%20in%2032bit%20Windows.pdf

    If you can make sql server to use memory dynamically it may be helpful

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

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

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