Information regarding query profiler

Does anyone have an information about a good query profiler?? By query i mean about 5 page search query.The profiler 开发者_开发技巧should be such as which gives the bottleneck in the query. thanks

Depends on the database engine you use.

If it's Sybase, then use set statistics (io, time) and set queryplan on.

In MySQL, you can do EXPLAIN <query>. More approaches are in this blog entry: "MySQL Performance Monitoring and Optimization Tools".

In MS SQL Server use SQL Server Profiler.

For MySQL, you can use SQLyog's Query Profiler feature... SQLyog is very simple and easy to use MySQL GUI tool with loads of powerfull features... Hope it helps...