Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-15 : 08:39:34
|
| Kapil writes "Hi..I am running SQL 2k on a Win NT server spk 6.0. The server also runs the IIS 4.0 and is basically a web server having SQL server installed. The server boasts of 512+256 MB RAM. Problem:After a fresh server restart,the RAM usage of SQL server increases to towering limits. Of course this happens gradually.F or this I had a fresh server restart and stopped all applications and owing to a weekend, the IIS usage was also extremely low.. The RAM usage increased from 150 MB initially to 300 MB in 2 days without any application running on the server.Usage of SQL Server:The SQL server is being used for simply rendering the data to the ASP pages using stored procedures and for user authentication when a person logs on to the site. All code optimisation techniques have been taken care of and I am still not able to understand the reason for the increase and the memory not being released back.During the weekdays, the server runs a stored procedure that inserts about 1000 records every 5 minutes for 5 hours. By the end of the week,the server RAM usage touches 600 MB alone and the server goes for a spin and often needs a reboot.In fact today the total server RAM usage was about 820 MB with 600 MB being taken by SQL server alone.I have been looking for a solution since a very long time but no real solutions so far.Please help me out here if possible.RegardsKC" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-15 : 08:43:57
|
| The only way to prevent SQL Server from grabbing too much RAM is to set an upper limit on how much RAM it can use. You can do this through Enterprise Manager; right-click the server and choose Properties, then go to the Memory tab.You can also use sp_configure with the 'max server memory' option. This is detailed in Books Online. |
 |
|
|
|
|
|
SQL Server 2K memory not being released