Disable unnecessary SQL Server instances and services

Why should you care about them?

You may be wasting your precious resources on unused services.

It would be best if you prioritize your more critical SQL Instance to use more resources and do not allow less important ones to take all of them.

How can I list all the SQL Server instances and services?

  1. Click Start and search for “configuration”.
  2. Open “SQL Server configuration manager” and choose “SQL Server Services”.
Figure 1 – SQL Server configuration manager.

Also, you can list all instances installed using the T-SQL code below.

EXEC master.sys.xp_regread @rootkey = 'HKEY_LOCAL_MACHINE',
@KEY = 'SOFTWARE\Microsoft\Microsoft SQL Server',
@value_name = 'InstalledInstances'

How can you fix them?

  1. Disable the SQL instances and services that are not used.
  2. Adjust the max memory, the threshold to parallelism, and max DOP settings for all instances appropriately.

More information

Microsoft – Start, stop, pause, resume, restart SQL Server services.

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.