现在有一句sql1
及其变换sql2
,两句sql同环境下单独执行不好分辨其优劣,所以我想通过QPS
这个指标来衡量它们。求助各位大神有没这类工具或者方案能够获取sql
语句的QPS
值。拜谢~
黄舟2017-04-17 13:10:45
I don’t know that there is such a mechanism in
sql
. Are you looking for a monitoring tool corresponding to the database? For example sqlserver的profiler
and the like.
In addition, you can test it in the program. The execution time difference of the monitoring program is roughly comparable, although there is a deviation.