ADO Performance

I use: VB6 (SP3), SQL Server 7.0, ADO 2.1
I want to:
1) Improve the performance of my database search (SQL). I mean how can I know which is the best way of searching with the technologies and tools that I use. (eg. is it faster to use readonly or static? client side, or server side, etc...)
2) Have a graphical (or something else) indication of the performance of each sql select I use. Is there any benchmark utility for this?

Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece

IMHO the tools that come with SQL 7 are the best for your purpose.
Use the Query Analyzer and it's graphical Showplan feature to get an idea of what SQLServer does when executing your query.

you can redirect the statistics data of each query to a file and load that into excel for graphical analysis.


Next, use SQL Profiler, the right tool for figuring out what happens on SQLServer when you issue a query.
e.g. play around with ADO parameters like (cachesize) and see what happens on SQL server...

Third, use performance monitor to watch actual performance data while your queries are executed. It has a rich graphical UI.