Uptime
Uptime Uptime is the period of time when a site performs well.

Uptime corresponds to the time when a site is accessible from the Internet. The opposite term - downtime - shows for how long a site has not been working during specified period of time. Usually uptime is measured in percents, and for period of time is choosen year. Percents over the year could be easily transformed into time values. Some typical values of uptime and corresponding period of unavailability during the year are shown here:

90% - 876 hours

99% - 87 hours, 36 minutes

99.9% - 8 hours, 45 minutes, 36 seconds

99.99% - 52 minutes, 34 seconds

So high uptime is really important. Even if it seems that 99% is pretty high value - it corresponds to several days of failure. If that happens in a row, many clients can be lost. Uptime value is usually guaranteed by web hosting, where the site is hosted. Website Monitoring may help you to increase the uptime and check if the value, declared by the hosting company, is real.

  • CM.Glossary.WebsiteMonitoring
  • CM.Glossary.Downtime
  • CM.Glossary.WebHosting
  • CM.Glossary.Availability
more glossary
"

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

"
- A.
Database Monitoring with HostTracker

We’re happy to introduce our newest monitoring feature - Database Check – that is easy to use, crystal-clear to understand and designed to get you through your website ‘critical hours’ as smoothly as possible.

We’re happy to introduce our newest monitoring feature - Database Check – that is easy to use, crystal-clear to understand and designed to get you through your website ‘critical hours’ as smoothly as possible.

There is a wealth of different collector services for gathering and analyzing performance information from, for example, the number of visitors, disk usage to the duration of a database session and geographical distribution of the audience that visits the website. In the real world, it is very common to find two or more of these metrics presented together. Anyway, the problem is that you should not only assess these numbers but also somehow examine and compare them.

All that made HostTracker team eventually develop a Database Check – a perfect tool for deep database monitoring and successful troubleshooting database performance problems.

Task Configuration Concepts

Generally speaking, adding a new Database Check won't take long to set up. Once it is enabled, you’ll get the chance to adjust the check to suit your overall strategy. Now let’s look at some of the available options to better understand how they can be effectively applied.

First and foremost, this feature has an option to include a specific database query every time you run the check, whilst still having the opportunity to manage the processing data. If you don’t want to specify any query – the service will verify the ability to connect to the database. In addition, the Database Check tool supports a deferred execution option, which allows you to specify the point of query declaration and track its results.

Besides that, you can use any command - from a simple Select statement to a more complex procedure, - as a database query. However, the specified request should be executed in 30 seconds or less, otherwise, the error message will be generated. Basically, you’ll get the 408 Request Timeout or related error.

Please note: When enabling a new DB monitoring check, there are a couple of things to consider. Use an SQL statement that returns a single value. Furthermore, this value should be returned in the first column of the first row. This step is vital for further performance analysis of the monitored system.  

At the same time, in case of using a DML command as a statement, you’ll also get the total number of rows being affected.

The following example shows the graphical interpretation of the results from executing DELETE statement, according to the specified condition:

For the record, the collected results are not only displayed in a real-time graph, but also stored for later analysis. Besides, such a solution can really help to get valuable insights into how to optimize your database performance.

Moreover, at this stage, you can specify the type of selection criteria. You can choose from no, equal/not equal, greater/less than, in/out of range.

Once the system finds some deviation in records from the expected results - you will receive a notification. To boot, you can control which events you want to receive alerts for and which ways (Skype, Viber, Telegram, Slack etc.).

First Steps In Starting Successful Performance Troubleshooting

This example shows how to create a check for both tracking the growth of all the database log and data files and getting alerts when critical database size is reached. It implies, the following example contains information about the file data/log file size, the total space used, free space details etc. So what you need to do:

  1. Create a new query that displays how much free space you have in your tablespace.

          SELECT
          convert(DECIMAL(12,2),round(sysfile.size/128.000,2)) AS 'FileSize/mb'
          , convert(DECIMAL(12,2),round(fileproperty(sysfile.name,'SpaceUsed')/128.000,2))
          AS 'Used/mb'
          , convert(DECIMAL(12,2),round((sysfile.size-fileproperty(sysfile.name,'SpaceUsed'))/128.000,2))
          AS 'Free/mb'
          , filegroup.groupname AS 'File-group'
          , sysfile.[name],sysfile.[filename]
          FROM dbo.sysfiles sysfile (NOLOCK)
          inner join dbo.sysfilegroups filegroup (NOLOCK) ON filegroup.groupid =
          sysfile.groupid
          UNION ALL 
          SELECT
          convert(DECIMAL(12,2),round(sysfile.size/128.000,2)) AS 'FileSize/mb'
          , convert(DECIMAL(12,2),round(fileproperty(sysfile.name,'SpaceUsed')/128.000,2))
          AS 'Used/mb'
          , convert(DECIMAL(12,2),round((sysfile.size-fileproperty(sysfile.name,'SpaceUsed'))/128.000,2))
         AS 'Free/mb'
         , (CASE WHEN sysfile.groupid = 0 THEN 'Log' END) AS 'File-group'
         , sysfile.[name],sysfile.[filename]
         FROM dbo.sysfiles sysfile (NOLOCK) WHERE groupid = 0
         ORDER BY [File-group],sysfile.[name]         

      2.  After execution, you should get the following results:

     3.  Add a condition of selection:

  • Query result - select "value in the first column of the first row (mainly for SELECT)".
  • Result verification - choose "less than" and add "1000"  as the max value.

