Add SQL Server On Linux

PREVIEW FEATURE

Monitoring SQL Server on Linux is currently a preview feature and as such instances on a Linux machine will not consume a licence until it comes out of preview. Currently, the preview release only supports Alerts, Grouping and general sampling of metrics.
If you have any feedback on the feature so far, please reach out to us at sqlmonitorfeedback@red-gate.com

Starting with SQL Server 2017 (14.x), SQL Server supports running on a Linux host. SQL Monitor supports monitoring SQL Server hosted on a Linux machine.

This page explains how to add SQL Server instances, running on non-cloud-hosted Linux machines.

  1. Go to the Configuration tab and, under Monitoring, select Monitored servers.
  2. Click the Add SQL Server button. The Add SQL Server panel expands:

  3. Select Linux as the host operating system.

In the machine name field, enter the server you want to monitor.

Adding an instance

To add the SQL Server instance on a Linux machine, enter the machine IP address, under the machine name.
SQL Monitor adds the instance that is running on the machine.

  1. You will need to provide two sets of credentials to connect to:
    • The host Linux machine on which the instance is running.
    • The SQL Server instance.

    SQL Monitor uses SSH to connect to a Linux host, provide the SSH credentials to connect to the host. For the instance, enter the SQL Server credentials.

    SQL Monitor does not require any root privileges for the SSH connection.

  2. To set more advanced properties (e.g., to connect to a SQL server on a different port), click Edit properties in the SQL Server section.
    The SQL Server Connection Properties dialog opens:
  3. Enter the properties you want to change for this instance and click OK. If you change the connection properties, they are identified as Custom:

    The connection properties persist until you move to a different page in SQL Monitor. If you add more servers, they will use the custom connection properties.

  4. When you click Add, SQL Monitor attempts to add the host machine and instance(s) to the list of monitored servers:

    Once added, server name can't be edited. If you typed the name incorrectly, the server will be added with a status of "Connection failed (Unreachable)". To fix this, remove the server and add it again.

    Once a connection is established and a data collection event succeeded, the status is displayed as Monitoring (Connected). If SQL Monitor encounters a problem and displays a different status, see Monitoring status explained.

    The added SQL Server instance on a Linux host will be visible to all SQL Monitor users.

Editing the credentials or properties of monitored servers

See Managing Monitored Servers.





Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?