Review your Windows task scheduler: It can impact your SQL Server performance

Category: Performance
Item: 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.

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

I love making performance tuning SQL Servers fast and making them more stable. And I channel that obsession into our SQL Managed Services and new content here. When I'm not writing about SQL, I spend time outside hiking, skiing, mountain biking, or trying a new recipe.

Leave a Reply

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