Hello, Bertrand.
I don't know what could help you with MSSQL. I'm going to do some
experiments - maybe then i'll found something.
Now I can suggest to use MySQL instead of MSSQL. System will work faster
and more reliable.
Alexey.
----- Original Message -----
From: "Bertrand Mercier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 06, 2001 6:53 PM
Subject: Webboard: SQL Server Memory Usage
> 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]
>
>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
