Monitoring doesn't just stop with BizTalk Servers. BizTalk Administrators have the option of doing basic server monitoring of SQL Servers using BizTalk360. SQL Server hosts all the BizTalk databases such as Message Box, Business Activity Monitoring, Tracking Data, Custom Databases among others and is critically important to be monitored. You can monitor the SQL Server components such as Disks, System Resources (CPU and Memory), Event Logs, and NT Services.
BizTalk360 offers performance monitoring and alerting through a web-based UI that will let you keep track of the status of the SQL server. The first step in setting up monitoring for SQL servers is to configure the required SQL servers. You need to add the SQL servers into BizTalk360 before you can define any monitoring rules against them.
Adding SQL Servers
- Log in to the BizTalk360 application
- Click 'Settings' icon found at the top of the page
- Click 'Monitoring and Notification' in the navigation panel on the left side of the screen
- Click 'SQL Servers for Monitoring' option from the list
- Enter the SQL Server Names in the space provided. You can enter a maximum of 2 servers as comma separated values
- Click Save to save the information