Review Your Windows Task Scheduler: It May Affect Your SQL Server Performance
Category: Performance
What is a Windows task scheduler?
It is a Windows component that can schedule programs and schedules to run at predefined times or after specified time intervals.
Why should you care about this?
Sometimes, unbeknownst to you, some non-SQL related tasks are scheduled that can start at peak SQL times and affect performance.
How to check it?
1- Use the Windows search box and search for “Scheduler”.
Click on Task scheduler to list all programs.
How to fix it?
- See what can be removed.
- If the task needs to stay, we recommend scheduling it for times when SQL has no transaction load.
