Database Monitoring
Database monitoring Database monitoring - DB check for access and regular execution of the specified query.

Database monitoring feature allows to run a query during every check and react in the appropriate way on the result. Also, it is possible to check just possibility to connect to DB - by ignoring the query field. To set the monitoring, fill the connection data: DB server address, port, database name, login and password of a user for connection. We strongly recommend to create the new user with limited rights. However, do not forget to provide him enough rights for performing the supposed actions. Also, it is necessary to add HostTracker servers addresses, to the whitelists on firewall or other blocking software, to allow the access. The addresses are permanent, and are listed on the same form.

Create ContentCheck Task

There could be arbitrary query - SELECT, UPDATE, DELETE, INSERT, execution of stored procedures (like scheduler), results comparison, logical operations. The only restriction is execution time - it should not take longer than 30 seconds. Otherwise, the timeout error will be reported.

It is recommended to create the queries which display the necessary value in the first row of the first column. This result can be analysed. For UPDATE, INSERT, DELETE queries the number of affected rows is analysed. There are different ways to analyse the resulted value by comparison with specific preset - equal/not equal/higher/lower/in range. In case the condition is not satisfied, no connection to DB, query timeout - the error is reported.

Create ContentCheck Task
  • CM.Glossary.WebsiteMonitoring
  • CM.Glossary.ContentCheck
more glossary

Very usefull service, helps us to monitor activity of our sites.

- A.
Monitoring server performance with HostTracker

HostTracker offers numerous simple-yet-powerful instruments to keep your website running smoothly. That implies it delivers deep insight into server resource parameters such as CPU, RAM and HDD. Read on to find out more about “Monitor CPU, RAM, HDD” tool, and why you should adopt it.

HostTracker offers numerous simple-yet-powerful instruments to keep your website running smoothly. That implies it delivers deep insight into server resource parameters such as CPU, RAM and HDD. How does it work? Starting at collecting statistics, cloud-based service lets you know at once about CPU, memory and disk space usage issues and provides the way to speed up your server performance. Read on to find out more about “Monitor CPU, RAM, HDD” tool, and why you should adopt it.

Who are your neighbours?

Nowadays there are many services and tools around that can help with all sorts of server issues. For Windows and * Nix you can find special scripts that are very easily installed. However, the sets may vary depending on the server configuration. For example, if your server doesn’t support some basic functions, one way to deal with this - to create a script based on the tools provided, which will convert the data output in a specific format for further system manipulation.

But let’s not forget about server virtualization. Virtual hosting has been into trend for a couple of years and boasts numerous advantages over resource management. If this is your thing, then “Monitor CPU, RAM, HDD” function from HostTracker will definitely come in handy for you.

Sometimes it can be hundreds of different websites simultaneously hosted on a single server. Therefore, server may get easily overloaded or stop working properly. With “Monitor CPU, RAM, HDD”, you’ll be able to strengthen your server performance against some common causes of overload and spot out your “load hungry” neighbours. It’s worth noting - one of the biggest drawbacks of shared hosting is that your server IP can end up being blacklisted due to the dynamic allocation. In essence, if your neighbour’s IP from your IP block is currently suspected of hosting illegal content, your IP address can get into a blacklist as well. That’s why it’s crucial to keep a constant watch over bad neighbours to ensure that your business reputation is safe.

Rapid increase in the CPU load, memory and disk space usage may indicate that your web server has been infected. "Monitor CPU, RAM, HDD" can help you in this regard and protect the security of your resources.

User-friendly interface and other advantages

With our user-friendly and responsive interface all information about your server performance and settings is a stone’s throw from you. Therefore, for example, the needed script should be downloaded and run once only by the responsible administrator, subsequently - all actions can be specified using HostTracker’s account. Moreover, our cloud-based website monitoring service provides a wealth of different checks to choose, from HTTP and Ping tests, to database and server  parameters checks - all these let you gather the most complete information about your resource performance for further thorough and accurate analysis.

Additionally, HostTracker has a wide variety of notification types to offer ranging from Viber to Telegram. It also provides the ways to customize your own group of contacts for notification as well as pinpoint short outages. As regards statistics – it is available anytime you want:

