Hope everyone doing good.
We need to implement audit-logging in Rest API(Microservice) application which is responsible to write logs in the Database side. Mostly we need performance for write operations and and read operation happens very frequently. After certain of time range e.g after 6 month , these logs can be deleted with trigger or existing DB feature. Cost and performance wise we have below options. can anyone pls suggest which DB we should Use with reason ?
DB Options: -
- Azure SQL
- Cosmos
- Azure table storage
- Azure blob storage
- Serverless Azure SQL
Thanks in advance..!!