SQL Server Performance

.net and Sql Server

Discussion in 'General DBA Questions' started by sambino, Sep 18, 2004.

  1. sambino New Member

    We are having a memory problem with our SQL Server box
    Our Layout is a Win 2003 Server running the front end sites and a 2000 Box with 1.5 Gig Ram only running Sql Server this keeps running out of memory and SQL is taking all of it.
    It used to be fine until the developers started using VB.net to develop sites.
    They have check the code and it appears to do as it is told but after queries Sql Server seems not to free memory and it keeps demanding more till the box runs out and stops responding And ideas greatfully received

    Sambino
  2. Argyle New Member

    Are you running IIS and SQL server on the same server? If so limit the ammount of memory the SQL Server can use to about 800 MB RAM and leave the rest for IIS and the operating system.
  3. Twan New Member

    Are you able to monitor things like number of connections, etc to see what it is that sql is holding on to? if there any text column manipulation where the column pointers are not being released, or xml processing where the xml handle is not being cleaned up? It sounds like an application leak rather than sql itself?

    Cheers
    Twan
  4. satya Moderator

    IF possible differentiate the IIS & SQL on different machines for performance purpose.

    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.

Share This Page