Why Resource Governor Ignores Your SQL Server Agent Job Owner
You did everything right. Resource Governor is configured, you have a workload group that caps CPU and memory so one runaway job cannot starve everything else, and you have a classifier function that reads the…
Monitoring SQL Server Agent Job Failures with SolarWinds DPA Custom Alerts
DPA’s built-in job failure alert fires on every step failure including intentional ones. These two custom SQL alert queries filter to step_id = 0, catching only genuine job-level failures.
SSRS and Multi-Subnet Failover: The Connection String That Doesn’t Exist
SSRS has no way to specify MultiSubnetFailover=True in its ReportServer database connection. Here’s how to automate SSRS reconfiguration after an AG failover across subnets using rsconfig.exe, sp_update_jobstep, and a SQL Agent alert.
Configure a SQL Server Agent Operator
SQL Server Agent operators are used by SQL Server Agent to send notifications about events as they happen. Typically, this would include notifications that a SQL Server Agent Job failed during execution. You might also…
Automating Alerts
SQL Server Agent provides a great mechanism for sending alerts via email in response to various events. Once you’ve setup Database Mail, and configured a SQL Server Agent Operator, you should add alerts for severe…
Setup Database Mail
SQL Server includes a great feature known as Database Mail. This post provides a quick script showing how to setup Database Mail without requiring you to click through a cumbersome user interface. The first part…