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 o
f
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 youYou 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/defaul...b;en-us;q321363
http://www.mssqlserver.com/faq/trou...-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 200
0
> 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
>