Web monitor process7/28/2023 ![]() ![]() Tables Description TableĬontains all categories for environments: development, qa and productionĬontains all categories for services: database, rest API, server, URL and web serviceĬontains all components from C# side to perform watch operationsĬontains the relation for service and environment, for example we can define a service named FinanceService with different environments: development, qa and productionĬontains the status for each service per environmentĬontains the details for each service environment statusĬontains the user list for application that represents all ownersĬontains the relation between service and ownerĬontains the relation between service and userĪlso I don't recommend to expose real connection strings in ServiceEnvironment table, please request to your DBA a single user can only perform open connection for target database, in case the security of databases be a task from your side, create specific users to perform ONLY open connection to databases and prevent exposing sensitive information.NET Core Solution Inside of repository, there is a directory with name \Resources\Database and this directory contains related database files, please make sure to run the following files in this order: File NameĬonstraints (primary keys, foreign keys and uniques) RESTful APIs will be monitoring with REST client to target an action that returns simple JSON. Hosts will be monitoring with ping action, so we'll add networking related packages to perform this action.ĭatabases will be monitoring with open and close connections, don't use integrated security because you'll need to impersonate your service monitor process with your credentials, so in that case, it's better to have a specific user to connect with database and only that action to avoid hacking. Open and close the connection for existing databaseĪs we said before, we'll create an application to monitoring existing targets (hosts, databases, APIs), so we need to have basic knowledge about these concepts. In this guide, we'll work with monitoring the following services: Name One special feature could be to have a notification service to send messages for all administrators in case one or more services fail, in this context, service means a target such as host, database, API. The basic idea is this: have a process to run in infinite ways to monitor hosts, databases and APIs save monitoring results in SQL Server database, then we can build a fancy UI to end-user and show status for each service, we can have a lot of targets to monitoring but it's better to allow users to subscribe for specific services and not all for example DBAs need to watch database servers not APIs, developers need to watch development databases and APIs, etc.Īlso think about having big monitors in your development room and watching the status for your services and in the best of cases, have charts. NET Core power to build an application that developers can extend for custom requirements. I know there are a lot of tools that can provide this feature, also there are better tools that money can buy but my intention with this guide is to show how to use. This guide is about how to create a service monitor application, but what is it? In simple words: it's an application that allows to monitor services in a network and save results from monitoring in a database, SQL Server for this case.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |