I was approached with a requirement to monitor a multi-tier application setup where the customer had Microsoft BizTalk Server with Microsoft SharePoint adapter which in turn was relying on MS SQL Server Database. In addition we were also required to monitor some Windows services, processes and their performance. The challenge is to be cost efficient and not to deploy too many monitoring solutions.
Well, I had one tool in my bag to achieve this. The more powerful and even more modern Monitoring Studio X.
Monitoring Studio X provides you with a one stop solution. A single knowledge module which can monitor individual applications, databases, processes, storage devices, IoTs and the list goes on.
There are various Monitors at our disposal to achieve this. We can develop custom Templates comprising of Command Line Analysis, Database Query, File monitoring, Folder monitoring, Performance Counters monitoring, Process monitoring, Services monitoring and Windows Event monitoring features.
The best practice to develop a custom template is to work with a test system which resembles the production system in set up and installed components. Monitoring Studio X lets you pick the metrics or components present on the server you are using for development whilst the template is applied on the host.
To cover this particular use case, I developed individual templates to monitor Microsoft BizTalk Server, Microsoft SharePoint, Microsoft SQL Server and Windows System. Each template functions separately with its own defined monitors related to their application. You can activate or deactivate the templates at any moment.
I have setup a demo at https://xdemo.sentrysoftware.com/#!/console/X_HOST/@OVHDEMOWIN~10.12.0.13.
In this setup we have a server OVH-DEMO-WIN with the templates for Microsoft BizTalk Server, Microsoft SharePoint, Microsoft SQL Server and Windows System activated. Make sure all the required credentials and parameters are provided.
Once activated and configured with appropriate credentials, each application will be monitored individually using a single KM without using any additional KMs to monitor Databases, Logs, Operating System etc. This makes life easier to manage the configuration, thresholds and events.Also, it helps you make sure that all the components of your multi-tier application service model function properly from one place.
The templates used in this example and more can be downloaded from studioX-templates/templates at master · sentrysoftware/studioX-templates · GitHub