Content Check
Content CheckContent check is a way to check the presence of specific info on the page.
Content Check Content check is a way to check the presence of specific info on the page.

Content check is a way to check the presence/absence of specific info on the page. It helps to check not just the page itself for accessibility, but the performance of the site too. It is useful for sites with complicated structure - which contain many scripts and data that is stored in database or other off-site storages. In this case, there is possible cases when the page itself is working fine while some of the linked resources are not available - thus, some info on the page is missed.

HostTracker provides tools to solve this problem. You may create ContentCheck task and provide specific keywords for monitoring:

There are several important things on that screen:

Content Check - set of comma-separated keywords to look for.
Advanced Content Check option - useful for immediate detection of the reasons of a problem. In case of appearance of the keyword, the phrase, previous to the keyword, is sent you as the result of the check. For example, you enter keyword exception and select this option. Somehow, on the page appears the statement: Wrong SQL statement on the line 123 exception. In this case, you get an alert saying Wrong SQL statement on the line 123.
Conditions Field - allows to specify conditions for set of keywords. You may set to detect an error in case of presence/absence of all entered keywords, or just any of them.

For monitoring the presence of images, videos, execution scripts - you may choose a keyword from their description, or add a special short script which will return Error or other keyword if something is missed.

Restrictions:
Only first 10 Kb of page are analysed
Only first 120 characters of each line are analysed

  • CM.Glossary.Uptime
  • CM.Glossary.WebsiteMonitoring
  • CM.Glossary.Uptime
  • CM.Glossary.WebsiteMonitoring
more glossary
"Your sites is very nice and is the best service for web designers. thanks a lot."
- Del.
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 > uptime_matters

While you may be spending more time and resources on developing your website, you need to be sure that the core of the website is still performing well. There is a strong correlation between uptime and visitor conversions. Are you still wondering why is website uptime so important? Then take a deeper dive into this...

While you may be spending more time and resources on developing your website, you need to be sure that the core of the website is still performing well. There is a strong correlation between uptime and visitor conversions. Moreover, nothing drives your visitors to your competitors faster than multiple extensive and ongoing downtime issues. Are you still wondering why is website uptime so important? Uptime is being considered a critical metric of the website well-being. It reflects the percentage of time your website happens to be available to the visitors. Let’s take a deeper dive into this.

Track your website uptime or you put your business at risk

Imagine, you’ve already done all hard work – built a dream team of talented individuals (designers, copywriters, developers etc.), who are shouldering their delegated roles perfectly. And together you all created more than just a website - a master of the Google search that reflects on your personal brand. This suggests you put specific keywords and phrases throughout your website and your brand’s online profiles – so that if people go looking for you on Google, they are likely to find your website.

And there is someone who wants to visit your website, but a current outage is stopping him from camping on the webpage. No matter who you are, a multinational corporation or news portal, if your website goes down for even several minutes, it can impact negatively on your reputation, revenue, productivity and appeal among your visitors. Apparently, downtime is bad for your bottom line, but it costs differently within industries. Business size is the most obvious factor, but it is not the only one. Most of the visitors have a short patience span for even minor website hassles, especially when it comes to making major purchases. Therefore, ensuring your website stays up is a key to your successful business.

Inaccessible website is your clients’ losses

It seems that, inaccessible website puts the visitors off from using it. If your website is designed, for example, for reading books online but inaccessible at the moment, all your customers, including your loyal ones, wouldn’t be able obtain the information they need from your website. This suggests, all your readers won’t be able to get to know you and vice versa you won’t be able to connect to them. Imagine that right now there is someone who wants to buy or read a book from your platform. Try as he may, he can’t reach your website, because it’s closed. And now, he’ll think twice before going back to the platform that evokes frustration and irritation in him. He will definitely find another platform where buying and reading are much easier. Having an online 24/7/365 presence means you are very likely to gain more customers, increase your credibility and spread your business.

Server is down?

Reliability is a key piece of a good web hosting. Reliable web hosting providers not only try to keep the websites always online, secure, and fast, but also ensure that they’re reachable. Consequently, if you’re an unreliable hosting company, you put businesses that use your service at risk. Every minute their websites are down they are paying for it in business success and positive image among customers. What could it mean to hosting providers? In the era of an increasingly connected world, information spreads faster than ever. And we all know the power of customer reviews. Negative feedbacks mean little unless they have a profound effect on a company's ability to do business as well as the ability to stay ahead of the competition. When the company, in particular web hosting company, lost the faith of their clientele, this lead either to huge outflow of service consumers or potentially damaging situation for a brand.

Another example of how company’s reputation could be burned worst by downtime is an online store. Research shows that 60% of shoppers are surfing the net and even more read product reviews before making a purchase. There are many reasons why people choose not to shop at an online store, but perhaps the most striking is when specific website is down. Obviously, it would be a real struggle to keep the visitors on the website in case of a sudden server downtime. Downtime should be considered something to be avoided at all costs, because visitors are not going to wait at your doorstep. They’ll certainly leave your portal and never come back, as how they can lend an air of credibility to your website if you can’t help yourself…

Warren Buffet once said: “It takes 20 years to build a reputation and five minutes to ruin it”.

Out of a search engine?

Downtime issues contribute negatively to your search engine rankings as well. This implies, when Google try to rate your website and find out that it’s down, your website in most cases will temporarily drop in the Google search result rankings. Generally speaking, short periods of website downtime won’t hurt your search rankings that much, but long, consistent ones - will blow your rankings to bits. Scary?

Proactive monitoring of your website is the best way to stay one step ahead of any website bottlenecks and outages. You may rest easily using HostTracker service. HostTracker'll let you know whenever the incident is escalated, as well as, you will be in advance of your website issues. Spot problems before they arise and protect your business from losses that they can create!

 

 

 

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