SQL server consuming too much memory 1.5Gb Ram

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

thx
LVL 1
humer2000Asked:
Who is Participating?
 
Scott PletcherSenior DBACommented:
>> 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.
0
 
adatheladCommented:
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
0
 
humer2000Author Commented:
fine, but i just need to knwo which of these databases consumes that lot of memory
0
 
adatheladCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.