Finally, you’ll get the following result once all the previous stages have been successfully completed: if the log file size exceeds 1 GB, you’ll receive a notification.

Please keep in mind all data collection history information is saved and always available to view. It means you can easily identify the cause of this or that problems, for instance, the reason for rapid tablespace growth.

Adding a New Database Monitoring Task

To activate a new Database Check you need:

      1.  Fill in the following fields:

  • Server – enter your server name;

  • Port -  add your port number;

  • Database – add your database name;

  • User ID- enter the login name under which the check should be executed;

  • Password – add the password that corresponds to your login.

For this task only, it is recommended to create a new user account with limited rights.

       2.  Provide access to your database. For this, add the IP addresses of the HostTracker agents to a Firewall Whitelist and your server list.

Note that, the IP addresses of our agents are permanent.

       3.  When ready, click on Save.

If you have any questions about this feature, well, just send us a message. We’re always ready to help!

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

▶ Monitoring domain and SSL certificate expiry dates.

▶ How to activate the SSL certificate monitoring tool and domain monitoring settings?

▶ It takes only several minutes with HostTracker. 

So many domain names are lost in this fashion. The domain name holders have their names taken away by others, simply because they miss the renewal alerts and they do not notice when their domains are not running the show anymore. Although the whole system for domain name holders is not very practical or sensible, reality confirms that dropping a domain name is a significant problem nowadays. Anyone who holds a domain name is very much prone to losing it, ranging from big corporations, like Microsoft, to small private firms. Trying to solve this problem, HostTracker has developed utterly useful tools that highly increase the chances to reach 100% uptime.

Controlling tools

Registrars are obliged to keep the registered name owner always updated on the status of a domain and must notify of the impending expiration at least two times. One of these notifications must be sent about one month prior to expiration and one must be sent about one week prior to expiration. But “In theory, theory and practice are the same. In practice, they are not”. That’s why a lot of very bad things keep on happening. For instance:

  • Alerts go to the spam folder;
  • Responsible employees are taking time off work;
  • Or just there is something more important that should be solved just at this moment and the domain renewal is put off for the better times.

Problems like these occur very often.  Moreover, when we face them - no one can recall the timing of the registration, the timing of payments, the cards from which the money was written off etc.

Are you getting the idea that it’s truly important to pay attention to this stuff? Use HostTracker tools. The service will monitor your domain/SSL certificates for many different status changes, such as when a domain becomes registered, when it drops and becomes available, when it's renewed and everything. You can enable automatic summary reports that are emailed on a daily / weekly / monthly basis (or at any interval you choose). The reports can include renewal dates of registration and any other useful information and can be sent, for example, via SMS, email or a Skype. These instruments are also fully configurable and can be used together or separate with regular uptime checks.

Domain Monitoring Service Settings

Applying domain monitoring settings takes several minutes:

simply enter the domain name. You can click on "Add list" to monitor more than one website. You may also configure additional options by clicking on "Subscriptions" bar:

  • “Up” - the domain renewal notices are emailed one month, 7 and 3 days prior to expiration.
  • “Down” - you are notified that your domain name has already expired.
  • “Repeat” - you receive alerts every day until you renew the domain name.

Put tick marks next to the contacts of people, who should be informed in case of any problems.

If you want to be notified not only by email, but also by other messengers (Skype, Viber, Hangouts, Telegram), add them in the "Add Contact" bar or in the "Notifications" menu on the main page screen.

How to activate the SSL certificate monitoring tool

Since Google announced that they’re going to be using whether or not a server uses SSL as a ranking signal, the number of people interested in purchasing SSL certificates has skyrocketed. Why are SSL/TLS certificates so beneficial? 

The idea of using SSL/TLS certificates is crystal clear, as it is a type of encryption used for securing web sessions. HTTPS keeps both your websites and your customers' personal information private and secure. As when a SSL certificate is used, the information becomes indecipherable to everyone besides for the server you are sending the data to. This protects it from "domain slamming", "email phishing" attacks and other harmful activities.

Therefore, it is vital not to miss SSL/TLS certificates expiry dates. Both domain monitoring and SSL monitoring instruments are operating alike and have the same configuration, which includes:

  • Sending renewal notifications 30, 7, and 1 days prior to certificate expiration.
  • Sending instant reports when security certificate is becoming “off”.
  • Reporting daily about the necessity to renew the SSL/TLS certificates.
  • Selecting groups of contacts who can be informed in case of a crisis/emergency.

With activating the two monitoring functions in the Business or Enterprise packages, or in a trial mode, you’ll be always aware of the certificate or domain expiry dates. Or at least, in case of unintentional domain losses, you will be eager to know the reason when, why and how it has happened and sort out the problem.

HostTracker is client-focused

That’s why one of our founding principles as a company included remaining flexible and adaptable, as well as open to improving our service. As the technology world changes, we’ll be ready to make quick, minute adjustments, add new tools and implement new features to improve our product.

Many of our features and enhancements are available online and have been minted due to the customer requests. Therefore, we are looking forward to hearing your feedbacks, suggestions and new creative ideas.

 

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