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



    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

Share This Page