Solved

tools to measure the response time of a MS SQL and MySQL server

Posted on 2014-10-30
12
392 Views
Last Modified: 2014-11-19
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.
0
Comment
Question by:marrowyung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 3
12 Comments
 
LVL 36

Assisted Solution

by:Loganathan Natarajan
Loganathan Natarajan earned 250 total points
ID: 40412873
For MySQL , I use MySQLTuner  it helps me to check query performance and the memory leak.  So I used to fix them by optimizing those settings.
0
 
LVL 27

Accepted Solution

by:
Zberteoc earned 250 total points
ID: 40413174
Try this free tool:

http://www.solarwinds.com/database-monitor.aspx

It will pinpoint you queries with duration, wait time an also I/O performance.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40415217
Zberteoc,

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.
0
Webinar: Choosing a MySQL HA Solution

Join Percona’s Principal Technical Services Engineer, Marcos Albe as he presents Choosing a MySQL High Availability Solution on Thursday, June 29, 2017 at 10:00 am PDT / 2:00 pm EDT (UTC-7).

 
LVL 1

Author Comment

by:marrowyung
ID: 40415218
Loganathan Natarajan,

can I have a windows based tools ?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40415222
"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?
0
 
LVL 36

Expert Comment

by:Loganathan Natarajan
ID: 40415373
MySQLtuner is not for monitoring, right?

Open in new window


It is also Monitoring tool. You can live watch on where ever sql execution time, memory use, locking etc.,
0
 
LVL 36

Expert Comment

by:Loganathan Natarajan
ID: 40415376
For Windows,  I used this , heidisql

We don't get full details like, MySQL tuner how it displays on the screen on our requests.
0
 
LVL 27

Expert Comment

by:Zberteoc
ID: 40415381
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.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40418789
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.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40418812
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 ?
0
 
LVL 27

Expert Comment

by:Zberteoc
ID: 40419484
HeidiSQL is just a management/development tool and not a monitoring tool.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40427846
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.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

689 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question