SQL Server Performance

specific server and storage

Discussion in 'SQL Server 2005 Clustering' started by adelan, Mar 13, 2008.

  1. adelan New Member

    <P mce_keep="true">&nbsp;</P><P mce_keep="true">Hi Everybody,<BR>I'm a newby and was asked to make a report stating the exact server and storage specifications required to run current databases,&nbsp;<WBR>&nbsp;e.g 6 73GB 15K disks in a RAID 5 array with 2 servers with 4GB RAM, 2 2Ghz CPU's etc. I'm struggling a little. Please can anybody help <IMG title=Unsure src="http://www.sqlservercentral.com/Forums/Skins/Classic/Images/EmotIcons/Unsure.gif" align=absMiddle border=0><BR></P><P mce_keep="true">They want to upgrade from sql 2000 to sql 2005 cluster. At the moment they have 3 servers - <BR>All storage is local (DAS) to the servers.<BR><BR>SQL Server 1<BR><BR>Server Specification<BR>2 * Intel PIV 2.4Ghz 1GB Memory<BR>2 * 36GB SCSI Drives in RAID 1 config - System drive<BR>2 * 36GB SCSI Drives in RAID 5 config – Database files <BR>Windows 2000<BR>SQL Server 2000<BR>100Mb Network Cards<BR><BR>Databases<BR><BR>CaseArchive<BR>epdrtest<BR>Insight_v1_0_11274148<BR>MailMarshal_Live_test<BR>MailMarshalSMTP_Live<BR>PINS<BR>PMP_V3_0<BR>PSSO_ICF_Intranet<BR>rmbe<BR>rmbe_201206<BR>SCAT<BR>Teleform<BR>vmm_db_v2<BR>WebMarshal<BR>WebMarshal_live<BR><BR>SQL Server 2<BR>Server Specification<BR><BR>2 * Dual Core Opteron Processors 2.2Ghz <BR>4GB Memory<BR>2 * 72GB SCSI Drives in RAID 1 config - System drive and Database files<BR>Windows 2000<BR>SQL Server 2000<BR>1Gb Network Cards<BR><BR>Databases<BR><BR>DAConfiguration<BR>DAReporting<BR>DCCFLMS<BR>DutyManagement<BR>Insight_v50_0_11553938<BR>NFLMS<BR>PIKE<BR>PNTS<BR>SAN_Stats<BR>SoftwareOrganiser_DB<BR>uk-warrants-live<BR>uk-warrantsv1<BR>VTS<BR><BR><BR>SQL Server 3<BR><BR>Server Specification<BR><BR>2 * Intel PIV 2.8Ghz <BR>2GB Memory<BR>2 * 36GB SCSI Drives in RAID 1 config - System drive and Database files<BR>Windows 2000<BR>SQL Server 2000<BR>100Mb Network Cards<BR><BR>Databases<BR><BR>OperatorStatistics<BR>OpMod_Exeter<BR><BR>I know i'm asking a lot but your help will be highly appreciated.<IMG title=BigGrin src="http://www.sqlservercentral.com/Forums/Skins/Classic/Images/EmotIcons/BigGrin.gif" align=absMiddle border=0><BR></P>
  2. MohammedU New Member

    Welcome the to the forum...
    You can't install cluster with DAS you need to have shared disks (SAN)...
  3. ghemant Moderator

Share This Page