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 useful for my company's website verification whether it's up or down and be notified immediately about it, even if using a free account!

"
- T.
Host-Tracker under Windows Azure

Those, who actively involved with the Web, should know HostTracker, a company from Ukraine, which has been supporting one of the leading global web monitoring services since 2004. Its goal is to monitor site health and accessibility in near-real-time access. Using alert message system, HostTracker allows to reduce downtimes, to improve quality of service for users, to quickly localize troubles...

​Those, who actively involved with the Web, should know HostTracker, a company from Ukraine, which has been supporting one of the leading global web monitoring services since 2004. Its goal is to monitor site health and accessibility in near-real-time access. Using alert message system, HostTracker allows to reduce downtimes, to improve quality of service for users, to quickly localize troubles, and etc.

Architecturally, HostTracker includes a server-based hub, acting both as a data collector and control center, and a series of software agents, launched in various regions – typically using the equipment operated by major providers, hosters and affiliates. The geographically distributed architecture provides common system reliability and also allows collecting data in terms of access speed, bandwidth and other key performance characteristics on regional level – a critically important feature for the international business.

The first version of HostTracker, which is still functioning and providing services for tens of thousands of customers, was Linux based. Today, it is supported by nine control servers, located and organized in two DPCs on collocation principle, and few dozens of agents. Considering that the final objective of web monitoring is focused on increasing the uptime of client-based web resources – whereas 95% of HostTracker customers were able to increase it up to 99% – then, performance and accessibility of the service itself are not just critical, but rather fundamental parameters that influence the whole business. Theoretically, HostTracker should demonstrate accessibility close to 100%. However, an extensive growth of the service made this task hard to solve.

HostTracker was facing constantly increasing network traffic – a problem for seamless operation of the service. Inability to add new control servers on-the-fly, difficulties when maintaining not uniform and multiple-aged hardware was another limiting factor. Moreover, the desire to develop the service through wider protocol and network service support was meeting certain obstacles. “Unfortunately, for Linux there was a limited choice of ready-to-use solutions and libraries, while inventing something completely new was difficult”, says Artem Prisyazhnyuk, HostTracker director. “We had an idea of reviewing the stack of technologies we used for a more sophisticated one and after taking a closer look at the .NET platform, its potential in terms of scalability and network support, I realized that was exactly the thing we had been looking for.”

It was sure that migrating to a completely different platform should be a complex task – the project extended over three years. However, it was like blessing in disguise: during this period, the world has seen the cloud computing that seemed an ideal tool for solving both the scalability problem and putting aside one’s own whole infrastructure. Besides, the PaaS model allowed to remove most of the effort in terms of administering the solution and to control the application as a self-contained entity, to the extent of complete automation, and thus, Windows Azure had in fact no alternatives.

As a result, the second version of HostTracker, commercial operation of which started in May 2012, is already functioning under Windows Azure. Its central ingredient is realized as Web Role and associated with SQL Azure Database – it provides external portal, analytics and report generation, control of monitoring applications. The latter are ensured with instances of Worker Role, which also use SQL Azure Database to store their data and to provide the service scalability depending on the network loading. Agents are functioning as they did before, with the viability of their transfer to Windows Azure being considered.
Now, HostTracker uses HTTP/HTTPS and ICMP protocols to monitor specific ports, including various methods (HEAD/POST/GET), and etc.
 



Alarm reporting is available via email, SMS and instant messages. The customer can receive reports with statistics about resources being controlled and their performances. You can spend only 6 minutes to make monitoring settings for five sites, while the average response time in case of failure is limited by a couple of minutes, and it takes 1-3 minutes more to inform the customer about the problem. Using this service, anyone can check any site, including access from various regions.

 As a result, if on the one side the transfer to the .NET platform itself gave us the potential to modernize HostTracker, to optimize the application architecture and realize new internal functions, then, on the other side, the migration to the cloud allowed to refuse from less important, though time consuming activities such as administering the solution, and, first of all, to reach necessary performance indicators. Microsoft, for all basic Windows Azure services, declares 99,9% accessibility and guarantees monthly refunds, should this indicator be lower. This creates a firm ground for operating such services like HostTracker, as the accessibility is the most critical parameter for these applications. Using the cloud infrastructure also provides a better protection for the service: unauthorized access to the application and many types of attacks are effectively excluded, while the data safety is ensured by triple reservation.

