marrowyung
asked on
tools to measure the response time of a MS SQL and MySQL server
Dear all,
We are now looking for montioring tools to monitor the response time of a MS SQL and MySQL server, what tools you use?
query level response time monitor/measurement tools also welcome.
We are now looking for montioring tools to monitor the response time of a MS SQL and MySQL server, what tools you use?
query level response time monitor/measurement tools also welcome.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Loganathan Natarajan,
can I have a windows based tools ?
can I have a windows based tools ?
ASKER
"MySQLTuner-perl
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.
"
MySQLtuner is not for monitoring, right?
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.
"
MySQLtuner is not for monitoring, right?
MySQLtuner is not for monitoring, right?It is also Monitoring tool. You can live watch on where ever sql execution time, memory use, locking etc.,
For Windows, I used this , heidisql
We don't get full details like, MySQL tuner how it displays on the screen on our requests.
We don't get full details like, MySQL tuner how it displays on the screen on our requests.
Define "DB server response time". I haven't heard such thing before. A db server response is function of physical parameters like I/O, network, and logical parameters like query performance which are both measured by Solarwind monitor. True, doesn't work with MySql unfortunately.
You can simply ping a server tosee how good the network is and build a simple script that will query regularly some database, measure the response time and keep a history to compare.
You can simply ping a server tosee how good the network is and build a simple script that will query regularly some database, measure the response time and keep a history to compare.
ASKER
Zberteoc,
"True, doesn't work with MySql unfortunately."
so I can't consider it as I will be justified on why not meansuring them both.
"You can simply ping a server tosee how good the network is and build a simple script that will query regularly some database, measure the response time and keep a history to compare. "
how ?I don't see script to measure that.
"True, doesn't work with MySql unfortunately."
so I can't consider it as I will be justified on why not meansuring them both.
"You can simply ping a server tosee how good the network is and build a simple script that will query regularly some database, measure the response time and keep a history to compare. "
how ?I don't see script to measure that.
ASKER
Loganathan Natarajan,
about heidisql, do we have to run it all the time from a workstation ? it seems can't run on a server?
the time column is the response time ?
about heidisql, do we have to run it all the time from a workstation ? it seems can't run on a server?
the time column is the response time ?
HeidiSQL is just a management/development tool and not a monitoring tool.
ASKER
Zberteoc,
yes, you are right and that's why I ask Loganathan Natarajan for this, the link he gave me doesn't shows that up.
All,
I have checked a lot of tools that if I want MySQL and MS SQL monitor by a single box, only application manager and Zabbix can do it, one on windows and one on Linux.
but one thing, they can only monitor Query level response time.
yes, you are right and that's why I ask Loganathan Natarajan for this, the link he gave me doesn't shows that up.
All,
I have checked a lot of tools that if I want MySQL and MS SQL monitor by a single box, only application manager and Zabbix can do it, one on windows and one on Linux.
but one thing, they can only monitor Query level response time.
ASKER
Solarwinds do not check MySQL, I checkd this out before.
I need a tools that check DB server response time but not individual query response time.