SQL Server Health Check

Disable Unnecessary SQL Server Instances and Services

Updated October 29, 20251 min read

Turn off the SQL Server services nobody uses. Ploom walks past three empty desks with their lamps left on.

Why should you care about services that are not needed?

You may be wasting your precious resources on unused services.

It would be best if you prioritized your more critical SQL Server instance to use more resources and did 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.
Figure 1 – SQL Server Configuration Manager

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

T-SQL
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 Server instances and services that are not used.
  2. Adjust the max memory, the threshold to parallelism, and MAXDOP settings for all instances appropriately.

Check Red9's SQL Server Services

SQL Server Consulting

Perfect for one-time projects like SQL migrations or upgrades, and short-term fixes such as performance issues or SQL remediation.

Discover More ➜

SQL Server Managed Services

Continuous SQL support, proactive monitoring, and expert DBA help with one predictable monthly fee.

Discover More ➜

Emergency SQL Support

Take the stress out of emergencies with immediate access to a SQL Server Sr. DBA 24x7x365

Discover More ➜

Explore All Services ➜