In particular, the screenshot illustrates that the server CPU load hasn’t exceeded a specified threshold of 90% during the day. However, the value of this parameter has fluctuated over the period. It shows that, most of the website visits are during the day, that’s why the CPU level is lower at night.

API and Post-requests are up for grabs too - you can freely set the automatic server reboot, cache clearing etc.

We are always open to new ideas and suggestions whether relating to existing instruments, or submitted by technically-minded and creative people.


more blog
Thank you for feedback!
Sign In
Sign Up
Prices & packages
Our monitoring network
Home > Blog > UptimeWebMonitoring

Website monitoring is a process of supervision over the performance of the site. HostTracker is a powerful tool which serves that purpose.

Website monitoring is a process of supervision over the performance of the site. Usually it is used to keep an eye on commercial sites or other pages for which high availability is very important.

Companies, which provide website monitoring services, let their clients to check a website, a server, port or other available from the Internet entity. The responses are collected and analyzed. Usually, the monitoring is performed from different locations, distributed over the whole world or the specific continent or country. Such monitoring is called distributed monitoringand helps to detect network-related issues as well as site or server-related. Also, distributed monitoring often makes possible to analyze the site performance from the places which are close to the real customers, instead of some distant locations which could have high latencies. The collected information could be found in a different form: email reports, graphs and different smart dependencies, to help the client to get a comprehensive view of the site's performance. Parameters like load time, speed and others can help to optimize the site performance. In case of critical error, monitoring services use variety of notification methods to deliver the alert to the client: SMS, voice call, instant messengers, email and others. This, together with immediate diagnostics, helps responsible persons like server administrators or developers to fix the site as soon as possible and minimize the duration of the failure.

Why is this important? For commercial sites, working time is proportional to their income. Roughly speaking, 2 hours of failure per day means that 1/12 part of the potential clients are lost. Even more - loyal customers also can find a more reliable competitor in case they can not receive their services/goods when they want. For other types of sites, like government, educational, NGO this is very important too. If people can't find the information fast, they'll find another source. Some parameters like site speed are important for search engines, others - database connectivity, for example - can greatly affect the convenience of usage of the site. Monitoring of some internal values like CPU load, memory consumption and disk space are important for administrators in order to prevent performance degradation. Another important purpose is verification of SLA (service-level agreement) of hosting provider. For technical issues, no site can be available 100% of time during long enough period. Sometimes servers are rebooted, updated or upgraded. So each hosting provider guarantee some specific value, which is called uptime, that shows how long can a site be down for technical reasons. Uptime is usually measured in percent. In this table it is shown for how long a site could be down for each uptime value:

  • 90%          876 hours
  • 95%          438 hours
  • 99%          87,5 hours
  • 99.9%       8 hours 45 minutes
  • 99.99%     52,5 minutes
  • 99.999%   5 minutes 15 seconds

If the real site performance does not correspond to SLA, it could be a reason for claim and refund request. Also, it can help the customers to select the best hosting for their needs.

Monitoring companies often provide some additional services, like vulnerability check, virus scanning, domain and certificate expiration check and many others, in order to make a useful product for their customers.

Different ways to monitor

The monitoring, based on the purpose, can be performed in several ways. Internal monitoring tools require some software to be installed into the monitored system, for example, corporate network. It helps to detect network issues, system performance and exclude or catch hardware and performance issues. External monitoring is performed from outside. It's purpose is check the availability and performance of the system by the third-party's eyes. Real user monitoring is external monitoring which simulates the real visitor of a site. Depending on complexity, such monitoring can analyze the page loading, content, sometimes - even design problems. Most advanced monitoring can offer its client to create a scenario for a visitor. This is called transaction monitoring and can perform some steps one-by-one: like load the page, navigate through menu, make a purchase. Passive monitoring is performed by a code which is integrated into the website code and sends specific information to the collector server each time the page is loaded. It helps to analyze customers actions on the site and analyze the traffic.

Monitoring services usually support different check protocols, and can monitor not only the websites, but also other entities like a file servers, mail servers, specific ports etc. Depending on task, monitoring interval can vary from several seconds to once per day.

Send to Twitter Send to Facebook Send to LinkedIn Share on Google+
HostTracker blog HostTracker page on Facebook