SQL Server Performance

Windows 2003 sp1 issue

Discussion in 'Performance Tuning for Hardware Configurations' started by Luis Martin, Jan 14, 2006.

  1. Luis Martin Moderator

    Is not exactly a SQL question.

    I have the following hardware at my office (I'm free lance).

    1 Pentium IV intel 2.8
    512 RAM
    2 disk IDE 80GB. (No ATA)

    When i was using Windows 2000 sp4 all works fine.

    Now, I begin to use fresh copy of Windows 2003 Enterprise Edition sp1.
    No update, so I install all from the begining.
    No domain, stand alone.
    Also I install SQL 2000 EE sp4.

    My first restore (50GB) take 12 hours (2.74 MB/Sec).
    To copy one 1.7 GB file from one drive to other take more than 30 minuts. In my laptop with one 100GB disk, take 5 minuts.

    I also flash with last bios, uninstall antivirus, etc. Nothing work.

    Any help?










    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  2. Luis Martin Moderator

    I fount it.
    I update the IDE driver and now work fine.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  3. ghemant Moderator

    Thanks for sharing with us Luis , <br />one more thing i always do when ever i install Windows XP and Windows 2003 and thats "Adjust for Best Performance" it will off the Visual Effects and set and share the Virtual Memroy across all the partition. <br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />

Share This Page