<div>
fine, but i just need to knwo which of these databases consumes that lot of memory
</div>


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

<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
hi experts<br />
<br />
i have a server with SQL Server 2000 installed on it<br />
there is 15 SQL databases hosted on this server<br />
I have noticed in my TaskManager that SqlServer.exe is consuming 1.5Gb memory<br />
<br />
My questions<br />
1 - Is it normal that the sqlserver consumes such amount of memory<br />
2 - how to knwo which of these databases consumes that lot of memory<br />
<br />
thx<br />

</div>
</div>


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


SQL server consuming too much memory 1.5Gb Ram

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.