Initial set up of production database

  • Does anyone have a checklist of items for initial setup of production database?

  • A bit more information would be helpful here...

    Generally though, the default settings work pretty well.  The biggest possible exception is the data file size and placement.

     

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • If you want good advice on how to set up the system, we need lots more information. If you want a poor guess, we can do that.

    Things that need to be considered:

    What kind of storage are you using? Do you have multiple drives or only one drive?

    How much data do you expect to have?

    How will the database be used? Is it read-only? Will there be lots of inserts? Will there be lots of deletes? Updates?

    Information like that will help alot.

    -SQLBill

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

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