Posted by Erland Sommarskog on 03/22/06 00:09

Marek Wierzbicki (marek.wierzbickiiiii@azymuttttt.pl) writes:
> I start do it from 2 weeks. After create indexes and join on indexed
> fields is a little bit better. I will be looking for next havy queries
> and optimize it.
>
> Do you hear sth about
> "periscope" - tolls for searching worst queries (or others such tools)? I
> can't do it with profiler (all queries have zero execution time)

If all queries execute in zero time, then you must have a good system. :-)
What value are looking at Duration or CPU? Does StartTime and EndTime
agree with the zero-time?

You can look at http://www.sqldev.net/xp/xphrtimer.htm. This download
permits you install a DLL, so you can get millisecond resolution in
Profiler. With the standard time, you cannot get durations below 16 ms.

Then again, if your queries are that quick, it is not likely that you
can get that much information, even with a better timer.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]