Adding a sql instance to an installation

• Juanita

  SSCertifiable

  Points: 5300

  More actions

  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

   

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  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."

• Juanita

  SSCertifiable

  Points: 5300

  More actions

  August 4, 2006 at 3:01 pm

  #653438

  thank you!

  Juanita