Post reply

Adding a sql instance to an installation

  • August 3, 2006 at 7:39 am

    #61595

    HI. We currently are running our sql server with a default instance. I've been asked what would be the impact to add 'an instance' to our original installation. Is there a performance impact, hardware impact or maintenance impact? 

    Thanks so much,

    Juanita

     

  • August 4, 2006 at 11:16 am

    #653396

    It depends ... but generally I'd say yes. It depends on the the following:

    • The OS
    • # of CPUs
    • CPU speed
    • Are the CPUs Xeon or not
    • the amount of RAM
    • Disks
    • number of them
    • their size
    • the speed of the disks
    • the disk controller(s)

    Also the database application(s) that are using the SQL Servers databases.

    In order to make a more informed decision you will also have to gahther some performance statistics for both the OS and SQL Server using perfmon too.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • August 4, 2006 at 3:01 pm

    #653438

    thank you!

    Juanita

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

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