Message "Starting up" in SQL Server Logs

Hello, I'm working with Java and SQL Server 2000, running on a Windows 2000
Server. When the sistem is on-line SQL Server takes more or less than 80Mb of
memory, the app pool connection manage ten (10) conections to the DB, the
time pass and SQL Server takes more and more memory, over 400Mb.
Into de SQL Server Logs (Enterprise Manager-Managment) said that every
minute my database is "Starting up database "xxx"".
If some body knows the answer...
Thank you
You probably have autoclose on for the databases. Turning that off will take care of the "starting up"
messages.
As for memory management, probably normal. See below for more information
INF: SQL Server Memory Usage
http://support.microsoft.com/default...;en-us;q321363
http://www.mssqlserver.com/faq/troub...memoryleak.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dario" <Dario@.discussions.microsoft.com> wrote in message
news:25E04D4F-59ED-4515-8A15-20B37FEED7B9@.microsoft.com...
> Hello, I'm working with Java and SQL Server 2000, running on a Windows 2000
> Server. When the sistem is on-line SQL Server takes more or less than 80Mb of
> memory, the app pool connection manage ten (10) conections to the DB, the
> time pass and SQL Server takes more and more memory, over 400Mb.
> Into de SQL Server Logs (Enterprise Manager-Managment) said that every
> minute my database is "Starting up database "xxx"".
> If some body knows the answer...
> Thank you
>