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 > speed

We’re happy to announce that we've finally released “Response time check” tool to diagnose poor website performance. Speed is one of the most important things in website workflow as it affects not only Google rankings but also your visitor conversions. Here in this article:

▶​ Which components make up page load time?

▶​ Website speed optimization.

▶​​ How to measure your website response time with HostTracker?

 

We’re happy to announce that we've finally released “Response time check” tool to diagnose poor website performance. Speed is one of the most important things in website workflow as it affects not only Google rankings but also your visitor conversions. A recent study shows that visitors aren’t willing to wait more than 3 seconds for a page to load. And truly, we all know how waiting for a slow loading website can feel like an eternity when you’re trying to get some vital information. Actually, a lazy website may cost your business. What really matters is that simply taking a few steps in optimizing website performance can make a very big difference. So, let’s look at some common causes of a slow website and how you can speed these things up.

Which components make up page load time?

  1. DNS lookup time - the amount of time it takes a domain name being mapped to an equivalent IP-address to be found. 
  2. Connect Time (TCP) - how long it takes to establish a connection to the web server. 
  3. First Byte Time (TTFB) - the time it takes to get the server response as well as the interval since the server receives HTTP request till the server sends the first byte of the response back. 
  4. Download Time (Content Time) – the time span between start and end of content load.

Note: If you’re using SSL Certificate for a secure connection, you’ll need an extra time to spend on authentication, that means additional time for establishing a link between your web server and a browser.

All these components together stand for the page response time. See, it's quite possible that your website is slow because of the problem with one of the five things mentioned above.

Website speed optimization

Website loading speed depends on several factors and each of them could hold things up. Let's find out the most common reasons why your website speed may be slow.

When something wrong with the website itself:

  1. Third-Party Objects. Different third-party plugins hosted on the page can slow down your website. Even though the most powerful services such as Google Analytics integrate these scripts async and seamlessly for website performance, still placing third-party plugins will cause a delay in loading as each one of them adds up to the total number of requests that are being sent. Although the website speed is affected by numerous things, yet it is primarily impacted by the number of HTTP requests your website makes. So the golden rule of optimization is the less weight website to carry, the faster it works.

  2. Media From Other Sources. The more external media files on the page, the longer your website takes to load. Such bulky content has not only a negative impact on web page speed but it’s also one of the surest ways to make visitors leave. How can it be avoided? First, place someone else’s media in moderation; Secondly, use proper graphics file formats; Thirdly, leverage reliable local storage. If you do a couple of these things, you’ll see significant improvements in no time!

  3. Bulky code/ Inefficient SQL. Inefficient code or unoptimized database queries can have a really degrading effect on your website performance. Consider doing some code optimization like editing some scripts, HTML, CSS code etc; or database optimization like adding some indexes, altering the queries, modifying the structure etc. Problems with code are usually the culprit of dragging your website performance down.

When your hosting is killing your speed:

  1. DNS – your website destiny depends on the DNS server choice you make. The faster your DNS server, the quicker content on your page will be delivered.

  2. The Data Center Location. Do not neglect geography. It’s important to ensure that your vis­i­tors are hit­ting the near­est data col­lec­tion cen­ter. Understanding the time taken on transmitting information gives you a better awareness of user experience you’re providing, because you know, it takes time for data to be delivered. If the site is a global resource, it is recommended to use CDN (Content Delivery Network), that is, a network of globally distributed web servers which is used to deliver website content to the local end-users as fast as possible. Essentially, it’s hosting your files across all this server network and delivering them from the closest location. It’s worth noting, that in recent years the popularity of cloud hosting has skyrocketed. No surprise as it costs less, provides more and gives the opportunity to benefit from infinite flexibility.

  3. Choosing the wrong web hosting service. The reality is that sometimes the biggest problem with your website performance is that it requires simply more resources, than your web host can provide. Consider searching for a web hosting company that best suits your needs. It should go without saying: choosing a good hosting company is a key to high website performance.

How to measure your website response time with HostTracker?

In the Response Time Check window please enter your URL, task name, and specify the Timeout value.

Note: Every time your speed value exceeds this threshold, you will receive a notification.

Armed with this tool you’ll be always updated on how well your website loads - website statistics and history of events are always available in a convenient format (see the picture above).

Hope you enjoy this article! Remember the hardest thing in optimization is often to simply get started.

 

 

 

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