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
  2. jezemine New Member

  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
  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.

Share This Page