Author: Bertrand Mercier
Email: [EMAIL PROTECTED]
Message:
Hi all,
First of all, I'm using mnoPRO, for windows 2000, db is SQLServer7.
I properly kill my recorsets, and my database connections in the bottom of each .ASP
page; I putted a session.Timeout and a scriptTimeout of 1 minute when the agent
detected is the search engine.
My problem is about the memory usage of SQL Server, during and after each indexing.
It reaches � 200 MB!! and never slow down after.
Only if I stop and restart the SQL Server Service (and SQL server agent), the memory
used will fall between 10 and 20 Mb (usual).
The problem is that on each indexation (each hour in my case), the sqlservr.exe will
grow (fast, in 30 seconds) to 200 MB.
After some days, I get an error message on my webserver "Your system is running on low
memory blablabla". I just restart sql, and I'm good for 3 or 4 days again.
Any idea ????? (I dont think I must set a connection timeout when I connect to my
database because I kill the connection on the bottom of each page).
Thanks in advance for your help.
Bertrand.
Reply: <http://www.mnogosearch.org/board/message.php?id=3018>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
