October 13, 2003 at 7:48 pm
Hmm, I know how much work would be done on our production database if I turned on "read only". I think I would still get a lot more throughput if I turned auto_shrink on than if I turned it into a read only database.
I don't know about other people's production databases, but our's NEVER shrink in size, especially leaving > 25% of the file unused causing the auto shrink to kick in.
Then again, maybe I'm just sore at getting this one wrong - I'm sure the database performance wouldn't suffer if it was read only!! ;o)
SJT
SJT
October 14, 2003 at 2:14 am
quote:
I don't know about other people's production databases, but our's NEVER shrink in size, especially leaving > 25% of the file unused causing the auto shrink to kick in.
Yeah, but when you're not watching and they do you'll have all the fun of your production base slowing to a crawl
Keith Henry
DBA/Developer/BI Manager
Keith Henry
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply