Some tips to work with SQL Server 2016 alerts SQL Server 2016 writes the events into the Windows Application log. SQL Server Agent checks the Windows application log for SQL Server events. When an event occurs, the SQL Server Agent checks if the appropriate alert exists and if so perform the defined response. Alerts can be used to execute a...
Tag: jobs
Tips for using jobs in SQL Server 2016
Tips for using jobs in SQL Server 2016 Run the scheduled jobs during periods of low database access. To reduce the total SQL Server overhead, try to schedule SQL Server 2016 jobs during CPU idle time and slow production periods. For example, you can schedule the job to run every night at midnight. Specify the understandable job name. Try to […]
Intelligent error alerting to reduce On-call hours
Intelligent error alerting to reduce On-call hours: The purpose of this article is to get you some much needed sleep! Yes, you heard me! So try to stay awake for this! I intend to introduce you to a few tried and true strategies to improve error and issue resolution and ultimately get you and your teammates a good night’s sleep....
Troubleshooting SQL Server 2012 jobs
Troubleshooting SQL Server 2012 jobs If you have problems with SQL Server 2012 jobs, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 jobs bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article was...
Tips for using jobs in SQL Server 2012
Tips for using jobs in SQL Server 2012 Specify the understandable job name. Try to specify the job’s name so, that the name describes what the job makes. By using so, you can simplify jobs administering and monitoring. Try to separate very large job into several small jobs. This can improve performance, and can be useful to maintenance the jobs...