September 7, 2003 at 9:28 pm
Yay ! got it right,
Wish i had this question AND answer about 4 months ago when i was trying to figure out why my SQL server was running slow when querying list of databases !!!
Would one of the characteristics in trying to debug this issue be that in the log file, All the databases say "starting up database XXXXX" about every 10mins ?
Anyway i thought it was a good question 🙂
------------------------------
Life is far too important to be taken seriously
September 8, 2003 at 6:13 am
I have a Personal Edition of SQL Server 2000 running on NT 4 Workstation.
Auto close and Auto shrink are disabled on all databases on the server, including the system databases and yet I still get the slow down mentioned in the QOD.
I have torn page detection turned on but I had always assumed it was a feature of personal edition, because, if I start the server at 8:30 for example, it spends 4 - 5 minutes starting up and then does nothing.
According to the log it only opens the databases when the first connection
is made to server after start-up no matter how long after start-up that is.
I would be grateful for any suggestions.
September 8, 2003 at 7:36 am
I'm not sure I understand the resoning for this answer.
Taken from BOL
'By default, this option is set to ON for all databases when using Microsoft® SQL Server 2000 Desktop Engine, and OFF for all other editions, regardless of operating system'
We are talking about Personal Edition, not the Desktop engine???
In another part of BOL
'Both the SQL Server 2000 Personal Edition and SQL Server 2000 Desktop Engine have a concurrent workload governor that limits the performance of the database engine when more than 5 batches are executed concurrently'
This makes it sound like these are two different things. So my my resoning Auto Close would not be on for Personal Edition by default?
Can anyone clarify?
Thanks
September 8, 2003 at 7:54 am
I believe this default is to protect database files in a workstation environment where there might be system shutdowns without warning.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply