SQL server consuming too much memory 1.5Gb Ram

Posted on 2005-05-17
Last Modified: 2008-01-09
hi experts

i have a server with SQL Server 2000 installed on it
there is 15 SQL databases hosted on this server
I have noticed in my TaskManager that SqlServer.exe is consuming 1.5Gb memory

My questions
1 - Is it normal that the sqlserver consumes such amount of memory
2 - how to knwo which of these databases consumes that lot of memory

Question by:humer2000
    LVL 23

    Assisted Solution

    SQL Server will use as much memory as it can for the tasks it's performing so I wouldn't call it abnormal. It should automatically free some up when the OS needs it, but if you want to restrict how much memory SQL uses you can set this in Enterprise Manager by:
    - Right Click the server
    - Go to Properties
    - Go to Memory tab
    LVL 1

    Author Comment

    fine, but i just need to knwo which of these databases consumes that lot of memory
    LVL 23

    Expert Comment

    AFAIK, you can only tell how much memory SQL Server is using - I've never come across a way to see how much memory a specific database is using.
    LVL 68

    Accepted Solution

    >> Is it normal that the sqlserver consumes such amount of memory <<
    Yes (see below for more details).

    >> which of these databases consumes that lot of memory <<
    No database has to be consuming the memory.  SQL, by default, will allocate most of the memory on the box to itself as it starts up.  This is more efficient that it constantly allocating and deallocating memory.  It is also logical, since SQL assumes that it will be the only (major) application on the box apart from the operating system, and thus will be the app using almost all of the server's memory.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now