Review your Windows Task Scheduler: It can impact your SQL Server performance

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?

  1. See what can be removed.
  2. If the task must remain, schedule it away from SQL peak times.

More information

Microsoft – Task Scheduler for developers.

Mark Varnas

Mark Varnas

Hey I'm Mark, one of the guys behind Red9. I make a living performance tuning SQL Servers and making them more stable. I channel my SQL into our SQL Managed Services, SQL Consulting and our internal database products.

Leave a Reply

Your email address will not be published. Required fields are marked *