SQL Server Performance Forum – Threads Archive
2 Servers, Which to install MSSQL 2000
I have to servers. Can someone please recommend the best configuration for MSSQL 2000? Here are there specs: Server 1.Dual Pentium III processors 1GHz each 512k cache each
Abit VP6 Mother Board
4 Sticks of 512MB SDRAM PC-133 (2GB total)
Onboard Raid HighPoint Technologies HPT 370 Chipset
Video Card = 4x NVIDIA RIVA TNT2 Model 64/Model 64 PRO
Ethernet = Realtek RTL8169 Gigabit
PCI Card = HighPoint Technologies Rocket Raid 454 – 4 Channel IDE ATA 133
Seagate IDE 80G 7200RPM 8MB ATA 100 (Using PCI Raid Card)
Seagate IDE 80G 7200RPM 8MB ATA 100 (Using PCI Raid Card)
Seagate IDE 80G 7200RPM 8MB ATA 100 (Using PCI Raid Card)
Seagate IDE 80G 7200RPM 8MB ATA 100 (Using PCI Raid Card)
Western Digital 30G 7200RPM 2MB ATA 100 (Using Onboard Raid)
Western Digital 30G 7200RPM 2MB ATA 100 (Using Onboard Raid)
Western Digital 30G 7200RPM 2MB ATA 100 (Using Onboard Raid)
Western Digital 30G 7200RPM 2MB ATA 100 (Using Onboard Raid)
52X CD-ROM (Black)
3 1/2 Floppy Drive (Black)
Windows 2003 Server 32Bit RETAIL BOX Server 2.
AMD Athlon 64 (3800+) 2.4GHz
Asus A8N-SLI Premium
NVIDIA nForce4 SLI Raid IDE
2 x 1G DDR400 ECC PC3200 (2GB Total)
Video Card = Gigabyte GV-RX30S128D – Radeon X300 PCI Express 16
Ethernet = 2 x Realtek RTL8169 Gigabit on board (board has 2 ethernet)
PCI CARD = Adaptec Serial ATA 2810SA Controller 8 Port
Western Digital 80G 7200RPM 8MB Serial ATA (On Adaptec)
Western Digital 80G 7200RPM 8MB Serial ATA (On Adaptec)
Western Digital 80G 7200RPM 8MB Serial ATA (On Adaptec)
Western Digital 80G 7200RPM 8MB Serial ATA (On Adaptec)
Western Digital 200G 7200RPM 8MB SERIAL ATA (On Adaptec)
Western Digital 200G 7200RPM 8MB SERIAL ATA (On Adaptec)
Western Digital 200G 7200RPM 8MB SERIAL ATA (On Adaptec)
Western Digital 200G 7200RPM 8MB SERIAL ATA (On Adaptec)
Western Digital 200G 7200RPM 8MB IDE ATA 100 (ON NVIDIA RAID)
Western Digital 200G 7200RPM 8MB IDE ATA 100 (ON NVIDIA RAID)
3 1/2 Floppy Drive (Black)
Windows 2003 Server 32Bit RETAIL BOX I need to install MSSQL 2000. We have 20 workstations that will be randomly accesing MSSQL at any given perion of time during the work day. The software I am running is a contact management/accounting/invoicing (basically all-in-one)software.
Installation recommends:
Install Application on dedicated application server.
Install Data on a dedicated MSSQL server.
The program uses MSSQL 2000 and has:
System Data File
System Log File
(My Company) Data File
(My Company) Log File Which server is the best server to install MSSQL as and act as a dedicated MSSQL Server? Which server can be my Primary Domain Controller and Application Server? How would you recommend installing MSSQL 2000, how many partitions to make, what raid configurations to use, where to install the os, and how to seperate or place tempdb, data files, log files for best performance? (Im a hardware guy and I built these over-kill servers out of spare parts from gutted machines. When it comes to software I am pretty good usually, but I like to see what the pros would do.)
the single athlon will probably perform better than 2 x PIII 1GHz I am not fond of SATA drives in a prod DB server
stick with SCSI and SAS
I am fan of 64 bit Athlon processors. So I recommend the same as joechang. Make sure you set up your hard drive configuration with proper fault tolerance and best read/write performance you can get.
check out the link for sql server operations guide.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx Good day
Bulent
Thank you for the advice. I have chosen the following setup. Before I go through with the installation, let me know if this configuration would give me excellant performance. I will use SERVER 2 as my dedicated MSSQL Server. I will configure the hardrives as follows: Hard Drive 1 Western Digital 80G 7200RPM 8MB SATARaid
Hard Drive 2Western Digital 80G 7200RPM 8MB SATA1
Partition 1 – System Data File
Hard Drive 3 Western Digital 80G 7200RPM 8MB SATARaid
Hard Drive 4 Western Digital 80G 7200RPM 8MB SATA1
Partition 1 – (Company) Data File
Hard Drive 5 Western Digital 200G 7200RPM 8MB SATA Raid
Hard Drive 6 Western Digital 200G 7200RPM 8MB SATA1
Partition 1 – tempdb
Partition 2 – All Backup Files
Partition 3 – Recovery Software Storage <copy of all software stored on Fat16 partition>
Hard Drive 7 Western Digital 200G 7200RPM 8MB SATA Raid
Hard Drive 8 Western Digital 200G 7200RPM 8MB SATA 1
Partition 1 – Operating System (1)
Partition 2 – Program Files (1)
Partition 3 – Emergency Pagefile (2)
Hard Drive 9 Western Digital 200G 7200RPM 8MB IDE ATA 100Raid
Hard Drive 10 Western Digital 200G 7200RPM 8MB IDE ATA 1001
Partition 1 – Pagefile (1)
Partition 2 – Emergency Operating system (2) <Dual Boot System>
Partition 3 – Emergancy Program Files (2) I have an extra PCI Express SATA Raid Card so I have added the following:
External HD Case
Hard Drive 11 Western Digital 36G 10000RPM 16MB SATARaid
Hard Drive 12 Western Digital 36G 10000RPM 16MB SATA1
Partition 1 – System Log File
Hard Drive 11 Western Digital 36G 10000RPM 16MB SATARaid
Hard Drive 12 Western Digital 36G 10000RPM 16MB SATA1
Partition 1 – (Company Log File) I designed this machine with a dual boot just incase of a Failed OS/file corruption or Virus. Everything that has a (2) next to it would be active if the Emergency OS was booted.
Any feedback on this configuration would be greatly appreciated. This will take me a while and I don’t want to have to do it over again if I could do it right the first time.
Sorry I made a description error on the last Mirror. The second Hard Drive pair 11, 12 should be 13 and 14. Total of 14 disks to this server.
]]>