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.

 

Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email

Leave a Comment

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

4.8/5

42

TESTIMONIALS

FREE Scripts to Instantly
Improve SQL Server Performance

3 FREE Scripts to Instantly
Improve SQL Server Performance

Learn how to increase Performance of SQL Server INSTANTLY with 3 free scripts.