You won’t figure it out until it’s too late. It’s been forever since I’ve gotten a failure email.” In reality, there are hundreds or thousands of emails piled up in some SQL Server somewhere with a broken email delivery subsystem, like an old SMTP server address. When email delivery stops, you won’t notice. People think, “Hey, things must be going great these days. Your messages ain’t coming along for the ride. Database Mail lives in the MSDB database and Service Broker. To protect your user databases, you’re likely using log shipping or Always On Availability Groups, and in the future, it’s only getting more complex with SQL Server 2022’s ability to fail over to Azure SQL DB Managed Instances. Sure, it seemed robust when it came out a couple decades ago, but these days, anything involving the word “enterprise” needs to survive a data center failover. SQL Server’s email delivery isn’t very robust. Whoever started the documentation by writing “Database mail is an enterprise solution” had clearly never seen an enterprise solution in real life. I’m talking about using SQL Server to send emails to confirm a customer’s order, alert that a product is low on stock, or other business processes. That’s fine when you can’t get the business to spring for a monitoring system. I’m not talking about Agent alerts when jobs fail. I would like to unsubscribe from this idea.
0 kommentar(er)
