"Orlando" <anonymous@discussions.microsoft.com> wrote in message
news:1cd5701c45317$f9572e50$a101280a@phx.gbl...
> Hello there, my datawarehouse uses SQL 2000 enterprise as
> database. When the ETL process runs it takes all the
> memory of my server (aprox 2gb) and when it finish, the
> memory stay freeze, an the task manager shows that the
> MSSQL still using the memory and this takes a long time,
> so I have to use the NET STOP to free the resources and
> memory. What can provocate this situation?

Nate Shedd wrote:
> You may be allowing SQL Server to use too much memory on your server. We had
> a similar problem with processing Analysis Services cubes. On the SQL Server
> Properties dialog Memory tab, set the Maximum (MB) to less than the full
> amount. For example, if the slider has a range from 4MB to 2048MB, you could
> set it to 1500MB.
>
> "Orlando" <anonymous@discussions.microsoft.com> wrote in message
> news:1cd5701c45317$f9572e50$a101280a@phx.gbl...
>
>>Hello there, my datawarehouse uses SQL 2000 enterprise as
>>database. When the ETL process runs it takes all the
>>memory of my server (aprox 2gb) and when it finish, the
>>memory stay freeze, an the task manager shows that the
>>MSSQL still using the memory and this takes a long time,
>>so I have to use the NET STOP to free the resources and
>>memory. What can provocate this situation?
>
>