My advice is: never use SQL server email capability for third party apps.   Please use third part app to take care of the emailing capability.

The permissions between the Local admin and Domain admin users are not the same.

Domain user profile is different from the Local user admin profile in most cases.

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...

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.