SQL Server Performance

What are the best practices when creating a new database on SQL Server?

Discussion in 'General Developer Questions' started by adnan8t2, Jun 20, 2010.

  1. adnan8t2 New Member

    Dear Readers,According to your experience what we should set the size of following fields while creating a new database.MDF Initial Size = ?LDF Initial Size = ?MDF—-Enable Autogrowth = ?File Growth = ?Maximum File Size = ?LDF—-Enable Autogrowth = ?File Growth = ?Maximum File Size = ?Thanks,Adnan
  2. satya Moderator

    Welcome to the forums.
    I believe you are new to the SQL Server world or DBA world.
    First of all you have to go thru the constrainints of what kind of information is stored on that database, how many users accessing the information, the growth strategy for next 3 to 5 years, storage capacity.
    Except the initial size of MDF & LDF size rest of options you are mentioned are left to default, such as 10% filegroup.
  3. ashish287 New Member

    Let it take the default configuration from model and then for configure mdf by incremental of 100mb(or .... mb) and log by 10%
  4. FrankKalis Moderator

    Is this a homework question?
    There is no single answer to such a question. One database might work well with the default settings taken over from model. One other you would want to create at 100 GB mdf size, 20 GB ldf size, etc...
    This really can be evaluated and decided on a case by case basis.
  5. satya Moderator

    To be frank it has been a practice for the users to post such homework/int. based questions here, so I thought lets give a shot in explaining the terms.
    Still agree with all your points though... [:0]

Share This Page