SQL Server Performance

Slow performance for SQL Server 2000 on IBM x366

Discussion in 'Performance Tuning for Hardware Configurations' started by mhussein, Aug 28, 2006.

  1. mhussein New Member

    Hi all,

    I am facing a problem with SQL Server 2000 on Windows 2003 Server, Here's the environment details:

    Server hardware

    IBM xSeries x366 wiht x3 architecturehttp://www-03.ibm.com/servers/eserver/xseries/x366/specs.html
    Dual Xeon 3.7 processors
    4 GB of RAM
    2 x 73 GB SAS Internal Hard Disks

    Server Software

    Microsoft Windows Server 2003 R2 (32 bit)
    Microsoft SQL Server 2000 Standard Edition SP4 (Standard Configuration). (32 bit)

    Problem Description

    We are facing slow performance regarding any operations that require write access to SQL Server ( visible when we do backup and restore from business application [ Restore takes too much time ]).

    Testing sqlio tool http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx#EXNAE ) from Microsoft, we found that our Laptop outperform IBM server by 7 times !!!!!!

    Reinstalling SQL with empty databases to avoid data and ugly written queries leads to the same results.

    The same software settings on a regular PC performs much more better that IBM server.

    No hardware errors is reported neither Windows errors.

    What possibly could be the reason for such slowness in SQL write operations ?
  2. satya Moderator

  3. mhussein New Member

    <b>Thanks Satya,</b><br /><br />I made some benchmark tests on the server itself.<br /><br />It looks like we have a bottleneck in write operations on system.<br /><br />I checked hardware manager, check the disk drives and found that write cache is disabled.<br /><br />Upon enabling it , performance boosted like it should be <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Thanks for you r help,<br /><br /><b>Maged Hussein</b>
  4. Argyle New Member

    Make sure you have a cache with battery backup on your raid controller before enabling write cache.

Share This Page