HostTracker received another advantage from abandoning its own infrastructure. The service’s performance characteristics are also rather critical, for they directly affect the failure reporting system operation. In this respect, Windows Azure is virtually a drainless source of computing power. This means that by timely starting additional monitoring instances you can support HostTracker functioning parameters on the necessary level. Moreover, the cloud environment is exactly what you need in order to make this process almost fully automatic, excluding further need for direct control.

more blog
Thank you for feedback!
 
More
:
Home > Our monitoring network
Our agent list (106 agents) 
Location Company name
Hyderabad, Telangana, India
Freemont, United States
Dnipro, Ukraine
Moscow, Russian Federation
Manassas, VA, United States
Istanbul, Turkey
Santa Ana, Costa Rica
Amsterdam, Netherlands
Sao Paulo, Brazil
Narva, Estonia
Nuremberg, Germany
Moscow, Russian Federation
Almaty, Kazakhstan
Frankfurt, Germany
Lugano, Switzerland
Montreal, Canada
Dublin, Ireland
Tehran, Iran, Islamic Republic of
Minsk, Belarus
Quincy, WA, United States
Dublin, Ireland
Meppel, Netherlands
Mykolaiv, Ukraine
Nuremberg, Germany
Khmelnytsky, Ukraine
London, United Kingdom
San Antonio, TX, United States
Moscow, Russian Federation
Khmelnytskyy, Ukraine
Sao Paulo, SP, Brazil
Kazan, Russian Federation
Kharkiv, Ukraine
Moscow, Russian Federation
Gdansk, Poland
Kharkiv, Ukraine
Stokholm, Sweden
Chicago, IL, United States
Saint Petersburg, Russian Federation
Saint Petersburg, Russian Federation
Roubaix, France
Montreal, Canada
Munich, Germany
Meppel, Netherlands
Cheyenne, WY, United States
Singapore, Singapore
Phoenix, Arizona, United States
St. Petersburg, Russian Federation
Amsterdam, Netherlands
Sofia, Bulgaria
Meppel, Netherlands
New York, NY, United States
Dusseldorf, Germany
Sha Tin, Hong Kong
Nuremberg, Germany
Tehran, Iran, Islamic Republic of
Singapore, Singapore
Meppel, Netherlands
Waco, TX, United States
Kyiv, Ukraine
Moscow, Russian Federation
Dallas, TX, United States
San Jose, CA, United States
Dronten, Netherlands
Moscow, Russian Federation
Munich, Germany
Los Angeles, CA, United States
Santa Fe de la Vera Cruz, Argentina
Vladivostok, Russian Federation
Dronten, Netherlands
Tallin, Estonia
Nairobi, Kenya
Rasht, Iran, Islamic Republic of
Novosibirsk, Russian Federation
Centurion, Gauteng, South Africa
Tehran, Tehran, Iran, Islamic Republic of
Qom, Iran, Islamic Republic of
Moscow, Russian Federation
Tehran, Iran, Islamic Republic of
Hamedan, Iran, Islamic Republic of
Berlin, Germany
Ballito, South Africa
Strasbourg, France
New York, NY, United States
Kuala Lumpur, Malaysia
Tehran, Iran, Islamic Republic of
Paris, France
Singapore, Singapore
Bogota, Colombia
Sao Jose do Rio Preto, Brazil
Amsterdam, Netherlands
Buenos Aires, Argentina
Denver, Colorado, United States
Tokyo, Japan
Brescia, Italy
Jakarta, Indonesia
Moscow, Russian Federation
Kwun Tong, Hong Kong
Patras, Greece
Seoul, Korea, Republic of
Ho Chi Minh City, Viet Nam
Kuala Lumpur, Malaysia
Tomsk, Russian Federation
Berlin, Germany
Moscow, Russian Federation
West Europe
Noida, India