Odd logs
-
Hi all,
Any ideas on this one? I have 6 servers and on 5 of them the logs look normal (i.e they record backups etc etc and follow a consistent pattern) but on the other one the log looks as below. I don't understand why it says the dbs are beings started, they never stop! Is this something to do with the original setup of the server?
2005-05-20 11:12:24.73 spid53 Starting up database 'Fims'
2005-05-20 11:12:24.73 spid53 Starting up database 'Spintls'
2005-05-20 11:12:24.73 spid53 Starting up database 'FimsII' etc etc
-
check if the databases are set to autoclose
-
Yes, that's it they are. What are the implications of this? Is it a good or bad thing?
-
Really bad. It means that once everybody is out of the database it closes itself. Which doesn't seem really bad, but if you have 200 of those on the same server and you open the database list in EM, you won't even be able to enter one of them because they will constantly open/close. It would be like having to start up your car everytime you hit the accelerator at an intersection.
This can be usefull if you have an heavily loaded server and you need to free up some resources. You could set the the databases that are used only a few times/week to auto-clause so they don't use up too much memory. Other than that it's considered a bad pratice to have that option on.
-
IF the database is no longer being accessed it automatically closes until the next time it is needed. It then needs to "open" for business. If you have this turned off your DBs are "open" for business 24x7.
Auto-close takes more time and possibly resources to open\close all the time...
Good Hunting!AJ Ahrens
webmaster@kritter.net -
Because of the scalability built in SQL Server when the DB is used on a Workstation with MSDE it is actually a good thing because it preserve local resources as much as possible, once the db moves to a Server Class machine you turn that off because chances are that multiple users are going to need access and you want immediate feedback for them
Just my $0.02
* Noel
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply