Skip to main content
SQL Planner

Configuration

Unified SQL Monitoring Across Networks

Install local SQL Planner instances per network and sync monitoring data to a Central SQL Planner with Linked Server satellite upload.

2 min readUpdated

Have multiple SQL Servers on different networks, and want to monitor and analyze them all from one Central SQL Planner? SQL Planner supports this with local instances plus satellite sync.

Architecture overview

Consider a scenario with three separate networks, each hosting multiple SQL Servers. Install SQL Planner in each network and configure that local SQL Planner to monitor the SQL Servers on that network and to handle alerts locally.

The Central SQL Planner must be hosted on a common network or in the cloud and must be reachable from every local network. Whitelist the Central SQL Planner so local SQL Planner instances can connect to it — only then can local private SQL Planner data sync to the Central SQL Planner.

Local SQL Planner instances per network sync monitoring data to one Central SQL Planner.

Configure local instances to sync with Central SQL Planner

Local SQL Planner resource data stored in SQL Server is synchronized to the Central SQL Planner using the SQL Server Linked Server feature.

Settings → Upload Data To Satellite — point each local instance at the Central SQL Planner.
  1. 1

    Open Upload Data To Satellite

    In each local SQL Planner application go to Settings → “Upload Data To Satellite” tab.

  2. 2

    Enter central server details

    Provide the central SQL Server name and a SQL user account created on the Central SQL Server with limited permissions (INSERT and SELECT on the Central SQL Planner database tables).

  3. 3

    Update Satellite Server

    Click Update Satellite Server.

  4. 4

    Verify the scheduled job

    Confirm that the scheduled job “SQLMaint_Upload_To_Satellite” exists in each local environment. If it does not appear, click Update Satellite Server again and verify the job is created.

Confirm the SQLMaint_Upload_To_Satellite scheduled task exists after updating satellite settings.

Security

Because synchronization uses SQL Server Linked Servers and operates within your company network, security configuration and enforcement remain under your organization’s control. You can encrypt connections, apply certificates and adjust Linked Server settings to conform to your security policy.