Windows task scheduler
What is the windows task scheduler?
It is a Windows component that can schedule programs and programs to run at pre-defined times or after specified time intervals.
Why should you care about it?
Sometimes, there some non-SQL related tasks scheduled that can start during SQL peak times without you knowing and impact performance.
By the way, this check is a part of our SQL Server Health Check.
How to check it?
1- Use the Windows search box and search for “Scheduler”.
2- Click on the Task scheduler library to list all the schedules.
How to fix it?
- See what can be removed.
- If the task must remain, schedule it away from SQL peak times.