Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Monitoring Your SQL Server with Monitis

DZone's Guide to

Monitoring Your SQL Server with Monitis

· Performance Zone
Free Resource

Download our Introduction to API Performance Testing and learn why testing your API is just as important as testing your website, and how to start today.

One of the nicest monitoring products around is Monitis.com
If you are using MySQL, you will probably find out that some of the thresholds there should be modified or tuned (or just removed, since they are not critical to your day to day operations):

Key Cache Writes Rate
Actual value: 0
Proposed range: 75-100
What should be done: If you are not using MyISAM, ignore this one. If you do use it, modify the key_buffer_size variable and increase it to accommodate the index in the memory.
Indexes Usage
Actual value:5
Proposed range:80-100
What should be done: Indexes usage is a key indicator to understand if you write your queries in a way that utilizes your indexes and if you defined correct indexes to support your questions.
Enable your slow log query and examine your queries. 
Key Cache Hit Rate
Actual value:N/A
Proposed range:95-100
What should be done: Seems that this is not a critical variable, since you must check it is relevant in your case. If you believe that your system business case should use most data out of cache and value is low, modify the key_buffer (MyISAM) or innodb_buffer_pool_size (InnoDB).
Table Cache Hit Rate
Actual value: N/A
Proposed range: 85-100
What should be done: See the one above
Bottom Line
Monitoring system is critical component of critical systems. However, in most cases you should verify that the default configuration matches your business case (and if it is the case, take care the alerts!).
Keep Performing,
Moshe Kaplan

Find scaling and performance issues before your customers do with our Introduction to High-Capacity Load Testing guide.

Topics:
java ,sql ,server ,high-perf ,database ,tool ,performance ,monitoring ,tips and tricks ,monitis

Published at DZone with permission of Moshe Kaplan, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}