It would be useful to have the tmp_table_size "fit rate" % on this graph on the right Y axis.
A ratio between total tmp tables and the tmp tables that exceed tmp_table_size would be useful in tuning tmp_table_size, and assessing the effect of changing tmp_table_size.
This would be something like:
Tmp Memory Fit Rate = (1 - (tmp tables created on disk / tmp tables created)) * 100
This should also be added to the tuning advisor dashboard, aiming at 99.9% fit rate.
It would be useful to have the tmp_table_size "fit rate" % on this graph on the right Y axis. A ratio between total tmp tables and the tmp tables that exceed tmp_table_size would be useful in tuning tmp_table_size, and assessing the effect of changing tmp_table_size.
This would be something like: Tmp Memory Fit Rate = (1 - (tmp tables created on disk / tmp tables created)) * 100
This should also be added to the tuning advisor dashboard, aiming at 99.9% fit rate.