SQL Server 2000 Memory Usage.

From: Vikram (vikram404_at_hotmail.com)
Date: 04/24/04

  • Next message: ericc: "RE: Performance Counter Problem" 
    Date: Sat, 24 Apr 2004 08:49:50 -0600

    Hi,

    The application I am running is a .NET Framework 1.1 Windows Service which
    acts as a Remoting host
    and the actual business components are within COM+.
    The application server is same as the Database Server with SQL Server 2000
    running on the same machine.

    I am monitoring the memory usage for the Windows Service, DLLHOST(COM+) and
    the SQLServer.
    I am observing that the memory usage for Windows Service and DLLHOST
    decreases as well as increases.
    In case of SQL Server the memory usage keeps on increasing. I found out that
    this is by design and SQL Server
    keeps on increasing memory as long as there is free memory. I have seen it
    grow to 800MB-1GB by the end of the week.

    I need recommendation if this is the optimal way of running SQL Server or
    should I set the "Use Fixed Memory Size"
    option ?

    Thanks and Regards,
    Vikram

  • Next message: ericc: "RE: Performance Counter Problem"

    Relevant Pages

    • Re: Windows Services GUI
      ... Open a form from a Windows Service ... SQL Server has a number of Windows Services that run, ... have multiple custom commands defined. ... Remoting Server, in which case you call a method to have it perform some ...
      (microsoft.public.dotnet.languages.vb)
    • Re: FTS query performance on SQL 2005
      ... rather the full-text catalog pages which are cached in the file system cache ... Looking for a SQL Server replication book? ... now all of my queries return in under 1/2 second. ... the memory usage was steadily increasing. ...
      (microsoft.public.sqlserver.fulltext)
    • Re: FTS query performance on SQL 2005
      ... caching mechanism not only for SQL FTS, ... Issue this query ... Looking for a SQL Server replication book? ... the memory usage was steadily increasing. ...
      (microsoft.public.sqlserver.fulltext)
    • Working set increases
      ... Windows Server 2003 EE, .Net Framework 1.1, C# ... I have a problem of memory usage growing continuously. ... my application is a windows service that polls a webservice ... foreach (string ticket in tickets) // tickets is normally empty and the ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: After installing SP 1, SQL Server on SBS 2003 will not use more than 160mb of ram
      ... Then you can monitor the memory usage of the SQL instance. ... the performance of the SQL server is determined by many aspects. ... Microsoft CSS Online Newsgroup Support ...
      (microsoft.public.windows.server.sbs)