Server Configuration Advice Requested

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sonny Grunter
    #1

    Server Configuration Advice Requested

    I'm looking for configuration advice for a SQL Server. I have the
    following hardware to work with:

    1 Dell P4 2.66 GHz PC with 512 MB RAM and a 40GB IDE drive
    2 Seagtate Barracuda 4.55GB SCSI drives (ST34572W) in an external bay
    1 Adaptec 2940UW SCSI Controller
    Windows 2000 Advanced Server
    MSSQL 2000 Enterprise


    The PC will strictly be a SQL Server only - no IIS or FTP or other
    services. It will host about 8-10 databases that service a department
    of 300 people. My plan is to install W2K and MSSQL on the PC's IDE
    hard drive and configure the identical SCSI Barracudas as a mirrored
    volume to host the databases (MDF/LDFs).

    Will there be any performance problems installing MSSQL Server on the
    IDE drive while the MDF/LDFs are on the SCSI drives? From a
    performance standpoint, would I be better off installing MSSQL Server
    on the SCSI drives?
    Tags: None
    • Greg D. Moore \(Strider\)
      #2
      Re: Server Configuration Advice Requested


      "Sonny Grunter" <spoogebucket69 @yahoo.com> wrote in message
      news:6d132e5b.0 308150438.33e0d 435@posting.goo gle.com...[color=blue]
      > I'm looking for configuration advice for a SQL Server. I have the
      > following hardware to work with:
      >
      > 1 Dell P4 2.66 GHz PC with 512 MB RAM and a 40GB IDE drive
      > 2 Seagtate Barracuda 4.55GB SCSI drives (ST34572W) in an external bay
      > 1 Adaptec 2940UW SCSI Controller
      > Windows 2000 Advanced Server
      > MSSQL 2000 Enterprise
      >
      >
      > The PC will strictly be a SQL Server only - no IIS or FTP or other
      > services. It will host about 8-10 databases that service a department
      > of 300 people. My plan is to install W2K and MSSQL on the PC's IDE
      > hard drive and configure the identical SCSI Barracudas as a mirrored
      > volume to host the databases (MDF/LDFs).
      >[/color]

      I would most likely put the LDFs on the SCSI drives and the MDF on the IDE
      drive and maintain good backups.

      (some may argue the opposite, but the main reason will remain the same,
      having your logs and your data on separate physical disk channels will
      provide better performance.)

      Where SQL Server itself (i.e. the executables, etc) doesn't make much of a
      difference.

      [color=blue]
      > Will there be any performance problems installing MSSQL Server on the
      > IDE drive while the MDF/LDFs are on the SCSI drives? From a
      > performance standpoint, would I be better off installing MSSQL Server
      > on the SCSI drives?[/color]


        Comment

        Previous template Next
        Working...