New Maintenance Plan Wizard fails with ‘Agent XPs component is turned off as part of the security configuration’? Here is how to turn Agent XPs back on.
A Performance Counter Baseline Saved to a Table Every 15 Minutes
Save a performance counter baseline every 15 minutes, calculate interval rates, detect resets, and compare a defined week with last month.
SQL Agent Alerts for Severity 17 to 25 and Errors 823, 824, 825
Configure Agent alerts for serious severities and errors 823, 824 and 825, connect an operator to Database Mail, and test response delays.
mssql-conf: Configuring SQL Server on Linux Without a GUI
Use mssql-conf for SQL Server on Linux memory, file defaults, Agent, ports, and trace flags, then verify effective settings after restart.
SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server
SQL Server Agent fails to start with Error 15281 because Agent XPs are turned off? Here is how to enable Agent XPs with sp_configure and start the agent.
Keeping msdb Small With sp_delete_backuphistory
Use sp_delete_backuphistory to control msdb growth, choose a retention window, and schedule weekly SQL Server Agent cleanup.
Azure SQL Database or Managed Instance
Azure SQL database or managed instance is a choice about compatibility, cross-database work, Agent, networking, and the cost of each service.