SQL Server Performance

what the query optimizer is?

Discussion in 'Performance Tuning for DBAs' started by koko, May 23, 2005.

  1. koko New Member

    Hi all
    how are u?
    actually i want to test the performance of sql query (statment or stored procedure ) to know if it works efficiently or not, and if not i need to know how can i improving its performance or what is the rules to improvimg it to reducing the execution time of it.
    Note : i know how to use the sql profiler and creating atrace file for showing the execution time for each query runing on the server but i don't know how using it to know if that query can be more efficient or not and how???? , each time i run the query it takes a different milliseconds from the other time.
    Note: my tables contain only few hundered of records
    also i want to know what is the query optimizer and how can i use it ?????

    if any one know about this topic please tell me
    thanks in advance
  2. Madhivanan Moderator

    http://www.sql-server-performance.com/absolutenm/templates/?a=125&z=0


    Madhivanan

    Failing to plan is Planning to fail
  3. FrankKalis Moderator

    If your table only contain that few rows, even bad plans or poor statements will yield a fast result. Anyway, one way I use, is to have SET STATISTICS IO ON and strieve to keep logical IO as low as possible.

    The query optimiser is part of the database engine itself. You cannot use it directly.

    --
    Frank Kalis
    SQL Server MVP
    http://www.insidesql.de

Share This Page