How the Automatic SQL Server Health Check affects Server Performance?

As you probably know, SqlBak recently announced an Automatic SQL Server Health Check feature that adds significant value to SqlBak as a database backup service allowing it to monitor such vital parameters of your server as database size, transaction log size, file stream, free disk space and folder size.

This feature is loved my many system and database administrators since it allows them to shift the burden of tracking these critical indicators to the service freeing their minds for other crucial tasks.

But you may ask How does this health check affect the performance of my server?

To answer this question let’s look in details of what types of server monitoring takes place here.

SQL server availability (SQL down alerts)

The availability check is performed with 5 min interval on the Professional plan, 10 min on Standard and 60 min on the Free plan. This test simply checks that your server is alive and reachable, and it brings almost zero of additional load to the server.

SQL Server monitoring

Health and performance of your SQL Server are checked once an hour by running several simple SQL queries requesting multiple parameters on every database from the server. It also doesn’t load your server significantly since SQL Server is able to process thousands of such operations per second. SQL Server monitoring is an optional feature available in Professional version only and it is Off by default.

Folder Size Monitoring

When you enable SQL Server monitoring, SqlBak also collects folder sizes on your server giving you an opportunity to quickly deal with the no-free-disk-space problem.

Here you also should not worry about any drop in performance as this process runs in the background with the lowest priority among other main processes in Windows. This means that when the system is idle it can give more attention to updating folder size information, but when you run any other crucial processes – this task will pause or will be executed with minimal system load.

Note that the folder sizes are updated once daily, so the information you see on your monitoring page may be up to 1 day old.

Summary

The automatic SQL Server health check performed by SqlBak is designed to have little impact on your server performance and can be used in any production environment.

Leave a Reply

Your email address will not be published. Required fields are marked *