Manage SQL Server
  • 23 Jan 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Manage SQL Server

  • Dark
    Light
  • PDF

Article Summary

Ensuring the optimal performance of your SQL server involves maintaining the health of its physical infrastructure, including disks, CPU, memory, and other components. To monitor the SQL Server, you need to add SQL Servers to the system .Similarly, for monitoring SQL jobs, you need to add SQL instances to the  system.

Adding SQL servers

Add SQL Server to manage and monitor the server Disk, System resources, Event logs, and NT Services running in the server. 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. Navigate to Environment Settings->General->SQL Server and click Add SQL Server.
  3. Select the server type as non-clustered or Clustered.
    1. Non-Clustered - Provided SQL Server name, though it's reachable or not reachable you can add the server, but the monitoring will work seamlessly only if it's reachable.
    2. Clustered -For a cluster SQL Server, you need to add the SQL Server Network Name instead of the SQL Server name. Then select the instance type as Default or Named, If it's named then you need to provide the name of the instance. Once the clustered server is added, BizTalk360 can determine the Active node.
  4. Click Add to add the SQL server, the server connectivity is checked with either Telnet or Ping. Once the SQL Server is added, you can administrate and monitor the resources from BizTalk360 if that is reachable. The reachability of the server is indicated with a color patch of green and red.
  5. Remove Server - If the SQL Server is removed, then all the monitoring configurations for that server will be removed.

You can still add the SQL Servers that are temporarily unavailable, but you will see some discrepancies in the monitoring dashboard(you cannot see the graph properly). However, it will work seamlessly once the server is reachable.

Adding SQL instances:

The SQL instances must be added to monitor and administrate the SQL jobs. By default, all the instances associated with the BizTalk environment will be added automatically in case if you want to add additional instances, follow below steps.

  • Log in to BizTalk360 and Select the Particular environment.
  • Navigate to Environment Settings->General->SQL Server and click Add SQL Instances
  • Enter the SQL instance name and click Add button.

Once the SQL Server instance is added, you can start administrating and monitor the SQL jobs from BizTalk360.

Note: The instances from the SQL server should belongs the same domain.

 To add Sql server or SQL instance the service account should be added to the Administrator group in the SQL Server node.


The number of SQL servers and SQL instances you can add is based on the licensing tier. 
Gold tier - 4 SQL servers.
Platinum tier - 8 SQL servers.

Please contact license@biztalk360.com to monitor more SQL servers.




Was this article helpful?

ESC

Eddy, a super-smart generative AI, opening up ways to have tailored queries and responses