SQL Server Performance

Need advice on SQL Server Performance

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

  1. wkm1925 New Member

    Hi,
    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.
    Simptom
    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

    1) Run Profiler and find queries with long duration and/or reads.
    2) Check execution plan on each query find in 1).
    3) Use DTA to find better indexes to optimize those queries.
    4) Schedule maintenance jobs.
    About 1) to 4) you will find a lot of articles in our Forum.
  3. wkm1925 New Member

Share This Page