locked
SQL server process Confusion RRS feed

  • Question

  • Hello guys ,

    I am little bit confused on the behavior of SQL server , you can see in the snap, why it is showing twice in task manager for SQL Server process with different PID if i am having only one SQL server (Default) has been installed in the server,

    I can see one service on the name of  "Windows internal database(**)" is running with the same PID which is showing as sqlservr.exe, can you please let me what is this all about?

     

       

    Friday, March 23, 2018 11:47 AM

Answers

  • The windows internal database is a SQL Server instance used to support certain Microsoft products. See https://en.wikipedia.org/wiki/Windows_Internal_Database.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    • Proposed as answer by Tom Phillips Friday, March 23, 2018 12:16 PM
    • Marked as answer by Olaf HelperMVP Saturday, April 14, 2018 1:55 PM
    Friday, March 23, 2018 12:07 PM

All replies

  • The windows internal database is a SQL Server instance used to support certain Microsoft products. See https://en.wikipedia.org/wiki/Windows_Internal_Database.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    • Proposed as answer by Tom Phillips Friday, March 23, 2018 12:16 PM
    • Marked as answer by Olaf HelperMVP Saturday, April 14, 2018 1:55 PM
    Friday, March 23, 2018 12:07 PM
  • They are different things with the same program name.

    • Proposed as answer by Hannah Yu Monday, March 26, 2018 7:29 AM
    Friday, March 23, 2018 12:17 PM
  • The windows internal database is a SQL Server instance used to support certain Microsoft products. See https://en.wikipedia.org/wiki/Windows_Internal_Database.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    Thanks Dan,

    But still confusing.. i mean to say what is the use of it and when it is required? 

    Monday, March 26, 2018 10:08 AM
  • LocalDB is a smaller version of SQL Express used by developers for their applications.  Many applications need a database and install SQL Express or LocalDB for their application.  It has nothing to do with the SQL Server installation you are using, other than the executable name.

    https://blogs.msdn.microsoft.com/sqlexpress/2011/07/12/introducing-localdb-an-improved-sql-express/

    Monday, March 26, 2018 11:12 AM