Manage SQL Server

It is important to make sure the physical infrastructure of your SQL server’s disks, CPU, memory, etc., are healthy for proper functioning. To monitor the SQL Server, you have to add the SQL Servers manually into the portal.

Adding SQL servers

To add SQL servers to the BizTalk360 portal, you need to follow the below steps:

1. Log in to BizTalk360 and Select the Particular environment
2. Go to the Environment Settings page
3. Select General dropdown
4. Navigate to Manage SQL Server and click Add SQL Server
5. In the SQL Server Names box, add the SQL Servers

Once the SQL Server added for monitoring, you can monitor the resources.

If the SQL Server is removed, then all the monitoring configuration for that server will get removed.

Adding a Clustered SQL Server

To Monitor a cluster SQL Server, you need to add the SQL Server Network Name instead of the SQL Server name. BizTalk360 will automatically define the SQL Server added for monitoring as clustered or non-clustered.