Help

From: Noorali Issani (naissani_at_softhome.net)
Date: 03/06/04

  • Next message: WJH: "Re: Login fails. Login failed for user 'LAPTOP\ASPNET'" 
    Date: Sat, 6 Mar 2004 10:08:48 +0500

     There is 2 GB available on sever, but this area gets
     filled very quickly, hardly 200 MB of space remains
     and when we restart the server or refresh the Sql
     server services it frees the memory, but within 12
     to 14 hours it again fills the memory. What is this, any
     idea? Can anyone give me a clue, what to look for?

     I know that when sql sever grabs the memory it does
     not release it until any other application demands
     more ram. We are using many stored procedures does
     this have to do any thing with it. There is lot of
     network trafic as well in and out of sql server.

     We are using Windows 2000 with service pack 4 and
     Sql server 2000 standard edition with service pack 3,
     with 2 GB physical RAM.

  • Next message: WJH: "Re: Login fails. Login failed for user 'LAPTOP\ASPNET'"

    Relevant Pages

    • Re: FTS Performance in SQL 2005
      ... I don't think you have left enough memory for the OS and MSSearch. ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
      (microsoft.public.sqlserver.fulltext)
    • RE: Insufficient memory Available
      ... Insufficient memory available. ... within the scope of SQL Server. ... "MemToLeave" area. ...
      (microsoft.public.sqlserver.server)
    • RE: server problems
      ... This newsgroup only focuses on SBS technical issues. ... >Thread-Topic: server problems ... >> web proxy service or SQL Server will normally use large memory. ...
      (microsoft.public.windows.server.sbs)
    • RE: server problems
      ... > web proxy service or SQL Server will normally use large memory. ... > the SBS server and sends the alert when the value reaches the threshold. ...
      (microsoft.public.windows.server.sbs)
    • RE: SBS 2003 Unable to connect to database STS_Config
      ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
      (microsoft.public.windows.server.sbs)