SQL Server Performance

SQL Server Performance Steps

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Ugandhar, Nov 29, 2006.

  1. Ugandhar New Member

    I am a SQL Developer & DBA ,

    Can any one give me some guidance to start with Performance tuning steps to be followed.

    How to find out the queries that are effecting the performance and what are the steps that we can perform to tune that

    thanks in advance

    Regards
    Ugandhar
    Ugandhar, Nov 29, 2006
    #2

  2. jezemine New Member

    jezemine, Nov 29, 2006
    #2

  3. ghemant Moderator

    Hi,
    you may run Profiler to trace long running queries and then try to improve on it by examining Execution Plan wether it use correct index or not. Refer
    http://www.sql-server-performance.com/tips_performance.asp and
    http://www.sql-server-performance.com/sql_server_performance_audit.asp and
    http://www.sql-server-performance.com/best_sql_server_performance_tips.asp

    Regards

    Hemantgiri S. Goswami
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ------------------------
    http://hemantgirisgoswami.blogspot.com
    ghemant, Nov 29, 2006
    #2

  4. satya Moderator

    ... and if you can try searching on the forums for relevant threads.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
    satya, Nov 30, 2006
    #2

Share This Page