We are a small bank and we have 5 VMware ESXi servers with mainly Windows Server VMs with numerous windows services installed and most of these servers have Microsoft SQL Server and Microsoft IIS installed. Also we have some applications that have application logs (mainly in a db table) and we have a few Hangfire instances and one MQ Series server.\n\n

Now the management gave me the task of site reliability (I'm fairly new to this) which means all Windows Services must run 24/7 so I have to know if a service fails to start. All databases must run properly so I have to know locks, Query performance, and any SQL Agent job failures. The same goes for IIS websites/services must be up and running all the time.\n\n

In addition to these, I must collect all the Hangfire job failures(which are a lot) as well as general server metrics like CPU, RAM, I/O Disk, Disk sizes, etc.\n\n

On top of all these, I must setup alerts via Slack/sms or mail. Now the question which tool or a stack of tools can achieve all that? ","private":false,"viewCount":26057,"publishedAt":"2023-09-20T10:08:21Z","upvotesCount":8,"decisionType":"getAdvice","fromTools":[],"toTools":[],"subjectTools":[{"type":"id","generated":false,"id":"Tool:101231775525897727","typename":"Tool"},{"type":"id","generated":false,"id":"Tool:101231774455039874","typename":"Tool"}],"services":[{"type":"id","generated":false,"id":"Tool:101231773705712932","typename":"Tool"},{"type":"id","generated":false,"id":"Tool:101231775677381912","typename":"Tool"},{"type":"id","generated":false,"id":"Tool:101231773863508555","typename":"Tool"},{"type":"id","generated":false,"id":"Tool:101231773853065695","typename":"Tool"},{"type":"id","generated":false,"id":"Tool:101231775935393716","typename":"Tool"},{"type":"id","generated":false,"id":"Tool:109456149670187331","typename":"Tool"}],"topics":[],"__typename":"StackDecision"},"Tool:101231775525897727":{"id":"101231775525897727","name":"Graylog","slug":"graylog","title":"Open source log management that actually works","verified":true,"imageUrl":"https://img.stackshare.io/service/4392/_HU28D42.png","canonicalUrl":"/graylog","path":"/graylog","votes":70,"fans":918,"stacks":575,"followingTool":false,"followContext":null,"__typename":"Tool"},"Tool:101231774455039874":{"id":"101231774455039874","name":"Prometheus","slug":"prometheus","title":"An open-source service monitoring system and time series database, developed by SoundCloud","verified":false,"imageUrl":"https://img.stackshare.io/service/2501/default_3cf1b307194b26782be5cb209d30360580ae5b3c.png","canonicalUrl":"/prometheus","path":"/prometheus","votes":239,"fans":4895,"stacks":4290,"followingTool":false,"followContext":null,"__typename":"Tool"},"Tool:101231773705712932":{"name":"Slack","path":"/slack","id":"101231773705712932","imageUrl":"https://img.stackshare.io/service/675/RNiSRYOF_400x400.jpg","thumbUrl":"https://img.stackshare.io/service/675/thumb_RNiSRYOF_400x400.jpg","stacks":120182,"fans":114195,"votes":6023,"followingTool":false,"__typename":"Tool"},"Tool:101231775677381912":{"name":"Hangfire","path":"/hangfire","id":"101231775677381912","imageUrl":"https://img.stackshare.io/service/4676/7880472.png","thumbUrl":"https://img.stackshare.io/service/4676/thumb_7880472.png","stacks":171,"fans":317,"votes":17,"followingTool":false,"__typename":"Tool"},"Tool:101231773863508555":{"name":"Microsoft IIS","path":"/microsoft-iis","id":"101231773863508555","imageUrl":"https://img.stackshare.io/service/1056/J5gFiHbG.png","thumbUrl":"https://img.stackshare.io/service/1056/thumb_J5gFiHbG.png","stacks":15467,"fans":9882,"votes":236,"followingTool":false,"__typename":"Tool"},"Tool:101231775935393716":{"name":"Windows Server ","path":"/window-server","id":"101231775935393716","imageUrl":"https://img.stackshare.io/service/5108/2bsDgJd0_400x400.jpg","thumbUrl":"https://img.stackshare.io/service/5108/thumb_2bsDgJd0_400x400.jpg","stacks":524,"fans":347,"votes":0,"followingTool":false,"__typename":"Tool"},"Tool:109456149670187331":{"name":"VMware ESXi","path":"/vmware-esxi","id":"109456149670187331","imageUrl":"https://img.stackshare.io/service/48291/default_61ce96b4378e0a2a4b386b66a34c393760b770e0.jpg","thumbUrl":"https://img.stackshare.io/service/48291/thumb_61ce96b4378e0a2a4b386b66a34c393760b770e0.jpg","stacks":27,"fans":26,"votes":0,"followingTool":false,"__typename":"Tool"},"$Tool:101231773853065695.stackDecisions({\"first\":6}).edges.0":{"node":{"type":"id","generated":false,"id":"StackDecision:111096922196180179","typename":"StackDecision"},"__typename":"StackDecisionEdge"},"User:109600136601037350":{"id":"109600136601037350","username":"mailtokarthi0510","title":"","companyName":"","imageUrl":"https://img.stackshare.io/user/1425424/default_cd49a48e41b65ae225616490844f7203e1744cb5.png","thumbUrl":"https://img.stackshare.io/user/1425424/thumb_cd49a48e41b65ae225616490844f7203e1744cb5.png","displayName":"karthikeyan s","__typename":"User"},"StackDecision:109600262770069687":{"user":{"type":"id","generated":false,"id":"User:109600136601037350","typename":"User"},"company":null,"link":null,"publicId":"109600262770069687","id":"109600262770069687","htmlContent":"

Hi Friends, I am planning to create a web and mobile app for eCommerce purposes, which is very similar to Swiggy.com/Zomato. Started this app and created API using .NET Core, Entity Framework, and Microsoft SQL Server as DB. Consuming this API in Flutter for mobile and web UI. Just want some help and suggestions about this selection. Worrying about the application's scalability and performance, please suggest me a good architecture to create this application, which may be used by more people over a period of time.","private":false,"viewCount":162582,"publishedAt":"2022-12-30T02:28:10Z","upvotesCount":6,"decisionType":"getAdvice","fromTools":[],"toTools":[],"subjectTools":[{"type":"id","generated":false,"id":"Tool:101231776647396130","typename":"Tool"},{"type":"id","generated":false,"id":"Tool:101231777036008618","typename":"Tool"},{"type":"id","generated":false,"id":"Tool:101231773854768982","typename":"Tool"}],"services":[{"type":"id","generated":false,"id":"Tool:101231777036008618","typename":"Tool"},{"type":"id","generated":false,"id":"Tool:101231773853065695","typename":"Tool"},{"type":"id","generated":false,"id":"Tool:101231774843614701","typename":"Tool"},{"type":"id","generated":false,"id":"Tool:101231776647396130","typename":"Tool"}],"topics":[],"__typename":"StackDecision"},"Tool:101231776647396130":{"id":"101231776647396130","name":".NET Core","slug":"dot-net-core","title":"An Open Source, General-Purpose Development Platform Maintained by Microsoft and the .NET Community","verified":false,"imageUrl":"https://img.stackshare.io/service/6403/default_91fc1f0ee315262794273aa1387eaf8fed8436e6.png","canonicalUrl":"/dot-net-core","path":"/dot-net-core","votes":155,"fans":3499,"stacks":4483,"followingTool":false,"followContext":null,"__typename":"Tool","thumbUrl":"https://img.stackshare.io/service/6403/thumb_91fc1f0ee315262794273aa1387eaf8fed8436e6.png"},"Tool:101231777036008618":{"id":"101231777036008618","name":"Flutter","slug":"flutter","title":"Cross-platform mobile framework from Google","verified":false,"imageUrl":"https://img.stackshare.io/service/7180/flutter-mark-square-100.png","canonicalUrl":"/flutter","path":"/flutter","votes":1192,"fans":18369,"stacks":17105,"followingTool":false,"followContext":null,"__typename":"Tool","thumbUrl":"https://img.stackshare.io/service/7180/thumb_flutter-mark-square-100.png"},"Tool:101231773854768982":{"id":"101231773854768982","name":"Redis","slug":"redis","title":"Open source (BSD licensed), in-memory data structure store","verified":false,"imageUrl":"https://img.stackshare.io/service/1031/default_cbce472cd134adc6688572f999e9122b9657d4ba.png","canonicalUrl":"/redis","path":"/redis","votes":3948,"fans":55240,"stacks":59861,"followingTool":false,"followContext":null,"__typename":"Tool"},"Tool:101231774843614701":{"name":"Entity Framework","path":"/entity-framework","id":"101231774843614701","imageUrl":"https://img.stackshare.io/service/3251/no-img-open-source.png","thumbUrl":"https://img.stackshare.io/service/3251/thumb_no-img-open-source.png","stacks":658,"fans":447,"votes":19,"followingTool":false,"__typename":"Tool","thumbRetinaUrl":"https://img.stackshare.io/service/3251/thumb_retina_no-img-open-source.png","slug":"entity-framework"},"$Tool:101231773853065695.stackDecisions({\"first\":6}).edges.1":{"node":{"type":"id","generated":false,"id":"StackDecision:109600262770069687","typename":"StackDecision"},"__typename":"StackDecisionEdge"},"User:107660843544645826":{"id":"107660843544645826","username":"blacknight-rh","title":null,"companyName":null,"imageUrl":"https://img.stackshare.io/user/1115318/default_7e4cecfbcfc8d0c8d10d738993a1fbebd116918e.jpeg","thumbUrl":"https://img.stackshare.io/user/1115318/thumb_7e4cecfbcfc8d0c8d10d738993a1fbebd116918e.jpeg","displayName":"blacknight-rh","__typename":"User"},"StackDecision:108740502224182371":{"user":{"type":"id","generated":false,"id":"User:107660843544645826","typename":"User"},"company":null,"link":null,"publicId":"108740502224182371","id":"108740502224182371","htmlContent":"

Which option do you prefer to go with (considering scalability, and a limited budget):\n\n

Technologies in use: \nAngular / .NET Core 6 \n\n

What do we want to achieve?\n\n

We want to create simple near-time web notifications, those notifications can be categorized into 2 sections: \n\n