I am working on a project where logs of all kinds (e.g. errors, warnings, etc.) are stored in a database table, in the same transactional database used for the other business purposes. It is a MSSQL database.
A good practice is to use a NoSQL databases to store logs, stream them and query them (e.g. using the ELK stack). However, my team doesn't have that infrastructure available; only MSSQL.
Are there any benefits of placing the log table in a database by its own? That is, the resulting database would have only one table specifically to store the logs. The log table by itself is of about 10GB.