SQL Server Memory occupation drastically increasing

[Guest_imported]

In an Intranet Application using Win NT, Apache, Tomcat and SQL Server, the memory space used by SQL Server is drastically increasing and finally the system crashes. Nearly 40 people are accessing the system. The hardware configuration is P2 processor with 393 MB RAM and 2GB Virtual Memory. SQL Server,Web server and Servlet Engine are running on same machine.
Within three hours, SQL Server occupies 200M memory and the system perfomance comes down and finally the system stopes the tomcat servlet engine.
Anybody have any idea on this? We have nearly 1500 JSP pages,200 Bean files and 300 tables in SQL Server.

 

[CoolClark]

1. Go into the SQL Enterprise Manager
2. Right-Clk on the server
3. Select Properties
3. Select the Memory tab

You can limit the amount of memory used by SQL here.

 

[CoolClark]

And thirdly change the second third step to the fourth step