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
http://www.sql-server-performance.com/absolutenm/templates/?a=125&z=0 Madhivanan Failing to plan is Planning to fail
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
