Help with a .net core api architecture

Kasuhiko — Thu, 06 Oct 2022 21:05:54 +0000

Hi Everyone,

I hope everyone is doing good, today I need some advice to optimize resources to create monolithic API architecture based on .net core and mssql, I got a freelance project from my friend's company and they need to migrate an old nodejs api to API .net core API, this API is going to be used by 40 or 50 users but they want to make it to support at least 100 connections.

basically, this API is going to serve information from 5 different mssql databases to 4 main applications:

1.- Power BI.
2.- Custom-made angular dashboard with reports, charts and stuff.
3.- Custom-made angular intranet.
4.- Excel sheets with dynamic information.

the server provided by my client specs are:

INTEL Xeon E5-2670 v2 @ 2.50GHz (2 processors)
Windows server 2012 R2
5gb RAM
1gb internet connection (probably optical fiber)

this same server is also used as web server with apache to run the angular app's and the databases are located on others differents servers.

thanks in advance, any advice is very appreciated!!.

DEV Community: Kasuhiko

Help with a .net core api architecture