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...