Post reply

Setting up Database Configuration at optimum level

  • November 11, 2005 at 5:11 am

    #111183

    Hi,

    I have a task to setup a Database Server. Client have recommended me to have SQL Sever 2000. But as I am new to a job of DBA I am facing the problem in having the optimum solution. Like:

    1) On what basis the system configuration will be decided for insatalling SQL Server, like HDD size, RAM size, Processor, etc. ?

    2) How to calculate the size of Database, Datafile and Transaction log file?

    3) What values should be configured for the SQL Server Properties?

    4) What values should be configured for the Database Properties?

    Please help me to find the optimum level and the steps to follow when such thing is to be decided, like any standard model is there to follow......

     

    Kindest Regards,

    Vishal Prajapati

    DBA at Extentia Infromation Technology

  • November 11, 2005 at 11:27 am

    #603482

    There is quite a few things to consider when initially sizine hardware for a database server.  Try this one for starters: http://qa.sqlservercentral.com/columnists/bknight/sizingadatabase.asp

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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