SQL Server Performance

Need advice on SQL Server Performance

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by wkm1925, Oct 6, 2010.

  1. wkm1925 New Member

    My current system as follow
    1. Windows 2003 Server Enterprise Edition 32 bit
    2. SQL Server 2005 Enterprise Edition 32 bit
    3. Strengthen by RAID 5
    4. SQL Server now hosting 5 different application database
    5. All DBs resided in SAN (connected via high speed fiber channel)
    My current problem as follow
    1. At this level, SQL Server looks have an extra overhead that hurts performance. Transactional activities which usualy requiring few seconds now requiring few minutes and this is unreasonably slow from user experience perspective.
    1. In monitor performance, SQL Disk average queue length sometimes hit to 100%
    My question is,
    1. Before upgrade the server, Windows Server, SQL Server, what steps need to be taken
    2. As a result, we will know this is because of the server, Windows Server and SQL Server
    Need advice
  2. Luis Martin Moderator

    Kindly don't duplicate posts.

Share This Page