You could do something like this:

NSERT INTO @tmp    --> Internal SQL table

EXECUTE('DBCC checkdb ('DBNAME')');

SELECT * FROM @tmp where field like '%ERROR%'

If you got full recovery model, make sure the transaction log backups set up properly.  This causes the disk space issues, too.

Is this crystal report you are asking about or SSRS?

Definitely build a test environment to check/test your solution first.

Please read this web site information:

https://www.sqlshack.com/move-sql-database-files-mdf-ldf-another-location/

https://www.sqlshack.com/how-to-add-a-new-disk-to-an-existing-sql-server-failover-clustered-instance/

YOUR TWO BIG QUESTIONS ARE:

1 - how important/useful (for what?) will such storage of Win Event log data in sql server table?

in what situation can it come in handy to...

Old article from Paul Randall, but good reading:

https://www.sqlskills.com/blogs/paul/why-you-should-not-shrink-your-data-files/

Some good comments from the best minds.

Do you have a Azure VPN resource setup for your VM SQL server or just your Azure VM box?

This could solve your problem.

Please check out this link:

https://learn.microsoft.com/en-us/azure/virtual-network/troubleshoot-outbound-smtp-connectivity#recommended-method-of-sending-email.

Note:

+ I would setup...

Makes sense...

Here is a comment:  If you have a cloud platform, could you not use DW servers within the cloud with proper firewall rules.   This would be a different way...

Brent Ozar makes good points about SQL 2019 performance issues:

https://www.brentozar.com/archive/2023/03/is-sql-server-2019-more-cpu-intensive-than-sql-server-2016/

Why would you use a transactional replication in AG?    I see the benefit.   However, the replicas would do the same thing.  right?

Few comments here:

Some monitoring tools are good, and some are not so good.   So you need to bench-mark these tools before using in a live platform.

SQL memory Min/Max memory may...

Visual studios provides good help for these issues.

Sometimes, you need to use : SQLserver instant name + port (1433).  I would use another port if you can.

The error message could indicate you have a network connectivity /...

Have you tried to repair the SQL installation?   Clean registry / ensure programs are un-installed correctly.

If yes, then re-install on a different folder.  This helps sometimes.

Note: As always, please check...