SQL Server Performance

performance

Discussion in 'T-SQL Performance Tuning for Developers' started by jogin malathi, Jun 27, 2007.

  1. jogin malathi New Member

    from where one should start to check query performance

    Malathi Rao
    jogin malathi, Jun 27, 2007
    #2

  2. deepakontheweb New Member

    A very short answer but require a lot head hunting:

    Execution Plan
    Index usage
    Database and Tables relations/design/data-type
    SQL Profiler


    Deepak Kumar
    SQL Server MVP, MCDBA
    deepak.kumar@sqlknowledge.com

    Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.
    deepakontheweb, Jun 27, 2007
    #2

Share This Page