DNS
DNS DNS - domain name system, a system for locating a web site.

DNS - domain name system. This system helps to find a real server by virtual site name. The system is realized by the hierarchy of DNS servers, each of them holds information about specific domains and may delegate such role to lower stage servers. Let's take, for example, site www.host-tracker.com. The upper domain is .com, so the request is made to the server, which is responsible for all .com sites. It knows where each site is located, or at least, where is another server, which knows for sure. If you get "Server not found" message, that means no record exists on the DNS server for the site name you've requested.

Each time you enter an address into the browser - a DNS request is made, in order to find where the site is located. To make this process faster, DNS data can be saved into a cache. If you own a site and decide to change its name for some reason, or if you have just created the new one - you should keep in mind that DNS cache needs some time to be updated globally. Usually, it happens within couple of hours, but it can take up to 48 hours. That's why sometimes a newly-hosted site can not be visible for some time.

  • CM.Glossary.WebsiteMonitoring
  • CM.Glossary.Uptime
  • CM.Glossary.WebHosting
more glossary
"

The global monitoring system is quite useful -
as most of my outages are really regional outages out of my control. It helps to know this.

"
- Rick
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 > HostTrackerNotifications

In today’s high speed, high pressure and high-stress world it’s utterly important to keep up with things going on with your website. Being well-informed means being in the know of how speedily the monitoring service can contact you - as how will you save the world if you don’t know what’s happened in time?

In today’s high speed, high pressure and high-stress world it’s utterly important to keep up with things going on with your website. Being well-informed means being in the know of how speedily the monitoring service can contact you - as how will you save the world if you don’t know what’s happened in time? HostTracker gives you this unique opportunity to be the first to find out when your website goes down or stops functioning the way it should.

However, there are a couple of factors to keep in mind. All issues – especially serious ones - need to be clearly prioritized. By far, keeping up with all warning notices without managing their preferences beforehand can be really challenging. Chances are, that at some time in your life, you’ll simply get your mail drowned in the notification spam.

In light of this, HostTracker provides a set of default notification preferences. Generally, they are split up into three categories:

  • Short-term issues - the alert is not sent at all;

  • Major issues – the administrator is notified right away.

  • Long-term issues – the manager is notified right away.

If your website falls into one of these three groups, HostTracker emails you at once. There are many ways you could configure HostTracker to send notifications out. The direct message notifications could be sent via e-mail, SMS, Skype, Viber, Hangouts, Telegram or Slack. It’s up to you to choose which method (methods) you want to use. Rather, if you have your phone number attached to your HostTracker account you can also turn on SMS or voice call notifications. HostTracker values its customers' time above all else and provides notification scheduling as well. Therefore, you won’t be annoyed with your phone buzzing all night long, as well as, you’ll get your notifications in small doses in time throughout the day.

Additionally, there are several sub-categories based on following events:

  • If the website experiences some performance problems;

  • If the website is offline;

  • If the website is back online or performance problems have been successfully sorted out.

Whilst the first and third options are clear to understand, the second is likely pretty vague. So when can you expect your alerts on the second occasion? HostTracker will drop you multiple timely alerts every time when the check is unsuccessful – note, we consider only confirmed minor/major problems.

The system work is organized in such a brilliant way, that every responsible person for the website well-being happens to be protected from being spammed by multiple unimportant notifications or reminders, and get them only on the serious events. For example, suppose your website is managed by both the administrator and manager, and is currently offline. In that case: first, the e-mail will be sent directly to the administrator; second, after quarter an hour the administrator will receive the direct SMS notification; third, if that situation does not change after more than an hour, the SMS will be sent to the manager, to boot. Sounds ideal, isn’t it? While it may be ample for your needs, HostTracker offers one more feature – Time of activity - in order to help you solve your problems in a much more quick and efficient way.

One reason why using Time of activity option is of interest to our clients is that they could enjoy a good night sleep without worrying whether their shift administrator will miss an important alert. By the way, all outlined options are fully-customizable.

As a customer-oriented company, we provide not only different useful tools for smooth website life online but also lend an air of ‘peace and relaxation’ to our customers – they are not stressed out by annoying ongoing notifications. Various settings allow our customers to clearly define and assign roles and responsibilities for team members, collaborate better and ultimately, have an overview of the whole website performance and keep track of the all technical difficulties they experience with their website. 100% customer satisfaction is our goal.



 

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