SQL Server Performance

High memory utilization

Discussion in 'Performance Tuning for Hardware Configurations' started by hojeemdia, Jul 5, 2004.

  1. hojeemdia New Member

    Hi,
    I have installed SQLServer in Pentium III 512 Ram. When I Started my server the utilization of SQLServer is 90 MB, but after days this utilization go to more than 200 Mb.
    This is Normal? If not how to solves this problem?
    I think that this is cause of the server hangs with the message "Server Is Unable to Allocate Memory from the System Paged Pool".
    Thanks
    Flávio
  2. satya Moderator

  3. hojeemdia New Member

  4. satya Moderator

    What kind of application is hosted to connect SQL Server?
    Are there any other applications sharing the resources on SQL Server?
    What are the memory settings defined fro SQL?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. Luis Martin Moderator

    Also, how many users?
    Database size?
    OP, SQL server and sp?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

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

  6. satya Moderator

    ... and also collect PERFMON (SYSMON) counters for Physical disk, memory, process, processor & SQL Memory for assessment.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  7. gaurav_bindlish New Member

    SQL Server memory architecture allows you to take it the maximum memory on the box as long as there is 5-10 MB for the OS. This does not mean that SQL Server needs the memory shown in task manageer / performance monitor at given time. Also the memory is released if OS or other application on the box needs it.

    200 MB on 512 MB box is fairly low. Is there any other application on the box? If there is, have you ever calculated the amount of memory needed for that application to run?

    You can limit the memory available to SQL Server by setting the max server memory option.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  8. hojeemdia New Member

    Hi,
    Thanks for the attention of all. As I am not expert, go to try to obtain the data and will answer in briefing.

    Flavio
  9. johnny_bigu New Member

    Hello Flavio,

    When I was tunning a new application, I had the same problem, because two things:
    - Anti-virus software(in this case, old version of NAV);
    - W2K and SQL2K service packs (the most important is W2K service pack lastest version).

    How to discover this information?

    Find out google.com, keyword "how to determine sql server version".
    http://www.google.com/search?q=how ...rsion&ie=UTF-8&hl=pt&btnG=Pesquisa Google&lr=

    or directly
    http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

Share This Page