| Author |
Topic |
|
bpsintl
Posting Yak Master
132 Posts |
 Posted - 2009-04-14 : 12:14:03
|
| I have a production db running on sql 2008 express. It's not massively busy yet so I have auto close set to true in db options.Is that a bad thing? IF I set it to false and there was no db activity for a while, would that not be bad for server resources etc? |
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2009-04-15 : 09:34:52
|
| Anyone? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-15 : 10:01:58
|
Yes. It is mostly bad for performance.When all users are logged out and next user logs on, it will take some time to open the database again.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2009-04-15 : 10:09:26
|
| So are you saying to leave auto close to true or false? I don't notice any performance hit by leaving it to true at the moment |
|
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2009-04-27 : 11:10:59
|
| If I set autoclose to false, and there is no db activity for a while, will that use up much server resources etc? |
|
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2009-04-29 : 16:01:40
|
| Anyone? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2009-04-29 : 16:19:06
|
| Is there no negative effect on server resources if there is a period of no website activity, ie the server keeps the db connection open etc? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2009-04-29 : 16:34:25
|
| Ah ok, wasnt sure. If they use very low resources when idle I'm not too bothered |
|
|
|
|
2008 Express - Auto Close?