Best Practices for SQL Server 2000 Hardware configuration

• John-79567

  SSCommitted

  Points: 1892

  More actions

  February 22, 2006 at 3:45 pm

  #111677

  I've been given the green light to purchase new hardware for our production database servers.  So far I've spec'd out Quad Opterons

  BTW - we are planning to migrate to sql 2005 within the next 12 months

  The 64 bit processor creates a few dilemas for me. 

  1) Do i go 64 bit and sacrifice the ability to go with scsi shared storage for MSFT Clustering?

     If i go with 64 bit, can i restore the databases from a 64 bit sql server to a 32 bit sql server?

  2) Do i go for clustering and sacrifice the ability to access more ram?

   

  Another problem - what is the ideal drive configuration?

  OS = Mirrored

  Log Partition = Striped

  Data Partition = Raid 10

   

   

• Julian Kuiters

  SSCertifiable

  Points: 6585

  More actions

  February 26, 2006 at 4:23 pm

  #623381

  Read the resources on scalability with very large databases. There's lots of details and benchmarks on optimal configurations disk subsystems.

  http://www.microsoft.com/sql/prodinfo/previousversions/scalability.mspx

  ---

  Julian Kuiters
  juliankuiters.id.au