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.

Jose

Jose

I am an Enterprise SQL Server Database Administrator with 10+ years of experience working with complex transactional environments.

Leave a Reply

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

Call Us Now

Or, Let Us Know How We Can Help

Tight On Time?

Schedule A Call: