SQL Server Performance

Regenerate memory in SQL!!!

Discussion in 'Performance Tuning for Hardware Configurations' started by Paulovsky, Mar 30, 2005.

  1. Paulovsky New Member

    Hello, guys
    I'm new on this, but i have 2 questions for you.
    I'm using xseries206 3.0Ghz / 1Gb Ram /3 73gb 10k(RAID 1 S.O. + aplications in separate drives, but in same disk).My database is 10gb file, for about 30 people.I have a problem of performance of course!!!!My questions are, what should i do improve with this hardware, or what you should i buy!!!!???The second question is, does sql server standart edition/Windows 2000 Server, regenerate the memory?It's because, when the sql server process (sqlservr.exe), achive the total of memory in server -1 Gb- i have to make a reboot of the sql server services to re-estabilish the normality.
    Do you have any recommendations?




    Paulo Soares
  2. Luis Martin Moderator

    SQL try to get all memory he can, and that is normal.
    If you don't have a SQL server dedicate, then you can adjust max SQL memory (see sp_configure in BOL).

    About performance, I suggest to run Performance Monitor to and Profiler, you can find lot of articles in our forum.

    Luis Martin

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell

    All postings are provided “AS IS” with no warranties for accuracy.

  3. satya Moderator

    If SQL Server is the only application on the server, MIN SERVER MEMORY and MAX SERVER MEMORY to the same value and that means leave the memory settings to DYNAMIC. If SQL Server co-exists with one or more applications, lower the MIN SERVER MEMORY setting to count for the memory demands of the other application(s).

    If the other application fails to start in a timely manner, it may be because SQL Server has been operating at or near the MAX SERVER MEMORY setting and is slow in releasing memory to the new, and now starved, application. In this instance, lower the value of MAX SERVER MEMORY. Obviously, MAX SERVER MEMORY always needs to be greater than or equal to MIN SERVER MEMORY.

    Links and KBAs for your reference


    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page