| title | sys.dm_os_child_instances (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 08/18/2017 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 1bef3074-0ccc-48fa-8f3d-14f3d99df86b | ||||
| caps.latest.revision | 37 | ||||
| author | JennieHubbard | ||||
| ms.author | jhubbard | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Returns a row for each user instance that has been created from the parent server instance.
IMPORTANT! [!INCLUDEssNoteDepFutureAvoid]
The information returned from sys.dm_os_child_instances can be used to determine the state of each User Instance (heart_beat) and to obtain the pipe name (instance_pipe_name) that can be used to create a connection to the User Instance using [!INCLUDEssManStudioFull] or SQLCmd. You can only connect to a User Instance after it has been started by an external process, such as a client application. SQL management tools cannot start a User Instance.
NOTE: User Instances are a feature of [!INCLUDEssExpressEd11] only.
NOTE To call this from [!INCLUDEssSDWfull] or [!INCLUDEssPDW], use the name sys.dm_pdw_nodes_os_child_instances.
| Column | Data type | Description |
|---|---|---|
| owning_principal_name | nvarchar(256) | The name of the user that this user instance was created for. |
| owning_principal_sid | nvarchar(256) | SID (Security-Identifier) of the principal who owns this user instance. This matches Windows SID. |
| owning_principal_sid_binary | varbinary(85) | Binary version of the SID for the user who owns the user Instance |
| instance_name | nvarchar(128) | The name of this user instance. |
| instance_pipe_name | nvarchar(260) | When a user instance is created, a named pipe is created for applications to connect to. This name can be used in a connect string to connect to this user instance. |
| os_process_id | Int | The process number of the Windows process for this user instance. |
| os_process_creation_date | Datetime | The date and time when this user instance process was last started. |
| heart_beat | nvarchar(5) | Current state of this user instance; either ALIVE or DEAD. |
| pdw_node_id | int | Applies to: [!INCLUDEssSDWfull], [!INCLUDEssPDW] The identifier for the node that this distribution is on. |
Requires VIEW SERVER STATE permission on the server.
For more information about dynamic management view, see Dynamic Management Views and Functions (Transact-SQL) in [!INCLUDEssNoVersion] Books Online.