Post reply

QOD 14/10

  • October 13, 2003 at 7:48 pm

    #160822

    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

    #478088

    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


    According to everyone I know I "do something with computers?" for a living, so there you go.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply