SQL Server Performance

2 Servers, Which to install MSSQL 2000

Discussion in 'Performance Tuning for Hardware Configurations' started by diablo45, Apr 12, 2007.

  1. diablo45 New Member

    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.)
  2. joechang New Member

    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
  3. BulentGucuk New Member

  4. diablo45 New Member

    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.
  5. diablo45 New Member

    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.

Share This Page