Aireforge Monitor

Introduction

Aireforge Monitor allows you to monitor the health and performance of your SQL Server estate. This guide will walk you through the main features and how to use them, from setting up your server estate to running health checks and viewing results.

What You'll Learn:

  • How to run quick and full health checks
  • How to interpret and act on the results
  • Customizing health checks for your environment

2. Running Health Checks

Aireforge Monitor offers two main types of health checks to assess your SQL Server's health.

To Run Health Checks:

  1. Select the servers you want to monitor from your server list.
  2. Click 'Quick Test' for a fast, high-level overview of critical metrics.
  3. Click 'Full Checks' for a detailed examination of server health, covering areas like:
    • CPU and Memory Usage
    • Database Free Space
    • Availability Groups
    • SQL Agent Jobs
    • Failed Logins and more.

Full checks provide a comprehensive picture of your SQL estate, identifying potential issues before they escalate.

Refer to the Estate Management section if you need more details about importing or organizing servers.

3. Viewing and Interpreting Results

Once a check is complete, Aireforge Monitor presents the results in an easy-to-read table.

To View Results:

  • Check the table to see the results for each server and metric.
    • Results are categorized as Error, Critical, Warning, or Pass.
  • Click on a specific result for more details about the issue and what might be causing it.

Interpreting Results:

  • Error: These require immediate attention. You should prioritize fixing these issues.
  • Critical: Important but can be dealt with soon.
  • Warning: A potential issue that may develop if not monitored.
  • Pass: No action is needed.

By understanding these categories, you can prioritize your tasks and focus on critical problems first.

4. Customizing Health Checks

You may want to monitor metrics specific to your environment that aren't covered by the default checks.

To Create Custom Checks:

  1. Go to the Custom Health Checks section in the Monitor tab.
  2. Click 'Create New Check' and define the criteria or metrics you want to monitor.
  3. Save the check, and it will be added to your list of available checks.

For more advanced users, refer to the Custom Health Checks documentation for detailed steps on writing queries and setting up scripts to monitor specific performance indicators.

Conclusion

By following these steps, you can efficiently use Aireforge Monitor to keep your SQL Server estate in top shape. From setting up your servers to running customized health checks, Aireforge Monitor gives you the tools to monitor and maintain performance effectively.