memory leak using SQL Server 2000 with IIS5

[LucyP]

I'm running SQL Server on the same machine as my web server (IIS5/win2000 server), but when the site is live and the database is being accessed regularly it causes a substantial memory leak.

I've eliminated all other processes, and tried simplifying all of my SQL (and I don't use any stored procedures, xml, mail or suchlike anyway) but it's still losing around 100Mb per day.

Is there anything I can do?

 

[fluteplr]

SQL Server is just caching data. It is designed to grab as much memeory as is available for the purpose. If for some reason you want to limit the amount of memory it is going to use you can go into enterprise manager right click on the server name and select properties. Go to the memory tab.

Be careful, limit it too much and you are going to take a big performance hit.

Also if this is a production database, I would highly recommend NOT running anything else on the SQL server box, including IIS.