SQL Hardware/server specifications

• weazzellboi

  Right there with Babe

  Points: 786

  More actions

  March 12, 2007 at 7:41 pm

  #194493

  Hi All

   For those of you that have been down this road before , please advise /help. thanks in advance.

  currently I have two sql 2000 servers, both in production, one replicating out to the other and performing backups. The disks on both servers are setup like this: raid one (C/D drives) raid 5 (M/T drives) C:\ apps and Os, D:\Logs/ LDF's. M:\MDF's T:\Trn's. this was done to split up the load on these servers and the read writes to the disks.

  im looking at building a new SQL 2005 server and was wondering how people have been setting their sql 2005 servers up and how the disks are arranged. or if anyone could send me in the right direction that would give me examples of  how MS would preferr this to be done.

  all suggestions would be great thanks

   Todd

   

  ---

  Kindest Regards,

  Todd,non est vivere sed valere vita est
  

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 12, 2007 at 9:28 pm

  #694563

  It all depends on $$$...

  Those who can spend more they use Raid 0+1(10) for data and log files...

  Read the following thread...

  http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=16995

   

  MohammedU
  Microsoft SQL Server MVP