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.
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.
- 1
Open Upload Data To Satellite
In each local SQL Planner application go to Settings → “Upload Data To Satellite” tab.
- 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
Update Satellite Server
Click Update Satellite Server.
- 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.
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.
