Thursday, March 22, 2012

Measuring performance of Sql Queries

How can I measure the performance of queries executed on Sql Server 2000 databases. Since a single query can be written in many ways how can I find which is the best way to write a particular query.

Thanks !You can use Microsoft SQL Query Analyzer that ships with SQL Server.

It allows you to view the execution path, and how long each part of your query takes.
Start SQL Profiler and then execute your queries via Enterprise Manager or Query Analyzer. All products are part of the client tools installed with MS SQL.

Also, in Query Analyzer you should turn on show execution plan.

0 comments:

Post a Comment