Services.msc database

Page 3 of 3 FirstFirst 123

  1. Posts : 147
    Windows 10 Pro
    Thread Starter
       #21

    10 needs only about 10 core services, the rest can be "safely" disabled.
    Could you please expand on this...

    Also I thought that if you disable a service, this action does not necessarily disable its dependency(ies).
      My Computers


  2. Posts : 1,255
    Windows 10 Pro
       #22

    Windows will function with only the core services but functionality will be seriously impaired. Networking, the Internet, and many things we take for granted would be gone. And if this were done don't expect a major improvement in performance. In most cases any performance increase would be unmeasureable, let alone noticeable. These kind of measurements are very difficult to do right. Most amateur attempts produce invalid results.

    If a service is disabled, or not running for any other reason, all services that depend on it will fail to start. That is what service dependency means. Typically there will be no attempt to start services it may depend on. The only time when this will happen is when the service was set to Manual by default. And don't expect helpful error messages. In most cases a service that failed to start would not know why.
      My Computer


  3. Posts : 147
    Windows 10 Pro
    Thread Starter
       #23

    OK but can you make a comment on my example. A while ago I installed SQL Server 2008 on another computer with Windows 7. I noticed a lot of disk use and an increase in memory and processor use. So I went through and disabled everything listed under the name of SQL Server and perhaps some other services related to it in services.msc. I honestly can't remember everything I did because I didn't note it down at the time. So from a performance point of view when I did this (i.e. disabled the relevant services) I went back to pre-SQL Server installation disk, memory and processor use. This worked for me.

    What I want to understand is that if .NET for example is a dependency of SQL Server (and this may not be true - I actually don't know if this is the case) it would also be disabled automatically without any action by me and I would be unable to use it for other applications (even though I did not disable .NET myself for example) - actually is that the case?

    I do remember trying to load SQL Server when it was disabled and getting some sort of error message telling me it wasn't working - I can't give you specific details because it was some time ago.
      My Computers


  4. Posts : 1,255
    Windows 10 Pro
       #24

    .NET does not depend on SQL server but the reverse is true, at least for recent versions.

    My previous comments were regarding the standard Windows services and do not apply to anything not part of the OS. That running SQL server would impair performance is hardly surprising. It's requirements can be quite high. Much depends on the version of the software, your system specs, and what you are trying to do. And SQL server is of course intended for server use but can be used locally. Server and application software do not play well together as they have different and conflicting requirements. A server was designed to provide things to clients and how it runs applications locally is secondary. Clients of course were designed to run applications and all else is secondary. You can run both if your system is powerful enough and your requirements are not too high but neither will perform optimally.
      My Computer


  5. Posts : 147
    Windows 10 Pro
    Thread Starter
       #25

    Sorry for the late reply. My internet is very slow today plus I had a problem with another PC which is stuck on 3% trying to upgrade to 1809.

    My previous comments were regarding the standard Windows services and do not apply to anything not part of the OS.
    This now makes perfect sense as you were referring to standard Windows services and I was thinking of new software added to the operating system.

    I think Microsoft should make the use of msconfig > Startup and services.msc clearer as they can be misused. If there is an option to 'Disable' anything in Windows a user may think that it is safe to do so...

    I gave up on SQL Server and Visual Studio some time ago. I attempted to upgrade my skills from Access but didn't really take to manual T-SQL input in SQL Server. I am much happier now as I do not work with databases anymore.
      My Computers


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 06:53.
Find Us




Windows 10 Forums