Memory problem

[akinia]

Hi every one,

We got some troubles with our SQL server 2000. Our technicals made the setup of SQL Server Enterprise on a Windows 2000 Terminal.
We have on this server some SQL Databases, all using the same application.
After few access to one of these DB, doesn't matter which one, the virtual memory and memory usage become huge and finally we need to stop the services and restart them to return to a normal situation.

Any idea about that problem will be really appreciated.

Thanks in advance.

 

[Corran007]

you installed it via terminal services? ive had problems with other server applications installed via terminal services.

if you can, you may want to try reistalling it not via terminal services.

 

[SQLSister]

SQL Server is supposed to - by design - take up as much memory as possible. This is why it should never be installed on a server which is running any other applications. It caches lots of information to speed up processing.

While it is possible to limit the memory usage of SQL Server, it is not generally recommended. But if you must, go to Enterprise Manager and right click on the server name and select properties.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief