DxPS Admin Guide

Overview

DH2i software includes Windows PowerShell cmdlets (DxPS) that you can use to control and administer DxEnterprise cluster(s) locally or remotely. This admin guide includes all of the DxEnterprise cmdlets and sample scripts to successfully manage a DxEnterprise cluster. For additional information on how to use Windows PowerShell, please reference Microsoft Windows PowerShell documentation.

DxPowerShell Requirements

DxPS requires a minimum Windows PowerShell version 3. This version is installed by default on Windows operating systems.

To confirm which version you have installed, check the Version property of the Get-Host cmdlet or the PSVersion property of the $PSVersionTable variable.

If required, Windows PowerShell version 3 setup package can be downloaded from Microsoft's website

Installing the DxPowerShell module

The DxPowerShell module (DxPS.dll) is installed as part of DxEnterprise software bundle. There are no additional steps required.

Importing the DxPowerShell module

DxPowerShell module (DxPS.dll) must be imported before you can begin using it. The module can be found in the \bin subdirectory where you install DH2i software. The default installation location is \Program Files\DH2i\bin.

To import the DxPowerShell (DxPS.dll) module:

1. Use the Windows PowerShell Import-Module cmdlet with -DisableNameChecking option. If nothing is returned, then the import was successful.

   

2. Execute the Start_DxPS.cmd in the DH2i\bin folder.

3. Select the "DxPowerShell Utility" option under Advanced Configuration in DxAdmin.

   

DxPowerShell Classes and Cmdlets

DxPowerShell module is defined by a set of classes and cmdlets. Through the following classes and cmdlets, you can locally or remotely administer and manage a DxEnterprise cluster.

DxResult

This class represents the xml result set returned by DxPowerShell cmdlets.

Properties

|Name|Type|Description| |---|---| | Status | Integer | Status code. Non-zero value represents an error has occurred. | | Result | String | A well-formed xml string represents the output from the process. |

Examples

PS C:> [xml]$xml = Dx-GetVersion | Select-Object -ExpandProperty
Result

PS C:> $xml.result

Commands

Dx-AddAGS

Add an availability group to a Vhost.

Syntax

Dx-AddAGS [-VhostName] <string> [-AGSName] <string> -AGSParams <string[]> [<CommonParameters>]

Detailed Description

This cmdlet adds an availability group to an existing Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True
AGSParams	String	Space delimited parameter sets for each participant in the availability group: <node_name|instance_name|sql_login|sql_pass|mirror_port|availability_mode|[tunnel_port]>	True	True

Examples

Dx-AddAGS "Vhost1" "AGS1" "node1|instance1|sa|Pa$$word|5022|synchronous_commit"

Dx-AddAGS "Vhost1" "AGS1" "node1|instance1|sa|Pa$$word|5022|synchronous_commit" "node2|instance1|sa|Pa$$word|5022|synchronous_commit"

Dx-AddAGSDatabases

Add a database to an availability group.

Syntax

Dx-AddAGSDatabases [-VhostName] <string> [-AGSName] <string> -Databases <string> [<CommonParameters>]

Detailed Description

This cmdlet adds databases to an existing availability group.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True
Databases	String	Comma delimited list of database names.	True	True

Examples

Dx-AddAGSDatabases "Vhost1" "AGS1" "db1,db2,db3"

Dx-AddAGSListener

Add a listener port to an availability group.

Syntax

Dx-AddAGSListener [-VhostName] <string> [-AGSName] <string> [-TCPPort] <int> [<CommonParameters>]

Detailed Description

This cmdlet adds a TCP listener port to the primary replica of an availability group.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True
TCPPort	Integer	The TCP port to listen on.	True	True

Examples

Dx-AddAGSListener "Vhost1" "AGS1" 11433

Dx-AddAGSNode

Add a member to an availability group.

Syntax

Dx-AddAGSNode [-VhostName] <string> [-AGSName] <string> -AGSParams <string> [<CommonParameters>]

Detailed Description

This cmdlet adds a new member to an existing availability group.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True
AGSParams	String	Space delimited parameter sets for each participant in the availability group: <node_name|instance_name|sql_login|sql_pass|mirror_port|availability_mode|[tunnel_port]>	True	True

Examples

Dx-AddAGSNode "Vhost1" "AGS1" "node3|instance1|sa|Pa$$word|5022|synchronous_commit"

Dx-AddContact

Add a contact to the address book.

Syntax

Dx-AddContact [-Name] <string> [-Email] <string> [<CommonParameters>]

Detailed Description

This cmdlet adds a contact to the address book for the currently connected cluster.

Parameters

Name	Type	Description	Required	Command-line Input
Name	String	Contact Name.	True	True
Email	String	Contact email address.	True	True

Examples

Dx-AddContact "support" "support@dh2i.com"

Dx-AddDisk

Add a disk to the current cluster.

Syntax

Dx-AddDisk [-DiskID] <string> [[-Label] <string>] [<CommonParameters>]

Detailed Description

This cmdlet puts the disk under DxEnterprise management.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID.	True	True
Label	String	Name of the disk on the current cluster.	False	False

Examples

Dx-AddDisk "dad7b407-b77a-b98b-edbb-df64556eeb17" "Cluster Disk 1"

Dx-AddDocker

Add an instance of a Docker container to a Vhost.

Syntax

Dx-AddDocker [-VhostName] <string> [-DockerName] <string> [-Image] <string> [-DockerParams] <string[]> [<CommonParameters>]

Detailed Description

This cmdlet adds an instance of a Docker container to a Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
DockerName	String	The name of the Docker container.	False	False
Image	String	The name of the Docker image.	True	True
DockerParams	String	The docker run parameters that the Docker instance will use on startup (comma delimited for multiples). The parameters are a triplet of <docker_run_option>|<value>|<value_is_encrypted>	True	True

Examples

Dx-AddDocker "VHOST1" "MSSQL1" "microsoft/mssql-server-linux" "-e|ACCEPT_EULA=Y|False","-e|SA_PASSWORD=Pa$$word|False","-p|50250:1433|False","-h|VHOST1|False","-v|/mnt/mssql:/var/opt/mssql|False","-os|linux|False"

Dx-AddFileshare

Add a network file share.

Syntax

Dx-AddFileshare [-VhostName] <string> [-ShareName] <string> [-SharePath] <string> -Grants <string[]> [-Comments <string>] [-MaxAllowedUsers <int>] [-Caching {manual | BranchCache | documents | programs | none}] [<CommonParameters>]

Detailed Description

This cmdlet adds a network file share to a Vhost. The Windows file share will be created on all nodes associated with the Vhost. The path must be accessible on all associated nodes.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
ShareName	String	The name of the file share.	True	True
SharePath	String	Local share path.	True	True
Grants	String	Grant parameter string array delimited by a comma (,). Each parameter name and value pair is delimited by a colon (:).	True	True
Comments	String	User defined comment.	False	False
MaxAllowedUsers	Integer	Max concurrent users allowed to the share. Default is unlimited.	False	False
Caching	String	Caching mode for the share. Possible mode : manual, BranchCache, documents, programs, none.	False	False

Examples

Dx-AddFileshare "VHOST1" "SHARE1" "K:\Share1"
"everyone,read:administrators,full"

Dx-AddInstance

Add an instance to a Vhost.

Syntax

Dx-AddInstance [-InstanceName] <string> [-TCPPort] <int> [-DataPath] <string> [-LogPath] <string> [[-KeepExistingData]] [<CommonParameters>]

Detailed Description

This cmdlet adds a named instance of SQL Server to a Vhost and puts it under DxEnterprise management. The named instance must already be installed on all nodes associated with the Vhost. The data and log paths must point to a SAN location that is accessible to all nodes. If the optional KeepExistingData is specified, the current data and log files on the SAN are retained, otherwise they are overwritten with the local data files.

Parameters

Name	Type	Description	Required	Command-line Input
InstanceName	String	The name of the instance.	True	True
TCPPort	Integer	Static SQL Server listening port.	True	True
DataPath	String	Root path for SQL Server data (*.mdf, *.ndf).	True	True
LogPath	String	Root path for SQL Server logs (*.ldf).	True	True
KeepExistingData	Switch Parameter	Whether to overwrite the target data in the DataPath and LogPath or to preserve it. Default is false if not specified.	False	False

Examples

Dx-AddInstance "VHOST1\CUSTOMER" 44444 "S:\Sqldata\Customer\Data"
"S:\Sqldata\Customer\Logs"

Dx-AddNode

Add node(s) to a Vhost.

Syntax

Dx-AddNode [-VhostName] <string> [-Nodes] <string> [<CommonParameters>]

Detailed Description

This cmdlet adds node(s) to a Vhost. If the Vhost has any instances under its management, the node(s) will undergo hosting readiness for these instances.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
Nodes	String	Node name(s). Delimited by comma.	True	True

Examples

Dx-AddNode "VHOST1" "NODE1,NODE2,NODE3"

Dx-AddPolicy

Add a policy.

Syntax

Dx-AddPolicy -SYSTEM -ObjectName <string> [-Enabled] [-PolicyID <string>] [-Description <string>] [-CounterName <string>] [-Threshold <int>] [-Operator <string>] [<CommonParameters>]

Dx-AddPolicy -PERF -ObjectName <string> -CounterName <string> -Threshold <int> [-Percent] [-Loadbalance] [-Enabled] [-PolicyID <string>] [-Description <string>] [-Operator <string>] [-ScriptPath <string>] [-Priority <int>] [<CommonParameters>]

Dx-AddPolicy -ALLOC -ObjectName <string> -CounterName <string> -Threshold <int> [-Enabled] [-PolicyID <string>] [-Description <string>] [-Operator <string>] [-ScriptPath <string>] [<CommonParameters>]

Dx-AddPolicy -FILTER [-Enabled] [-Information] [-Warning] [-Error] [-Critical] [-VhostFilter <string>] [-InstanceFilter <string>] [-DockerFilter <string>] [-NodeFilter <string>] [-PolicyID <string>] [-Description <string>] [-Operator <string>] [<CommonParameters>]

Detailed Description

This cmdlet defines a SYSTEM/PERF/ALLOC/FILTER policy.

Policy Types

SYSTEM

The SYSTEM policy sends alerts when a node is down.

This policy type can only be attached to ObjectName "node" and CounterName "system-down".

PERF

The PERF policy send alerts when a performance threshold is reached.

This policy type can be attached to:

ObjectName

• node
• instance
• service
• Docker

CounterName

• processor-consumption
• system-free-memory
• system-networking
• system-disk-io
• docker-processor
• docker-working-set
• docker-networking
• docker-disk-io
• instance-processor
• instance-working-set
• instance-networking
• instance-disk-io
• service-processor
• service-working-set
• service-networking
• service-disk-io

ALLOC

The ALLOC policy sends alerts when an allocation threshold is reached.

This policy type can be attached to:

ObjectName

• node
• instance
• service
• Docker.

CounterName

• alloc-docker-processor
• alloc-docker-memory
• alloc-docker-disk
• alloc-docker-network
• alloc-instance-processor
• alloc-instance-memory
• alloc-instance-disk
• alloc-instance-network
• alloc-node-processor
• alloc-node-memory
• alloc-node-disk
• alloc-node-network
• alloc-service-processor
• alloc-service-memory
• alloc-service-disk
• alloc-service-network

FILTER

Global filter alert type policy.

This policy type can be attached to ObjectName:

• node
• instance
• service
• Vhost
• AGS
• Docker

Parameters

Name	Type	Description	Required	Command-line Input
SYSTEM	Switch Parameter	System type policy. Used to alert when a system is down.	True	False
PERF	Switch Parameter	Performance type policy.	True	False
ALLOC	Switch Parameter	Allocation type policy.	True	False
FILTER	Switch Parameter	Global filter alert type policy.	True	False
PolicyID	String	Unique policy ID.	False	False
Description	String	User defined description.	False	False
ObjectName	String	Instance, Docker or system name.	False	False
CounterName	String	Resource/counter name. Applicable to SYSTEM, PERF, and ALLOC policies. Resource/counter names are located in drop down under Policy Types above.	False	False
Threshold	Integer	Trigger limit applicable for PERF and ALLOC policies. When this threshold is met or exceeded the system will raise an alert and carry any predefined corrective actions.	False	False
Percent	Switch Parameter	Whether or not the threshold value is a percent of total system resource. Default is false.	False	False
Operator	String	Email addresses to be sent when the policy is triggered.	False	False
ScriptPath	String	Full path to the script file to be executed when the policy is triggered.	False	False
Priority	Integer	Policy priority relative to other policies in the cluster. Valid values are between 1 and 5. With 1 being the lowest or least prioritized. Applicable to PERF policy.	False	False
LoadBalance	Switch Parameter	Whether or not to failover when the policy is triggered. Default is false.	False	False
Enabled	Switch Parameter	Whether or not the policy is enabled. Default is true.	False	False
Information	Switch Parameter	Whether or not filter only for Information severity alerts. Applicable to FILTER policy. Default is true.	False	False
Warning	Switch Parameter	Whether or not filter only for Warning severity alerts. Applicable to FILTER policy. Default is true.	False	False
Error	Switch Parameter	Whether or not filter only for Error severity alerts. Applicable to FILTER policy. Default is true.	False	False
Critical	Switch Parameter	Whether or not filter only for Critical severity alerts. Applicable to FILTER policy. Default is true.	False	False
VhostFilter	String	Inclusive list of Vhosts to raise alert for. Applicable to FILTER policy. Default is all Vhosts.	False	False
InstanceFilter	String	Inclusive list of instances to raise alert for. Applicable to FILTER policy. Default is all instances.	False	False
NodeFilter	String	Inclusive list of nodes to raise alert for. Applicable to FILTER policy. Default is all nodes.	False	False
DockerFilter	String	Inclusive list of containers to raise alert for. Applicable to FILTER policy. Default is all containers.	False	False

Examples

System Policy

Dx-Add-Policy -SYSTEM -ObjectName "NODE1"

Performace Policy

Dx-Add-Policy -PERF -ObjectName "CUSTOMER" -CounterName "instance-working-set" -Threshold 1000

Allocation Policy

Dx-AddPolicy -ALLOC -ObjectName "CUSTOMER" -CounterName "instance-working-set" -Threshold 2500

Filter Policy

Dx-AddPolicy -FILTER -InstanceFilter "CUSTOMER" -Operator "support@dh2i.com"

Dx-AddService

Add a service.

Syntax

Dx-AddService [-VhostName] <string> [-ServiceName] <string> [-Description <string>] [-AssumeVhostName] [<CommonParameters>]

Detailed Description

This cmdlet adds a service to a Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
ServiceName	String	The name of the service.	True	True
Description	String	User defined description.	False	False
AssumeVhostName	Switch Parameter	Whether or not the service runs under the Vhost name.	False	False

Examples

Dx-AddService "VHOST1" "ALG"

Dx-AddSMTP

Configure SMTP server and credentials for email alerts.

Syntax

Dx-AddSMTP -ServerName <string> -Email <string> [-Port <int>] [-Protocol {NONE | TLS | SSL}] [-EncryptedPassword] [-Password <string>] [-UserName <string>] [<CommonParameters>]

Detailed Description

This cmdlet sets the SMTP information used to send email alerts.

Parameters

Name	Type	Description	Required	Command-line Input
ServerName	String	SMTP server name or address.	True	True
Email	String	Sender email address.	True	True
Port	Integer	SMTP server connection port. Default is 25.	False	False
Protocol	String	SMTP server protocol. Valid value is NONE, TLS, or SSL. Default is NONE.	False	False
EncryptedPassword	Switch Parameter	Whether or not the supplied password value is an encrypted string obtained from Dx-EncryptText cmdlet. Default is false.	False	False

Examples

Dx-AddSMTP -ServerName "smtp.dh2i.com" -Email "support@dh2i.com"
-UserName "support" -Password "Pa$$word"

Dx-AddVhost

Add a Vhost to the cluster.

Syntax

Dx-AddVhost [-VhostName] <string> [-VIPs] <string> [-Nodes] <string> [[-AutoFailback]] [[-Priority] <int>] [<CommonParameters>]

Detailed Description

This cmdlet adds a new Vhost to the cluster configuration.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
VIPS	String	IP address(es) of the Vhost. Delimited by comma.	True	True
Nodes	String	List of nodes participating in the Vhost. Delimited by comma.	True	True
AutoFailback	Switch Parameter	Whether or not to support auto failback for the Vhost. Default is false.	False	False
Priority	Integer	Vhost priority relative to other Vhosts in the cluster. Valid values are between 1 and 5. With 1 being the lowest or least prioritized.	False	False

Examples

Dx-AddVhost "VHOST1" "10.1.200.151" "NODE1,NODE2,NODE3"

Dx-AddWitness

Add a network share witness to the cluster.

LEGACY

This command has been superseded by Dx-SetWitness. Do not use this command for Azure Blob Storage.

Syntax

Dx-AddWitness [-Shares] <string> [-UserName] <string> [-Password] <string>

Detailed Description

This cmdlet adds a new network share witness to the cluster configuration.

Parameters

Name	Type	Description	Required	Command-line Input
Shares	String	Up to three UNC network shares. Delimited by comma.	True	True
UserName	String	The name of the user.	True	True
Password	String	The password of the user (recommended to encrypt using Dx-EncryptText	True	True

Examples

Dx-AddWitness "\SERVER1\SHARE1" "user1" "6pnFaDrRS+W/F+dkRuPKAA=="

Dx-CleanDisk

Cleans the disk of all partitions, volumes, and any hidden sector information.

danger

All volumes and data will be destroyed by running this command.

Syntax

Dx-CleanDisk [-DiskID] <string> [<CommonParameters>]

Detailed Description

This cmdlet deletes the partition table on the selected disk. All user data on disk will be destroyed.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID or disk label.	True	True

Examples

Dx-CleanDisk "dad7b407-b77a-b98b-edbb-df64556eeb17"

Dx-ClearOTPK

Clears the one-time passkey.

Syntax

Dx-ClearOTPK [<CommonParameters>]

Detailed Description

This cmdlet clears all currently registered one-time passkeys for the cluster.

Examples

Dx-ClearOTPK

Dx-ClearReservation

Clears all reservations on the selected disk.

Syntax

Dx-ClearReservation [-DiskID] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes all SCSI-3 persistent reservations on the selected disk(s).

Clearing the reservation on a disk can cause data corruption if the disk is accessible to nodes outside of the cluster.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID(s) or disk lable(s). Delimited by pipe (|).	True	True

Examples

Dx-ClearReservation "dad7b407-b77a-b98b-edbb-df64556eeb17"

Dx-ClusterGetDockerImages

Returns a list of Docker images.

Syntax

Dx-ClusterGetDockerImages [<CommonParameters>]

Detailed Description

This cmdlet returns a list of all Docker images available on each cluster node.

Examples

Dx-ClusterGetDockerImages

Dx-ClusterGetInstances

Returns a list of SQL Server instances.

Syntax

Dx-ClusterGetInstances [<CommonParameters>]

Detailed Description

This cmdlet returns a list of all SQL Server instances available on each cluster node.

Examples

Dx-ClusterGetInstances

Dx-ClusterRehostDocker

Rehosts an instance of a Docker container from one Vhost to another.

Syntax

Dx-ClusterRehostDocker [-FromVhost] <string> [-ToVhost] <string> [-DockerName] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes the specified Docker instance from the source Vhost and adds it to the target Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
FromVhost	String	The source Vhost name.	True	True
ToVhost	String	The target Vhost name.	True	True
DockerName	String	The name of the Docker container.	True	True

Examples

Dx-ClusterRehostDocker "VHOST1" "VHOST2" "MSSQL1"

Dx-ClusterRehostInstance

Rehosts a SQL Server instance from one Vhost to another.

Syntax

Dx-ClusterRehostInstance [-FromVhost] <string> [-ToVhost] <string> [-InstanceName] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes the specified instance from the source Vhost and adds it to the target Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
FromVhost	String	The source Vhost name.	True	True
ToVhost	String	The target Vhost name.	True	True
DockerName	String	The name of the instance.	True	True

Examples

Dx-ClusterRehostInstance "VHOST1" "VHOST2" "INSTANCE1"

Dx-ClusterRehostService

Rehosts a service from one Vhost to another.

Syntax

Dx-ClusterRehostService [-FromVhost] <string> [-ToVhost] <string> [-ServiceName] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes the specified service from the source Vhost and adds it to the target Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
FromVhost	String	The source Vhost name.	True	True
ToVhost	String	The target Vhost name.	True	True
DockerName	String	The name of the service.	True	True

Examples

Dx-ClusterRehostService "VHOST1" "VHOST2" "SQLBrowser"

Dx-ClusterResync

Refresh cluster configuration for all members.

Syntax

Dx-ClusterResync [<CommonParameters>]

Detailed Description

This cmdlet instructs all members to refresh their cluster configuration (DxVhost.xml) file. This ensures every member has a consistent image of the cluster configuration.

Parameters

None

Examples

Dx-ClusterResync

Dx-CollectLog

Run DxCollect utility on each cluster member.

Syntax

Dx-CollectLog [<CommonParameters>]

Detailed Description

This cmdlet instructs all members to execute DxCollect.exe utility and return the status code and the newly created log file.

Parameters

None

Example

PS C:> [xml]$xml = Dx-CollectLog | Select-Object -ExpandProperty
Result

PS C:> $xml.SelectNodes("node")

name exitcode filename
---- -------- --------
NODE1 0 [C:\Program Files\DH2i\...
NODE2 0 [C:\Program Files\DH2i\...
NODE3 0 [C:\Program Files\DH2i\...
NODE4 0 [C:\Program Files\DH2i\...

Dx-CreateVolume

Creates a volume.

Syntax

Dx-CreateVolume [-DiskSpace] <string> [<CommonParameters>]

Detailed Description

This cmdlet creates a volume from any empty space available on the disk(s).

Parameters

Name	Type	Description	Required	Command-line Input
DiskSpace	String	A pipe (|) delimited list of <disk_id_or_disk_label>,<disk_size_in_bytes>	True	True

Examples

Dx-CreateVolume "dad7b407-b77a-b98b-edbb-df64556eeb17,17179869184"

Dx-CreateVolume "dad7b407-b77a-b98b-edbb-df64556eeb17,17179869184|f1ea67c8-e85c-5ae9-4e13-e95dc7a3d04a,1073741824"

Dx-DeleteVolume

Delete a specified volume.

Syntax

Dx-DeleteVolume [-VolID] <string> [<CommonParameters>]

Detailed Description

This cmdlet deletes the specified volume. All user data on the volume will be destroyed.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID.	True	True

Examples

Dx-DeleteVolume "deb7b407-a77b-889b-eddb-df63556eeb17"

Dx-DemoteAGSNode

Demote a node in the availability group.

Syntax

Dx-DemoteAGSNode [-VhostName] <string> [-AGSName] <string> -NodeName <string> [<CommonParameters>]

Detailed Description

This cmdlet sets the specified node in the availability group to be a secondary replica.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True
NodeName	String	The name of the node.	True	True

Examples

Dx-DemoteAGSNode "NODE1"

Dx-DetachAGS

Detach an availability group from DxEnterprise management.

Syntax

Dx-DetachAGS [-VhostName] <string> [-AGSName] <string> [<CommonParameters>]

Detailed Description

This cmdlet detaches an availability group from DxEnterprise management. The availability group stays active and functional, but will no longer be under the control of the DxEnterprise high availability engine for automatic health detection and failover.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True

Examples

Dx-DetachAGS "Vhost1" "AGS1"

Dx-DisableNode

Disable a cluster node.

Syntax

Dx-DisableNode [-NodeName] <string> [<CommonParameters>]

Detailed Description

This cmdlet puts a node into a "disabled" state. A disabled node is a node that is still part of the cluster but is no longer qualified to host any applications. If there are running/active applications on the node prior to the state change, they will be relocated to other node(s) in the cluster.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The name of the node.	True	True

Examples

Dx-DisableNode "NODE1"

Dx-EnableNode

Enable a cluster node.

Syntax

Dx-EnableNode [-NodeName] <string> [<CommonParameters>]

Detailed Description

This cmdlet clears the "disabled" state for a node, and potentially relocates applications on to it according to allocation and auto-failback policies.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The name of the node.	True	True

Examples

Dx-EnableNode "NODE1"

Dx-EncryptText

Encrypt a text value.

Syntax

Dx-EncryptText [-Text] <string> [<CommonParameters>]

Detailed Description

This cmdlet encrypts a text value.

Parameters

Name	Type	Description	Required	Command-line Input
Text	String	Text value to be encrypted.	True	True

Examples

Dx-EncryptText "Pa$$word"

Dx-ExecuteDebugCommand

Internal use only.

Syntax

Dx-ExecuteDebugCommand [[-Action] <string>] [-Values <string[]>] [<CommonParameters>]

Detailed Description

This cmdlet executes a command. For internal use only.

Parameters

Name	Type	Description	Required	Command-line Input
Action	String	The action to be executed.	False	True
Values	String[]	Applicable values for Action.	False	True

Examples

Dx-ExecuteDebugCommand "get-vhost" "VHOST1"

Dx-ExtendVolume

Extend the volume size.

Syntax

Dx-ExtendVolume [-VolID] <string> [-DiskSpace] <string> [<CommonParameters>]

Detailed Description

This cmdlet extends the volume size.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID to be extended.	True	True
DiskSpace	String	A pipe (|) delimited list of <disk_id_or_disk_label>,<disk_size_in_bytes>	True	True

Examples

Dx-ExtendVolume "dad7b407-b77a-b98b-edbb-df64556eeb17"
"deb7b407-a77b-889b-eddb-df63556eeb17,17179869184"

The first GUID is the VolID. The second GUID is a Disk ID,(comma)
17179869184 (the size in bytes)

Dx-FormatVolume

Formats the specified volume.

danger

Formatting will delete all data on the specified volume.

Syntax

Dx-FormatVolume [-VolID] <string> [-FileSystem {NTFS | FAT32 | ReFS}] [-VolumeLabel <string>] [-BlockSize <int>] [-QuickFormat <bool>] [-Compression <bool>] [<CommonParameters>]

Detailed Description

This cmdlet administratively formats the selected volume.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID.	True	True
FileSystem	String	Filesystem type. Valid values are NTFS on Windows or EXT4 or XFS on Linux. Default is NTFS on Windows and EXT4 on Linux	False	False
VolumeLabel	String	Name of the volume. Default is New Dx Volume.	False	False
BlockSize	Integer	Blocksize of the volume. Valid values are 512, 1024, 4096, 8192, 16384, 32768, or 65536. Default is 4096.	False	False
QuickFormat	Bool	Whether or not to perform quick format. Quick format does not zero data on disk. Default is true.	False	False
Compression	Bool	Enable coompression support for the volume or not. Default is false.	False	False

Examples

Dx-FormatVolume "dad7b407-b77a-b98b-edbb-df64556eeb17"

Dx-FormatVolumeEx

Format a volume with support for Windows format optional flags.

Syntax

Dx-FormatVolumeEx [-VolID] <string> [-FileSystem {NTFS | FAT32 | ReFS}] [-VolumeLabel <string>] [-BlockSize <int>] [-QuickFormat <bool>] [-Compression <bool>] [-Optional <string>] [<CommonParameters>]

Detailed Description

This cmdlet administratively formats the selected volume and allows Windows format optional flags to be used.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID.	True	True
FileSystem	String	Filesystem type. Valid values are NTFS on Windows or EXT4 or XFS on Linux. Default is NTFS on Windows and EXT4 on Linux	False	False
VolumeLabel	String	Name of the volume. Default is New Dx Volume.	False	False
BlockSize	Integer	Blocksize of the volume. Valid values are 512, 1024, 4096, 8192, 16384, 32768, or 65536. Default is 4096.	False	False
QuickFormat	Bool	Whether or not to perform quick format. Quick format does not zero data on disk. Default is true.	False	False
Compression	Bool	Enable coompression support for the volume or not. Default is false.	False	False
Optional	String	Optional flags available to Windows format.	False	False

Examples

Dx-FormatVolumeEx "dad7b407-b77a-b98b-edbb-df64556eeb17"

Dx-FormatVolumeEx2

Format a volume with support for Windows format optional flags.

Syntax

Dx-FormatVolumeEx2 [-VolID] <string> [-FileSystem {NTFS | EXT4 | XFS | BTRFS}] [-VolumeLabel <string>] [-BlockSize <int>] [-QuickFormat <bool>] [-Compression <bool>] [-Optional <string>] [<CommonParameters>]

Detailed Description

This cmdlet administratively formats the selected volume and allows additional filesystem types to be used.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID.	True	True
FileSystem	String	Filesystem type. Valid values are NTFS on Windows or EXT4, XFS or BTRFS on Linux. Default is NTFS on Windows and EXT4 on Linux	False	False
VolumeLabel	String	Name of the volume. Default is New Dx Volume.	False	False
BlockSize	Integer	Blocksize of the volume. Valid values are 512, 1024, 4096, 8192, 16384, 32768, or 65536. Default is 4096.	False	False
QuickFormat	Bool	Whether or not to perform quick format. Quick format does not zero data on disk. Default is true.	False	False
Compression	Bool	Enable coompression support for the volume or not. Default is false.	False	False
Optional	String	Optional flags available to Windows format.	False	False

Examples

Dx-FormatVolumeEx2 "dad7b407-b77a-b98b-edbb-df64556eeb17"

Dx-FreezeNode

Freeze a cluster node.

Syntax

Dx-FreezeNode [-NodeName] <string> [<CommonParameters>]

Detailed Description

This cmdlet administratively puts a node into "frozen" state. While the node is in this frozen state, all applications continue to run on the node even if the DxEnterprise software is removed from the node. If the node is rebooted, all SQL Server instances running on the node would require manual restart.

This cmdlet is designed to support in-place upgrade of DxEnterprise software.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The name of the node.	True	True

Examples

Dx-FreezeNode "NODE1"

Dx-FreezeVhost

Freeze a Vhost.

Syntax

Dx-FreezeVhost [-VhostName] <string> [<CommonParameters>]

Detailed Description

This cmdlet administratively puts a Vhost into "frozen" state. While the Vhost is in this frozen state, applications running under the Vhost can be stopped and started without causing the cluster to initiate a failover. If the node is rebooted, all SQL Server instances running on the node would require manual restart.

This cmdlet is applicable when maintenance of application registry or configuration is needed.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True

Examples

Dx-FreezeVhost "VHOST1"

Dx-GetAGSDetail

Get details about an availability group.

Syntax

Dx-GetAGSDetail [-VhostName] <string> [-AGSName] <string> [<CommonParameters>]

Detailed Description

This cmdlet gets all of the details, connection status and health status for the specified availability group.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True

Examples

Dx-GetAGSDetail "Vhost1" "AGS1"

Dx-GetAlerts

Get all alerts for the cluster.

Syntax

Dx-GetAlerts [<CommonParameters>]

Detailed Description

This cmdlet returns all active and persistent alerts for the current cluster.

Examples

Dx-GetAlerts

Dx-GetClusterDisks

Get a list of current cluster disks.

Syntax

Dx-GetClusterDisks [<CommonParameters>]

Detailed Description

This cmdlet returns a list of known cluster disks, including disks that are inaccessible.

Examples

Dx-GetClusterDisks

Dx-GetClusterMembers

Get a list of current cluster members.

Syntax

Dx-GetClusterMembers [<CommonParameters>]

Detailed Description

This cmdlet returns a list of known cluster members, including members that are inaccessible.

Examples

Dx-GetClusterMembers

Dx-GetConnectionInfo

Get current cluster connection details.

Syntax

Dx-GetConnectionInfo [<CommonParameters>]

Detailed Description

This cmdlet returns a detailed list of properties for the current cluster connection.

Examples

Dx-GetConnectionInfo

Dx-GetContacts

Get a list of contacts.

Syntax

Dx-GetContacts [<CommonParameters>]

Detailed Description

This cmdlet returns a list of contacts.

Examples

Dx-GetContacts

PS C:> [xml]$xml = Dx-GetContacts | Select-Object -ExpandPropertyResult
PS C:> $xml.SelectNodes("contact")
name        email
----        -----
sales       sales@dh2i.com
support     support@dh2i.com
info        info@dh2i.com
marketing   marketing@dh2i.com

Dx-GetCoordinators

Get a list of current coordinators.

Syntax

Dx-GetCoordinators [<CommonParameters>]

Detailed Description

This cmdlet returns a list of the current cluster, application and storage coordinators.

Examples

Dx-GetCoordinators

Dx-GetCoordinatorStatus

Get status for the current cluster coordinator.

Syntax

Dx-GetCoordinatorStatus [<CommonParameters>]

Detailed Description

This cmdlet returns the detailed status for the current cluster Coordinator.

Examples

Dx-GetCoordinatorStatus

Dx-GetCounters

Get system counters.

Syntax

Dx-GetCounters [<CommonParameters>]

Detailed Description

This cmdlet returns a list of supported counters for DxEnterprise.

Examples

Dx-GetCounters

PS C:> [xml]$xml = Dx-GetCounters | Select-Object -ExpandProperty Result
PS C:> $xml.SelectNodes("counter")
scope       #text
-----       -----
system      system-down
system      processor-consumption
system      system-free-memory
system      system-networking
system      system-disk-io
instance    instance-processor
instance    instance-working-set
instance    instance-networking
instance    instance-disk-io

Dx-GetDiskDetail

Get detailed information from a specified disk.

Syntax

Dx-GetDiskDetail [-DiskID] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns the detail information from the specified disk.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID or disk label of the individual disk information is being requested about.	True	True

Examples

Dx-GetDiskDetail "dad7b407-b77a-b98b-edbb-df64556eeb17"

Dx-GetDiskInfo

Get detailed information from a specified disk on a specified node.

Syntax

Dx-GetDiskInfo [-DiskID] <string> [[-NodeName] <string>] [<CommonParameters>]

Detailed Description

This cmdlet returns the detail information from the specified disk on the specified node.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID or disk label of the individual disk information is being requested about.	True	True
NodeName	String	Node name to retrieve the disk info from. The disk must be visible to the node specified.	False	False

Examples

Dx-GetDiskInfo "dad7b407-b77a-b98b-edbb-df64556eeb17" "NODE1"

Dx-GetDisks

Get disk details organized by node.

Syntax

Dx-GetDisks [[-NodeName] <string>] [<CommonParameters>]

Detailed Description

This cmdlet returns the disk information from the cluster or a specific node. If a node name is given only information from that node is returned.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	Node name to acquire the disk details from.	False	True

Examples

Dx-GetDisks "NODE1"

Dx-GetDockerDetail

Get detailed information for a Docker container.

Syntax

Dx-GetDockerDetail [-VhostName] <string> [-DockerName] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns the detailed information regarding a Docker container that is currently managed by DxEnterprise.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
DockerName	String	The name of the Docker container.	True	True

Examples

Dx-GetDockerDetail "VHOST1" "MSSQL1"

Dx-GetGlobalSettings

Get global settings.

Syntax

Dx-GetGlobalSettings [<CommonParameters>]

Detailed Description

This cmdlet returns global settings that are explicitly set by the user.

Examples

Dx-GetGlobalSettings

Dx-GetInstanceDetail

Get detailed information for a SQL Server instance.

Syntax

Dx-GetInstanceDetail [-InstanceName] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns the detailed information regarding a SQL Server instance that is currently managed by DxEnterprise.

Parameters

Name	Type	Description	Required	Command-line Input
InstanceName	String	Target SQL Server instance name to be queried. The format is as follow: 1. Named Instance - <Vhost>\<InstanceName> 2. Default Instance - <Vhost>\MSSQLServer	True	True

Examples

Dx-GetInstanceDetail "VHOST1\CUSTOMER"

Dx-GetLicense

Get a current license from a node.

Syntax

Dx-GetLicense [[-NodeName] <string>] [<CommonParameters>]

Detailed Description

This cmdlet returns the license information from a node.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	Node name to acquire the license from. Default is currently connected host.	False	True

Examples

Dx-GetLicense "NODE1"

Dx-GetLicenseRequest

Get a current license request from a node.

Syntax

Dx-GetLicenseRequest [[-LicenseCode] <string>] [[-NodeName] <string>] [<CommonParameters>]

Detailed Description

This cmdlet returns the license request information from a node.

Parameters

Name	Type	Description	Required	Command-line Input
LicenseCode	String	License code to generate the license request. Default is blank. If not specified, license request is the existing one from the target node.	True	True
NodeName	String	Node name to acquire the license request from. Default is the currently connected host.	False	True

Examples

Dx-GetLicenseRequest "0000-0000-0000-0000" "NODE1"

Dx-GetLicenses

Get a composite list of licenses from all nodes.

Syntax

Dx-GetLicenses [<CommonParameters>]

Detailed Description

This cmdlet returns a composite list of licenses from all cluster member nodes.

Examples

Dx-GetLicenses

Dx-GetMonitoredApps

Get a list of all monitored applications.

Syntax

Dx-GetMonitoredApps [-NodeName] <string> [-DxHealth] [-DxReg] [<CommonParameters>]

Detailed Description

This cmdlet returns a list of all monitored applications by DxHealth and DxReg.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The name of the node.	True	True
DxHealth	Switch Parameter	Whether or not to get list of monitored containers by DxHealth only.	False	False
DxReg	Switch Parameter	Whether or not to get list of monitored containers by DxReg only.	False	False

Examples

Dx-GetMonitoredApps "Node1"

Dx-GetMonitoredDockers

Get a list of all monitored Docker containers.

Syntax

Dx-GetMonitoredDockers [-NodeName] <string> [-DxHealth] [-DxReg] [<CommonParameters>]

Detailed Description

This cmdlet returns a list of all monitored Docker containers by DxHealth and DxReg.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The name of the node.	True	True
DxHealth	Switch Parameter	Whether or not to get list of monitored containers by DxHealth only.	False	False
DxReg	Switch Parameter	Whether or not to get list of monitored containers by DxReg only.	False	False

Examples

Dx-GetMonitoredDockers "NODE1"

Dx-GetMonitoredFileShares

Get a list of all monitored fileshares.

Syntax

Dx-GetMonitoredFileShares [-NodeName] <string> [-DxHealth] [-DxReg] [<CommonParameters>]

Detailed Description

This cmdlet returns a list of all monitored fileshares by DxHealth and DxReg.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The name of the node.	True	True
DxHealth	Switch Parameter	Whether or not to get list of monitored fileshares by DxHealth only.	False	False
DxReg	Switch Parameter	Whether or not to get list of monitored fileshares by DxReg only.	False	False

Examples

Dx-GetMonitoredFileShares "NODE1"

Dx-GetMonitoredInstances

Get a list of all monitored SQL Server instances.

Syntax

Dx-GetMonitoredInstances [-NodeName] <string> [-DxHealth] [-DxReg] [<CommonParameters>]

Detailed Description

This cmdlet returns a list of all monitored SQL Server instances by DxHealth and DxReg.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The name of the node.	True	True
DxHealth	Switch Parameter	Whether or not to get list of monitored instances by DxHealth only.	False	False
DxReg	Switch Parameter	Whether or not to get list of monitored instances by DxReg only.	False	False

Examples

Dx-GetMonitoredIntances "NODE1"

Dx-GetMonitoredServices

Get a list of all monitored services.

Syntax

Dx-GetMonitoredServices [-NodeName] <string> [-DxHealth] [-DxReg] [<CommonParameters>]

Detailed Description

This cmdlet returns a list of all monitored services by DxHealth and DxReg.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The name of the node.	True	True
DxHealth	Switch Parameter	Whether or not to get list of monitored services by DxHealth only.	False	False
DxReg	Switch Parameter	Whether or not to get list of monitored services by DxReg only.	False	False

Examples

Dx-GetMonitoredServices "NODE1"

Dx-GetNodeDetail

Get a node detail.

Syntax

Dx-GetNodeDetail [-NodeName] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns system info for a cluster member node.

Parameters

Name	Type	Description	Required	Command-line Input

Examples

Dx-GetNodeDetail "NODE1"

Dx-GetOTPK

Get any registered one-time passkeys.

Syntax

Dx-GetOTPK [<CommonParameters>]

Detailed Description

This cmdlet returns any currently registerd one-time passkeys for the cluster.

Examples

Dx-GetPolicies

Dx-GetPolicies

Get a list of policies.

Syntax

Dx-GetPolicies [<CommonParameters>]

Detailed Description

This cmdlet returns a list of policies currently configured for DxEnterprise.

Examples

Dx-GetPolicies

Dx-GetPolicy

Get a policy detail.

Syntax

Dx-GetPolicy [-PolicyID] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns policy details.

Parameters

Name	Type	Description	Required	Command-line Input
PolicyID	String	The ID of the policy.	True	True

Examples

Dx-GetPolicy "2D2E01D6-D912-4887-BAC0-9622CB1BE71E"

Dx-GetProductType

Get product type.

Syntax

Dx-GetProductType [<CommonParameters>]

Detailed Description

This cmdlet returns the product type and version of the connected cluster.

Examples

Dx-GetProductType

Dx-GetReservation

Get the SCSI reservations for a specific disk ID.

Syntax

Dx-GetReservation [-DiskID] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns the SCSI reservations for the specified DiskID.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID of the disk in which to query the reservations.	True	True

Examples

Dx-GetReservation "dad7b407-b77a-b98b-edbb-df64556eeb17"

Dx-GetServiceDetail

Get service details.

Syntax

Dx-GetServiceDetail [-VhostName] <string> [-ServiceName] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns details about the specified service.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
ServiceName	String	The name of the service.	True	True

Examples

Dx-GetServiceDetail "VHOST1" "ALG"

Dx-GetSMTP

Get SMTP settings for the cluster.

Syntax

Dx-GetSMTP [<CommonParameters>]

Detailed Description

This cmdlet returns the SMTP configuration for the current cluster.

Examples

Dx-GetSMTP

Dx-GetSQLPaths

Get SQL Server instance paths.

Syntax

Dx-GetSQLPaths [-InstanceName] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns the SQL Server instance start up path for master data, error log, and master log.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID of the disk in which to query the reservations.	True	True

Examples

Dx-GetSQLPaths "VHOST1\CUSTOMER"

Dx-GetUnusedDriveLetters

Get a list of available drive letters.

Syntax

Dx-GetUnusedDriveLetters [-VolID] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns list of drive letters that are unused. If a volume ID is included, the drive letter for the volume ID will be returned also.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID.	False	True

Examples

Dx-GetUnusedDriveLetters "3caa25ce-3866-283c-1243-b48e92a6cd1d"

Dx-GetVersion

Get the DxLMonitor version.

Syntax

Dx-GetVersion [<CommonParameters>]

Detailed Description

This cmdlet returns the current version of DxLMonitor being used.

Examples

Dx-GetVersion

Dx-GetVhost

Get Vhost detail.

Syntax

Dx-GetVhost [-VhostName] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns the configuration of a specific Vhost, including the set of nodes associated with the Vhost, and the set of instances, services or file shares associated with the Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True

Examples

Dx-GetVhost "VHOST1"

Dx-GetVhosts

Get details for all Vhosts.

Syntax

Dx-GetVhosts [<CommonParameters>]

Detailed Description

This cmdlet returns a complete contents of the cluster configuration (i.e. DxVhost.xml file).

Examples

Dx-GetVhosts

Dx-GetVolumeDetail

Get the details of a specific volume.

Syntax

Dx-GetVolumeDetail [VolID] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns the details of the selected volume.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID.	True	True

Examples

Dx-GetVolumeDetail "3caa25ce-3866-283c-1243-b48e92a6cd1d"

Dx-GetWitness

Get the current cluster witness settings.

Syntax

Dx-GetWitness

Detailed Description

This cmdlet returns the current witness settings for the cluster.

Parameters

None

Examples

Dx-GetWitness

Dx-ImportAGS

Imports and existing availability group.

Syntax

Dx-ImportAGS [-VhostName] <string> [-AGSName] <string> -AGSParams <node_name|instance_name|sql_login|sql_pass|mirror_port|availability_mode|[tunnel_port]> [<CommonParameters>]

Detailed Description

This cmdlet imports and existing availability group to be under DxEnterprise management.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True
AGSParams	String	Comma delimited parameter sets for each member of the availability group:<node_name|instance_name|sql_login|sql_pass|mirror_port|availability_mode|[tunnel_port]>	True	True

Examples

Dx-ImportAGS "Vhost1" "AGS1" "node1|instance1|sa|Pa$$word|5022|synchronous_commit" "node2|instance2|sa|Pa$$word|5022|synchronous_commit"

Dx-InstallSQL

Install a Microsoft SQL Server instance.

Syntax

Dx-InstallSQL [-Nodes] <string> [-ExecutingCommand] <string> [[-CIFUserName] <string>] [[CIFPassword] <string>] [[-ConfigFile] <string>] [-EncryptedPassword] [-IsSQL2005] [<CommonParameters>]

Detailed Description

This cmdlet pushes an unattended installation of SQL Server instance to specified nodes. The instance will not be virtualized automatically; see documentation for the add-instance command. Full command line must be provided for the installer and the path to the installer must be accessible on all nodes involved. Valid unattended commands and syntax for SQL Server can be found on Microsoft docs:

• SQL2005
• SQL2008
• SQL2008R2
• SQL2012
• SQL2014
• SQL2016
• SQL2019

Parameters

Name	Type	Description	Required	Command-line Input
Nodes	String	A list of nodes to execute the unattended SQL Server installation. Delimited by comma.	True	True
Executing Command	String	Subsequent <string> parameters after the Nodes list to form proper unattended SQL Server installation command.	True	True
CIFSUserName	String	SQL Server Login username.	False	True
CIFSPassword	String	SQL Server Password.	False	True
ConfigFile	String	Path to file with detail install meta data.	False	True
EncryptedPassword	Switch Parameter	Whether or not the supplied password value is an encrypted string obtained from Dx-EncryptText cmdlet. Default is false.	False	False
IsSQL2005	Switch Parameter	Specifies fi the instance being installed is SQL Server 2005. Default is false.	False	False

Examples

Dx-InstallSQL "NODE1,NODE2 " <Executing commands>

Dx-JoinCluster

Joins a new node to an existing cluster.

Syntax

Dx-JoinCluster [-ServerName] <string> -Passkey <string> -NatEnabled [-Activate] [<CommonParameters>]

Detailed Description

This cmdlet removes the currently connected node from any existing cluster and adds it to the cluster of the specified server.

Parameters

Name	Type	Description	Required	Command-line Input
ServerName	String	The target member server of the cluster to join the currently connected node.	True	True
Passkey	String	The configured cluster passkey of the target cluster member.	True	True
NatEnabled	Switch Parameter	For internal use only.	False	False
Activate	Switch Parameter	Whether or not to activate the node after joining the new cluster.	False	False

Examples

Dx-JoinCluster "NODE1" -Passkey "Pa$$word" --Activate

Dx-RefreshMonitoredPaths

Refresh the list of monitored paths

Syntax

Dx-RefreshMonitoredPaths [<CommonParameters>]

Detailed Description

This cmdlet rechecks the system for all Data, Log and fileshare paths and makes sure an alert is raised if a path is inaccessible by any cluster member nodes.

Examples

Dx-RefreshMonitoredPaths

Dx-ReloadMonitoredApps

Reloads the list of monitored apps.

Syntax

Dx-ReloadMonitoredApps [-NodeName] <string> [-DxHealth] [-DxReg] [<CommonParameters>]

Detailed Description

This cmdlet reloads the list of monitored applications on the specified node.

Parameters

Name	Type	Description	Required	Command-line Input
Noadename	String	The target node where DxHealth and/or DxReg must re-evaluate and monitor the active apps.	True	True
DxHealth	Switch Parameter	Whether or not only DxHealth should reload.	False	False
DxReg	Switch Parameter	Whether or not only DxReg should reload.	False	False

Examples

Dx-ReloadMonitoredApps "NODE1"

Dx-ReloadMonitoredDockers

Reload the list of monitored Docker containers.

Syntax

Dx-ReloadMonitoredDockers [-NodeName] <string> [-DxHealth] [-DxReg] [<CommonParameters>]

Detailed Description

This cmdlet re-evaluates the list of active Docker containers and ensures DxHealth and/or DxReg monitor them.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The target node where DxHealth and/or DxReg must re-evaluate and monitor the active containers.	True	True
DxHealth	Switch Parameter	Whether or not only DxHealth should reload.	False	False
DxReg	Switch Parameter	Whether or not only DxReg should reload.	False	False

Examples

Dx-ReloadMonitoredDockers "NODE1"

Dx-ReloadMonitoredFileShares

Reload the list of monitored fileshares.

Syntax

Dx-ReloadMonitoredFileShares [-NodeName] <string> [-DxHealth] [-DxReg] [<CommonParameters>]

Detailed Description

This cmdlet re-evaluates the list of active fileshares and ensures DxHealth and/or DxReg monitor them.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The target node where DxHealth and/or DxReg must re-evaluate and monitor the active fileshares.	True	True
DxHealth	Switch Parameter	Whether or not only DxHealth should reload.	False	False
DxReg	Switch Parameter	Whether or not only DxReg should reload.	False	False

Examples

Dx-ReloadMonitoredFileShares "NODE1"

Dx-ReloadMonitoredInstances

Reload the list of monitored SQL Server instances.

Syntax

Dx-ReloadMonitoredInstances [-NodeName] <string> [-DxHealth] [-DxReg] [<CommonParameters>]

Detailed Description

This cmdlet re-evaluates the list of active SQL Server instances and ensures DxHealth and/or DxReg monitor them.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The target node where DxHealth and/or DxReg must re-evaluate and monitor the active instances.	True	True
DxHealth	Switch Parameter	Whether or not only DxHealth should reload.	False	False
DxReg	Switch Parameter	Whether or not only DxReg should reload.	False	False

Examples

Dx-ReloadMonitoredInstances "NODE1"

Dx-ReloadMonitoredServices

Reload the list of monitored services.

Syntax

Dx-ReloadMonitoredServices [-NodeName] <string> [-DxHealth] [-DxReg] [<CommonParameters>]

Detailed Description

This cmdlet re-evaluates the list of active services and ensures DxHealth and/or DxReg monitor them.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The target node where DxHealth and/or DxReg must re-evaluate and monitor the active services.	True	True
DxHealth	Switch Parameter	Whether or not only DxHealth should reload.	False	False
DxReg	Switch Parameter	Whether or not only DxReg should reload.	False	False

Examples

Dx-ReloadMonitoredServices "NODE1"

Dx-RelocateSystemDatabases

Relocate system databases to a new location.

Syntax

Dx-RelocateSystemDatabases [-InstanceName] <string> -Datapath <string> -Logpath <string> [-Msdb] [-Tempdb] [-Model] [<CommonParameters>]

Detailed Description

This cmdlet relocates the master, msdb, model, and tempdb database to a new location.

Parameters

Name	Type	Description	Required	Command-line Input
InstanceName	String	The target instance to be relocated. Valid format is <Vhost><InstanceName>.	True	True
DataPath	String	New location for Data.	True	True
LogPath	String	New location for Logs.	True	True
Msdb	Switch Parameter	Whether or not to relocate msdb database.	False	False
Tempdb	Switch Parameter	Whether or not to relocate tempdb database.	False	False
Model	Switch Parameter	Whether or not to relocate model database.	False	False

Examples

Dx-RelocateSystemDatabases "VHOST1\CUSTOMER" "D:\Sqldata\CUSTOMER\Data" "D:\Sqldata\CUSTOMER\Logs"

Dx-RemoveAGS

Remove an availability group from a Vhost.

Syntax

Dx-RemoveAGS [-VhostName] <string> [-AGSName] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes an availability group from an existing Vhost. This cmdlet also removes the availability group from the SQL Server configuration.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True

Examples

Dx-RemoveAGS "Vhost1" "AGS1"

Dx-RemoveAGSDatabases

Remove a database from an availability group.

Syntax

Dx-RemoveAGSDatabases [-VhostName] <string> [-AGSName] <string> -Databases <string> [<CommonParameters>]

Detailed Description

This cmdlet removes databases from an existing availability group.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True
Databases	String	Comma delimited list of database names.	True	True

Examples

Dx-RemoveAGSDatabases "Vhost1" "AGS1" "db1,db2,db3"

Dx-RemoveAGSListener

Remove a listener port from an availability group.

Syntax

Dx-RemoveAGSListener [-VhostName] <string> [-AGSName] <string> [<CommonParameters>]

Detailed Description

This cmdlet remove the TCP listener port from an availability group.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True

Examples

Dx-RemoveAGSListener "Vhost1" "AGS1"

Dx-RemoveClusterMember

Remove a cluster member.

Syntax

Dx-RemoveClusterMember [-ServerName] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes a member from the cluster.

Parameters

Name	Type	Description	Required	Command-line Input
ServerName	String	The target node to be removed from the cluster.	True	True

Examples

Dx-RemoveClusterMember "NODE1"

Dx-RemoveContact

Remove a contact from address book.

Syntax

Dx-RemoveContact [-Name] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes a contact from the address book.

Parameters

Name	Type	Description	Required	Command-line Input
Name	String	The contact to be removed from the address book.	True	True

Examples

Dx-RemoveContact "support"

Dx-RemoveDisk

Remove a disk from the cluster.

Syntax

Dx-RemoveDisk [-DiskID] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes the disk from DxEnterprise management.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID or disk label.	True	True

Examples

Dx-RemoveDisk "3caa25ce-3866-283c-1243-b48e92a6cd1d"

Dx-RemoveDocker

Remove a Docker container from a Vhost.

Syntax

Dx-RemoveDocker [-VhostName] <string> [-DockerName] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes the Docker container from the specified Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
DockerName	String	The name of the Docker container.	True	True

Examples

Dx-RemoveDocker "VHOST1" "MSSQL1"

Dx-RemoveFileshare

Remove a fileshare from the cluster.

Syntax

Dx-RemoveFileshare [-VhostName] <string> [-ShareName] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes a fileshare from a Vhost. The Windows file share will be removed on all nodes associated with the Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
ShareName	String	The name of the fileshare.	True	True

Examples

Dx-RemoveFileShare "VHOST1" "SHARE1"

Dx-RemoveGlobalSetting

Remove a global setting from the cluster.

Syntax

Dx-RemoveGlobalsetting [[-Name] <string>] [-ClusterDescription] [-IntervalProcessor] [-IntervalMemory] [-IntervalDisk] [-IntervalNetwork] [-FileSystemTimeout] [-PingTimeout] [-PathRecheckTimeout] [-VhostRetryTimeout] [-DelayStopNode] [-DelayStartNode] [-AllocatorEnabled] [-AllocatorAlerts] [-RelayBroadcast] [-PassKey] [-WitnessPath] [-WitnessUser] [-WitnessUserPassword] [-DismountTimeout] [-DockerTimeout] [-GratuitousARP] [-IntervalReservationCheck] [-IoTimeout] [-MaxProcesses] [-PathWatcher] [-PerfBroadcastEnabled] [-ScriptTimeout] [-VdsWait] [-VolumeTimeout] [-AgsTimeout] [<CommonParameters>]

Detailed Description

This cmdlet removes a user defined global setting value and resets it back to its default value.

Parameters

Name	Type	Description	Required	Command-line Input
Name	String	The target setting name to be removed.	False	False
ClusterDescription	Switch Parameter	Whether or not to remove the cluster description.	False	False
IntervalProcessor	Switch Parameter	Whether or not to reset the sampling duration in seconds that the average is calculated for CPU. When set, the system defaults back to 120 seconds.	False	False
IntervalMemory	Switch Parameter	Whether or not to reset the sampling duration in seconds that the average is calculated for Memory. When set, the system defaults back to 1 seconds.	False	False
IntervalDisk	Switch Parameter	Whether or not to reset the sampling duration in seconds that the average is calculated for Disk I/O. When set, the system defaults back to 120 seconds.	False	False
IntervalNetwork	SwitchParameter	Whether or not to reset the sampling duration in seconds DH2i Software PowerShell Administration Guide 73 that the average is calculated for Network throughput. When set, the system defaults back to 120 seconds.	False	False
FileSystemTimeout	Switch Parameter	Whether or not to reset the timeout in seconds that the system waits for filesystem accessibility before taking actions. When set, the system defaults back to 120 seconds.	False	False
PingTimeout	Switch Parameter	Whether or not reset the timeout in seconds that the system waits for ping to complete before taking actions. When set, the system defaults back to 9 seconds.	False	False
PathRecheckTimeout	Switch Parameter	Whether or not to reset the number of seconds between the system attempts to check the inaccessible application paths. When set, the system defaults back to 120 seconds.	False	False
VhostRetryTimeout	Switch Parameter	Whether or not to reset the number of seconds between the system retries to start a Vhost after the last start-node failure. When set, the system defaults back to 120 seconds.	False	False
DelayStopNode	Switch Parameter	Whether or not to reset the short delay in seconds that the system waits after stop-node operation to avoid duplicate IP address. When set, the system defaults back to 2 seconds.	False	False
DelayStartNode	Switch Parameter	Whether or not to reset the short delay in seconds that the system waits after add-ip operation. When set, the system defaults back to 4 seconds.	False	False
AllocatorEnabled	Switch Parameter	Whether or not to enable Allocation policies. Default is true.	False	False
AllocatorAlerts	Switch Parameter	Whether or not to raise alerts for Allocation policies. Default is true.	False	False
RelayBroadcast	Switch Parameter	Whether or not to support relay broadcast messages. Default is true.	False	False
Passkey	Switch Parameter	Whether or not to reset the passkey value. When set, the system clears and sets the current passkey for the cluster as empty. If a passkey is changed when one or more cluster nodes are unavailable or temporarily down, those nodes will be unable to join the cluster when they become available.	False	False
WitnessPath	Switch Parameter	Whether or not to reset the network share paths for Witness. When set, the system clears all path values.	False	False
WitnessUser	Switch Parameter	Whether or not to reset the User name for the Witness. When set, the system clears the credential.	False	False
WitnessUserPasswrod	Switch Parameter	Whether or not to reset the Password for the Witness. When set, the system clears the credential password.	False	False
DismountTimeout	Switch Parameter	Whether or not to reset timeout in seconds that the system waits for file handles to be closed on a volume before performing a forced dismount. When set, the system defaults back to 15 seconds.	False	False
DockerTimeout	Switch Parameter	Whether or not to reset the timeout in seconds that the system waits for a Docker container to return the running state when adding a container to a Vhost. When set, the system defaults back to 5 seconds.	False	False
GratuitousARP	Switch Parameter	Whether or not to enable sending gratuitous ARP. Default is false.	False	False
IntervalReservationCheck	Switch Parameter	Whether or not to reset the sampling duration in seconds that the system rechecks the reservation. When set, the system defaults back to 5 seconds.	False	False
IOTimeout	Switch Parameter	Whether or not to reset the timeout in seconds that the system waits for I/O API call to complete. When set, the system defaults back to 15 seconds.	False	False
MaxProcesses	Switch Parameter	Whether or not to reset the number of processes the system allows to be worked on in parallel. When set, the system defaults back to 10.	False	False
PathWatcher	Switch Parameter	Whether or not to enable Pathwatcher. Default is true.	False	False
PerfBroadcastEnabled	Switch Parameter	Whether or not to enable performance statistics broadcast. True via UDP. False via TCP. Default is false.	False	False
ScriptTimeout	Switch Parameter	Whether or not to reset the timeout in seconds that the system waits for a pre/post script to complete before taking actions. When set, the system defaults back to 300 seconds.	False	False
VdsWait	Switch Parameter	Whether or not to reset the timeout in seconds that the system will wait for a PnPenumerated disk or volume to be noticed by VDS and reported. When set, the system defaults back to 15 seconds.	False	False
VolumeTimeout	Switch Parameter	Whether or not to reset the timeout in seconds that the system waits for a volume PnP device to appear after setting a disk to the online state. When set, the system defaults back to 15 seconds.	False	False
AgsTimeout	Switch Parameter	The timeout in seconds that the system waits for an availability group to finish virtualizing.	False	False

Examples

Dx-RemoveGlobalSetting -InternalProcessor

Dx-RemoveInstance

Remove an instance from a Vhost.

Syntax

Dx-RemoveInstance [-InstanceName] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes a named instance of SQL Server from a Vhost. Database files and log files on the SAN are not modified or deleted by this process.

Parameters

Name	Type	Description	Required	Command-line Input
InstanceName	String	The target instance name to be removed. Valid format is <Vhost>\<InstanceName>.	True	True

Examples

Dx-RemoveInstance "VHOST1\CUSTOMER"

Dx-RemoveNode

Remove node(s) from a Vhost.

Syntax

Dx-RemoveNode [-VhostName] <string> [-Nodes] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes node(s) from a Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
Nodes	String	A set of nodes to be removed. Delimited by comma.	True	True

Examples

Dx-RemoveNode "VHOST1" "NODE1,NODE2"

Dx-RemovePolicy

Remove a policy from the cluster.

Syntax

Dx-RemovePolicy [-SYSTEM] [-PolicyID] <string> [<CommonParameters>]

Dx-RemovePolicy [-PERF] [-PolicyID] <string> [<CommonParameters>]

Dx-RemovePolicy [-ALLOC] [-PolicyID] <string> [<CommonParameters>]

Dx-RemovePolicy [-FILTER] [-PolicyID] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes a policy from the cluster.

Parameters

Name	Type	Description	Required	Command-line Input
SYSTEM	Switch Parameter	Whether or not a SYSTEM type policy.	True	True
PERF	Switch Parameter	Whether or not a PERF type policy.	True	True
ALLOC	Switch Parameter	Whether or not a ALLOC type policy.	True	True
FILTER	Switch Parameter	Whether or not a FILTER type policy.	True	True
PolicyID	String	The policy ID to be removed.	True	True

Examples

Dx-RemovePolicy -SYSTEM "NODE1"

Dx-RemovePolicy -PERF "CPU_CUSTOMER_80PC"

Dx-RemovePolicy -ALLOC "2D2E01D6-D912-4887-BAC0-9622CB1BE71E"

Dx-RemovePolicy -FILTER "D338E9DB-BA30-49C4-8A93-7C12AA1FC26A"

Dx-RemoveScript

Remove a script from an instance or Vhost.

Syntax

Dx-RemoveScript [-Name] <string> [-ScriptName] {PreStart | PostStart | PreStop | PostStop} [-InstanceScriptType] [-VhostScriptType] [<CommonParameters>]

Detailed Description

This cmdlet removes a PreStart, PostStart, PreStop or PostStop script from a SQL Server instance or Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
Name	String	The target Vhost name or instance name. Valid values are <vhost>, <vhost>\<instance>, <docker> and <service>.	True	True
ScriptName	String	Specifies whether it is a PreStart, PostStart, PreStop or PostStop script.	True	True
InstanceScriptType	Switch Parameter	Whether or not the script is False at the Instance level. Default is true.	False	False
VhostScriptType	Switch Parameter	Whether or not the script is False at the Vhost level. Default is true.	False	False

Examples

Dx-RemoveScript "VHOST1" "PreStart" --VhostScriptType

Dx-RemoveService

Remove a service from a Vhost.

Syntax

Dx-RemoveService [-VhostName] <string> [-ServiceName] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes a service from a Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
ServiceName	String	The name of the service.	True	True

Examples

Dx-RemoveService "VHOST1" "ALG"

Dx-RemoveSMTP

Remove a SMTP configuration from the cluster.

Syntax

Dx-RemoveSMTP [-ServerName] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes the SMTP configuration from the cluster.

Parameters

Name	Type	Description	Required	Command-line Input
ServerName	String	The target server name to be removed.	True	True

Examples

Dx-RemoveSMTP "smtp.dh2i.com"

Dx-RemoveVhost

Remove a Vhost.

Syntax

Dx-RemoveVhost [-VhostName] <string> [<CommonParameters>]

Detailed Description

This cmdlet removes a Vhost from the cluster configuration.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True

Examples

Dx-RemoveVhost "VHOST1"

Dx-RemoveWitness

Remove the current cluster witness settings.

Syntax

Dx-RemoveWitness

Detailed Description

This cmdlet removes the current witness settings for the cluster.

Parameters

None

Examples

Dx-RemoveWitness

Dx-RescanDisk

Rescan disk properties.

Syntax

Dx-RescanDisk [[-DiskID] <string>] [<CommonParameters>]

Detailed Description

This cmdlet instructs the cluster to re-evaluate disk layout signature for all disks or a specific disk.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID DIsk ID(s) or disk label(s). Delimited by pipe (|).	False	True

Examples

Dx-RescanDisk "3caa25ce-3866-283c-1243-b48e92a6cd1d"

Dx-RestartGroupCommunicationEx

Restart cluster group communication.

Syntax

Dx-RestartGroupCommunicationEx [<CommonParameters>]

Detailed Description

This cmdlet restarts cluster group communications. This is an internal cmdlet to force the cluster to re-establish cluster member communication channels.

Examples

Dx-RestartGroupCommunicationEx

Dx-ResyncAGSSecondary

Resynchronizes a secondary replica in the availability group.

Syntax

Dx-ResyncAGSSecondary [-VhostName] <string> [-AGSName] <string> -NodeName <string> [<CommonParameters>]

Detailed Description

This cmdlet resynchronizes a secondary replica in the availability group to ensure that the node configuration is set as a secondary role.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True
NodeName	String	The name of the node.	True	True

Examples

Dx-ResyncAGSSecondary "VHOST1" "AGS1" "NODE2"

Dx-SetAGSCred

Set the credentials for an availability group replica.

Syntax

Dx-SetAGSCred [-VhostName] <string> [-AGSName] <string> -AGSParams <node_name|instance_name|sql_login|sql_pass|mirror_port|availability_mode|[tunnel_port]> [<CommonParameters>]

Detailed Description

This cmdlet assigns the credentials to use for a specific availability group replica.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AGSName	String	The name of the availability group.	True	True
AGSParams	String	Comma delimited parameter sets for the availability group replica: <node_name|instance_name|sql_login|sql_pass|mirror_port|availability_mode|[tunnel_port]>.	True	True

Examples

Dx-SetAGSCred "Vhost1" "AGS1" "node1|instance1|sa|Pa$$word|5022|synchronous_commit"

Dx-SetAppCoordinator

Set a cluster member node to be the new application coordinator.

Syntax

Dx-SetAppCoordinator [-Name] <string> [<CommonParameters>]

Detailed Description

This cmdlet assigns application coordinator role to a cluster member node.

Parameters

Name	Type	Description	Required	Command-line Input
Name	String	The target node name to be the new application coordinator.	True	True

Examples

Dx-SetAppCoordinator "NODE1"

Dx-SetClusterID

Set a new cluster ID.

Syntax

Dx-SetClusterID [[-NewGUID] <string>] [<CommonParameters>]

Detailed Description

This cmdlet assigns a new cluster ID.

Parameters

Name	Type	Description	Required	Command-line Input
Name	String	The new GUID to be used as the cluster ID. Default is system generated.	False	True

Examples

Dx-SetClusterID "A66E9911-8F30-400C-9A48-FE543E129E68"

Dx-SetCoordinator

Set a cluster member node to be the new cluster coordinator.

Syntax

Dx-SetCoordinator [-Name] <string> [<CommonParameters>]

Detailed Description

This cmdlet assigns cluster coordinator role to a cluster member node.

Parameters

Name	Type	Description	Required	Command-line Input
Name	String	The target node name to be the new cluster coordinator.	True	True

Examples

Dx-SetCoordinator "NODE1"

Dx-SetDepends

Defines the startup order of services in a list of dependencies.

Syntax

Dx-SetDepends [-VhostName] <string> [-AppName] <string> [-DependsList] <string> [<CommonParameters>]

Detailed Description

This cmdlet defines the startup order of services in a list of dependencies. When an instance or service is depending on another instances or services, it would not start up until the depended on instances or services start up first. If a circular reference is set for the dependencies (i.e. instance1 depends on service1, and service1 depends on instance1), the system will break the dependency tree and revert back to default behavior as if there is not a dependency set.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AppName	String	The application type followed by a colon (:) and the name of the application. Valid types are SQL, SVC, VFS and DCK.	True	True
DependsList	String	A comma (,) delimited list of services in startup order, or an empty string to clear.	True	True

Examples

Dx-SetDepends "VHOST1" "SQLBrowser" "SQL:INSTANCE1"

Dx-SetDiskLabel

Update the disk label.

Syntax

Dx-SetDiskLabel [-DiskID] <string> [-Label] <string> [<CommonParameters>]

Detailed Description

This cmdlet updates the disk label.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID or disk label	True	True
Label	String	The new label name	True	True

Examples

Dx-SetDiskLabel "3caa25ce-3866-283c-1243-b48e92a6cd1d" "Dx Cluster Disk 1"

Dx-SetDockerDescription

Update the Docker container description.

Syntax

Dx-SetDockerDescription [-DockerName] <string> [[-Description] <string>] [<CommonParameters>]

Detailed Description

This cmdlet updates the description of a Docker container.

Parameters

Name	Type	Description	Required	Command-line Input
DockerName	String	The name of the container.	True	True
Description	String	User defined description.	False	False

Examples

Dx-SetDockerDescription "MSSQL1" "SQL Server Container"

Dx-SetFailback

Set failback option for a Vhost.

Syntax

Dx-SetFailback [-VhostName] <string> -AutoFailback [<CommonParameters>]

Detailed Description

This cmdlet enables or disables autofailback for a Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
AutoFailback	Switch Parameter	Enable or disable autofailback for the Vhost.	True	True

Examples

Dx-SetFailback "VHOST1" $true

Dx-SetGlobalSetting

Set global setting value(s).

Syntax

Dx-SetGlobalsetting [-AllocatorEnabled <bool>] [-AllocatorAlerts] [-RelayBroadcast] [-Name <string>] [-Value <string>] [-ClusterDescription <string>] [-IntervalProcessor <int>] [-IntervalMemory <int>] [-IntervalDisk <int>] [-IntervalNetwork <int>] [-FileSystemTimeout <int>] [-PingTimeout <int>] [-PathRecheckTimeout <int>] [-VhostRetryTimeout <int>] [-DelayStopNode <int>] [-DelayStartNode <int>] [-PassKey <string>] [-WitnessPath <string>] [-WitnessUser <string>] [-WitnessUserPassword <string>] [-DismountTimeout <int>] [-DockerTimeout <int>] [-GratuitousARP] [-IntervalReservationCheck <int>] [-IoTimeout <int>] [-MaxProcesses <int>] [-PathWatcher] [-PerfBroadcastEnabled] [-ScriptTimeout <int>] [-VdsWait <int>] [-VolumeTimeout <int>] [-AgsTimeout] [<CommonParameters>]

Detailed Description

This cmdlet sets global setting values for the cluster.

Parameters

Name	Type	Description	Required	Command-line Input
AgsTimeout	Integer	The timeout in seconds that the system waits for an availability group to finish virtualizing.	False	False
AllocatorAlerts	Switch Parameter	Whether or not to raise alerts for allocation policies.	False	False
AllocatorEnabled	Bool	Whether or not to enable allocation policies.	False	False
ClusterDescription	String	The cluster description to be set.	False	False
DelayStartNode	Integer	The short delay in seconds that the system waits after add-ip operation.	False	False
DelayStopNode	Integer	The short delay in seconds that the system waits after stop-node operation to avoid duplicate IP address.	False	False
DismountTimeout	Integer	The timeout in seconds that the system waits for file handles to be closed on a volume before performing a forced dismount.	False	False
DockerTimeout	Integer	The timeout in seconds that the system waits for a Docker container to return the running state when adding a container to a Vhost.	False	False
FileSystemTimeout	Integer	The timeout in seconds that the system waits for filesystem accessibility before taking actions.	False	False
GratuitousARP	Switch Parameter	Enable or Disable sending gratuitous ARP.	False	False
IntervalDisk	Integer	The sampling duration in seconds that the average is calculated for Disk I/O.	False	False
IntervalMemory	Integer	The sampling duration in seconds that the average is calculated for Memory.	False	False
IntervalNetwork	Integer	The sampling duration in seconds that the average is calculated for Network throughput.	False	False
IntervalProcessor	Integer	The sampling duration in seconds that the average is calculated for CPU.	False	False
IntervalReservationCheck	Integer	The sampling duration in seconds that the system rechecks the reservation.	False	False
IoTimeout	Integer	The timeout in seconds that the system waits for I/O API call to complete.	False	False
MaxProcesses	Integer	The number of processes the system allows to be worked on in parallel.	False	False
Name	String	The target setting name to set. Internal use.	False	False
Passkey	String	The passkey value. Setting a passkey enables encryption of network data and prevents nodes from joining the cluster that do not have the same passkey configured. If an empty passkey is set, the passkey is removed. If a passkey is set when one or more cluster nodes are unavailable or temporarily down, those nodes will be unable to join the cluster when they become available.	False	False
PathRecheckTimeout	Integer	The number of seconds between the system attemps to check the inaccessible application paths.	False	False
PathWatcher	Switch Parameter	Enable or Disable Pathwatcher.	False	False
PerfBroadcastEnabled	Switch Parameter	Enable or Disable performance statistics broadcast. True via UDP. False via TCP.	False	False
PingTimeout	Integer	The timeout in seconds that the system waits for ping to complete before taking actions.	False	False
RelayBroadcast	Switch Parameter	Whether or not to support relay broadcast messages.	False	False
ScriptTimeout	Integer	The timeout in seconds that the system waits for a pre/post script to complete before taking actions.	False	False
Value	String	The target value for the Name setting. Internal use.	False	False
VdsWait	Integer	The timeout in seconds that the system will wait for a PnP-enumerated disk or volume to be noticed by VDS and reported.	False	False
VhostRetryTimeout	Integer	The number of seconds between the system retries to start a Vhost after the last start-node failure.	False	False
VolumeTimeout	Integer	The timeout in seconds that the system waits for a volume PnP device to appear after setting a disk to the online state.	False	False
WitnessPath	String	The network share paths for Witness. Delimited by comma.	False	False
WitnessUser	String	The User name to access the witness share paths.	False	False
WitnessUserPassword	String	The Password to access the witness share paths.	False	False

Examples

Dx-SetGlobalSetting -ClusterDescription "Dx Cluster 1"

Dx-SetInstanceDescription

Set a description for an instance.

Syntax

Dx-SetInstanceDescription [-InstanceName] <string> [[-Description] <string>] [<CommonParameters>]

Detailed Description

This cmdlet sets a description for an instance of SQL Server.

Parameters

Name	Type	Description	Required	Command-line Input
InstanceName	String	The instance name. Valid value is <Vhost>\<InstanceName>.	True	True
Description	String	User defined description.	False	False

Examples

Dx-SetInstanceDescription "VHOST1\CUSTOMER" "Customer Instance"

Dx-SetLicense

Activate a node.

Syntax

Dx-SetLicense [-LicenseCode] <string> [[-NodeName] <string>] [<CommonParameters>]

Dx-SetLicense [-LicenseCode] <string> [[-NodeName] <string>] -Manual -Answer <string> [<CommonParameters>]

Detailed Description

This cmdlet activates the node with a license code either automatically if the node is connected to the internet or manually if the node is not connected to the internet.

Parameters

Name	Type	Description	Required	Command-line Input
LicenseCode	String	The assigned license code to be used to activate the node.	True	True
NodeName	String	The target node name to be activated. Default is localhost if not specified.	False	True
Manual	Switch Parameter	Whether or not a manual activation. If set, the Answer must be provided.	False	False
Answer	String	The Answer value obtained from DH2i DH2i Client Portal when the target node is not connected to the internet.	False	False

Examples

Dx-SetLicense "AAAA-BBBB-CCCC-DDDD" "NODE1"

Dx-SetMountpoint

Mount a volume to a mountpoint.

Syntax

Dx-SetMountpoint [-VolID] <string> [[-MountPath] <string>] [<CommonParameters>]

Detailed Description

This cmdlet defines the mountpoint(s) for a volume.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID.	True	True
MountPath	String	The path(s) to mount the volume delimited by comma (,).	False	False

Examples

Dx-SetMountpoint "3caa25ce-3866-283c-1243-b48e92a6cd1d" "C:\MountPoint1"

Dx-SetOTPK

Set a one-time passkey.

Syntax

Dx-SetOTPK [-TTL] <datetime> [-Force] [<CommonParameters>]

Detailed Description

This cmdlet sets a one-time passkey for the cluster to be used for joining nodes together via the DH2i Matchmaking Service over NAT.

Parameters

Name	Type	Description	Required	Command-line Input
TTL	DateTime	The time to live for the OTPK in universal time code.	False	True
Force	Boolean	Allows the override of an existing OTPK.	False	True

Examples

Dx-SetOTPK

Dx-SetScript

Configure a script for an instance or Vhost.

Syntax

Dx-SetScript [-Name] <string> [-ScriptName] {PreStart | PostStart | PreStop | PostStop} [-FileName] <string> [-InstanceScriptType] [-VhostScriptType] [<CommonParameters>]

Detailed Description

This cmdlet sets a PreStart, PostStart, PreStop or Poststop script for an instance of SQL Server or a Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
Name	String	The target Vhost name or instance name. Valid value is <Vhost> or <Vhost>\<InstanceName>.	True	True
ScriptName	String	Whether it is a PreStart, PostStart, PreStop, or PostStop script.	True	True
FileName	String	The full path to the script file. The script must be located at a path accessible on all nodes.	True	True
InstanceScriptType	Switch Parameter	Whether or not the script is at the Instance level. Default is true.	False	False
VhostScriptType	Switch Parameter	Whether or not the script os at the Vhost level. Default is false.	False	False

Examples

Dx-SetScript "VHOST1" "PreStart" "C:\utility\get_processes.cmd" -VhostScriptType

Dx-SetScriptEmbedded

Configure an embedded script for an instance or Vhost.

Syntax

Dx-SetScriptEmbedded [-Name] <string> [-ScriptName] {PreStart | PostStart | PreStop | PostStop} [-ScriptContent] <string> [-ScriptExtension] <string> [-InstanceScriptType] [-VhostScriptType] [<CommonParameters>]

Detailed Description

This cmdlet sets an embedded PreStart, PostStart, PreStop or PostStop script for an instance of SQL Server or a Vhost. The advantage of having an embedded script is that it is part of the cluster configuration and is always available to the cluster member nodes.

Parameters

Name	Type	Description	Required	Command-line Input
Name	String	The target Vhost name or instance name. Valid value is <Vhost> or <Vhost>\<InstanceName>.	True	True
ScriptName	String	Whether it is a PreStart, PostStart, PreStop, or PostStop script.	True	True
ScriptContent	String	The script content to be embedded into the cluster configuration.	True	True
ScriptExtension	String	The file extenstion. E.g. CMD, BAT, PS1.	True	True
InstanceScriptType	Switch Parameter	Whether or not the script is at the Instance level. Default is true.	False	False
VhostScriptType	Switch Parameter	Whether or not the script is at the Vhost level. Default is false.	False	False

Examples

Dx-SetScriptEmbedded "VHOST1" "PreStart" "echo %computername%" "CMD" -VhostScriptType

Dx-SetSecret

Set a passkey for the cluster.

Syntax

Dx-SetSecret [[-Passkey] <string>] [<CommonParameters>]

Detailed Description

This cmdlet sets a passkey. Setting a passkey enables encryption of network data and prevents nodes from joining the cluster that do not have the same passkey configured. If an empty passkey is set, the passkey is removed. If a passkey is set when one or more cluster nodes are unavailable or temporarily down, those nodes will be unable to join the cluster when they become available.

Parameters

Name	Type	Description	Required	Command-line Input
Passkey	String	The passkey value.	True	True

Examples

Dx-SetSecret "Pa$$word"

Dx-SetServer

Define connecting server info.

Syntax

Dx-SetServer [-EncryptedPasskey] [-UseTLS] [-Server <string>] [-Passkey <string>] [-TCPPort <int>] [-Force] [<CommonParameters>]

Detailed Description

This cmdlet defines the connection info for the Powershell session.

Parameters

Name	Type	Description	Required	Command-line Input
EncryptedPasskey	Switch Parameter	Whether or not the supplied passkey value is an encrypted string obtained from Dx-EncryptText cmdlet. Default is false.	False	False
UseTLS	Switch Parameter	Enables TLS communication to authenticate by certificate.	False	False
Server	String	The target node name to connect to. Default is localhost.	False	False
Passkey	String	The passkey to be used to connect to the target server. Default is empty.	False	False
TCPPort	Integer	The connecting TCP port of the target server. Default is 7979.	False	False
Force	Switch Parameter	Required if the passkey parameter is used.	False	False

Examples

Dx-SetServer -Server "NODE1"

Dx-SetStorCoordinator

Set a cluster member node to be the new storage coordinator.

Syntax

Dx-SetStorCoordinator [-NodeName] <string> [<CommonParameters>]

Detailed Description

This cmdlet assigns the storage coordinator role to a cluster member node.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The target node name to be the new storage coordinator.	True	True

Examples

Dx-SetStorCoordinator "NODE1"

Dx-SetVhostPriority

Set priority for a Vhost.

Syntax

Dx-SetVhostPriority [-VhostName] <string> [-Priority] <int> [<CommonParameters>]

Detailed Description

This cmdlet sets a priority value for a Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
Priority	Integer	Vhost priority relative to other Vhosts in the cluster. Valid values are between 1 and 5. With 1 being the lowest or least prioritized.	True	True

Examples

Set-VhostPriority "VHOST1" 3

Dx-SetVolumeLabel

Set a new label for the specified volume.

Syntax

Dx-SetVolumeLabel [-VolID] <string> [-VolumeLabel] <string> [<CommonParameters>]

Detailed Description

This cmdlet renames the specified volume with the new label.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID.	True	True
VolumeLabel	String	The new label of the volume.	True	True

Examples

Dx-SetVolumeLabel "3caa25ce-3866-283c-1243-b48e92a6cd1d" "Cluster Volume 1"

Dx-SetWitness

Sets witness settings for the cluster.

Syntax

Dx-SetWitness [-Witnesses <string[]>] [<CommonParameters>]

Detailed Description

This cmdlet sets witness settings for the cluster. This cmdlet supercedes Dx-AddWitness in that it supports both UNC network share and Azure Blob Storage cloud witness.

Parameters

Name	Type	Description	Required	Command-line Input
Witnesses	String	The witness settings in the format of <witness_path>|<username>|<password> for UNC shares. Prefix with az: for Azure Blob Storage connection string or SAS URL. No parameter specified is equivalent to RemoveWitness.	False	True

Examples

Local File Share

Dx-SetWitness "\server1\myshare1|user1|6pnFaDrRS+W/F+dkRuPKAA=="

Cloud File Share

Dx-SetWitness "\\mystorage.file.core.windows.net\azshare1|mystorage|/nbFVz1fOKH7b0RaY/5Ms8uytbY99PZsspZkcHvNtVRj//pUk4jUPV7owaUSuDd6eExv96sBvkCXsleATEsT33=="

Azure Blob Storage via Access Key

Dx-SetWitness "az:DefaultEndpointsProtocol=https;AccountName=mystorage;AccountKey=/nbFVz1fOKH7b0RaY/5Ms8uytbY99PZsspZkcHvNtVRj//pUk4jUPV7owaUSuDd6eExv96sBvkCXsleATEsT33==;EndpointSuffix=core.windows.net"

Azure Blob Storage via SAS URL

Dx-SetWitness "az:https://mystorage.blob.core.windows.net/?sv=2020-02-10&ss=b&srt=sco&sp=rwdlactfx&se=2021-06-09T13:15:48Z&st=2021-06-09T05:15:48Z&spr=https&sig=cRDqOc25lpHfbP8X1hlkDnV4H1wJycCyuuqlgu8U1xg%3D"

Mixed File Shares

Dx-SetWitness "\server1\myshare1|user1|6pnFaDrRS+W/F+dkRuPKAA=="
"\mystorage.file.core.windows.net\azshare1|mystorage|/nbFVz1fOKH7b0RaY/5Ms8uytbY99PZsspZkcHvNtVRj//pUk4jUPV7owaUSuDd6eExv96sBvkCXsleATEsT33=="
"az:DefaultEndpointsProtocol=https;AccountName=mystorage;AccountKey=/nbFVz1fOKH7b0RaY/5Ms8uytbY99PZsspZkcHvNtVRj//pUk4jUPV7owaUSuDd6eExv96sBvkCXsleATEsT33==;EndpointSuffix=core.windows.net"

Dx-ShrinkVolume

Shrink the volume size.

Syntax

Dx-ShrinkVolume [-VolID] <string> [-ToShrinkBy] <string> [<CommonParameters>]

Detailed Description

This cmdlet shrinks the volume by the 'ToShrinkBy' size.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID.	True	True
ToShrinkBy	String	The size in bytes in which to shrink the volume by.	True	True

Examples

Dx-ShrinkVolume "3caa25ce-3866-283c-1243-b48e92a6cd1d" "1048576"

Dx-StartDisk

Bring a disk online on a node.

Syntax

Dx-StartDisk [-DiskID] <string> [-NodeName] <string> [<CommonParameters>]

Detailed Description

This cmdlet brings a disk online on a node. If the disk is online previously, the cluster will set if offline on that node prior to bringing it online on the specified node.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID or disk label.	True	True
NodeName	String	The name of the node to start the specified disk.	True	True

Examples

Dx-StartDisk "3caa25ce-3866-283c-1243-b48e92a6cd1d" "NODE1"

Dx-StartDiskAssociates

Starts a disk and all associated disks.

Syntax

Dx-StartDiskAssociates [-DiskID] <string> [-NodeName] <string> [<CommonParameters>]

Detailed Description

This cmdlet starts a disk on the specified node. If the disk is part of a volume set, the system will start all associated disks as well.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID or disk label.	True	True
NodeName	String	The name of the node to start the specified disk.	True	True

Examples

Dx-StartDiskAssociates "3caa25ce-3866-283c-1243-b48e92a6cd1d" "NODE1"

Dx-StartDiskGroup

Administratively bring disk group(s) online on a specified node of a Vhost.

Syntax

Dx-StartDiskGroup [-VhostName] <string> [-NodeName] <string> [<CommonParameters>]

Detailed Description

This cmdlet administratively brings diskgroup(s) online on a specified node of a Vhost. Applications running on the previous node may be affected when the diskgroup(s) become offline/unavailable on the previous node.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID or disk label.	True	True
NodeName	String	The name of the node to start the specified disk.	True	True

Examples

Dx- StartDiskGroup "VHOST1" "NODE1"

Dx-StartDocker

Start a Docker container on a Vhost.

Syntax

Dx-StartDocker [-VhostName] <string> [-DockerName] <string> [<CommonParameters>]

Detailed Description

This cmdlet starts a Vhost and all associated Docker containers on a specific node.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
DockerName	String	The name of the container.	True	True

Examples

Dx-StartService "VHOST1" "MSSQL1"

Dx-StartInstance

Start an instance of SQL Server.

Syntax

Dx-StartInstance [-InstanceName] <string> [<CommonParameters>]

Detailed Description

This cmdlet starts a named instance of SQL Server. The instance will be started on whichever node is currently hosting the instance's Vhost. If the instance is administratively disabled, it will be enabled.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID or disk label.	True	True
InstanceName	String	The target instance name. Valid value is <Vhost>\<InstanceName>.	True	True

Examples

Dx-StartInstance "VHOST1\CUSTOMER"

Dx-StartService

Start a service on a Vhost.

Syntax

Dx-StartService [-VhostName] <string> [-ServiceName] <string> [<CommonParameters>]

Detailed Description

This cmdlet starts a Vhost and all associated services on a specific node.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
ServiceName	String	The name of the service.	True	True

Examples

Dx-StartService "VHOST1" "ALG"

Dx-StartVolume

Start volume on a node.

Syntax

Dx-StartVolume [-VolID] <string> [-NodeName] <string> [<CommonParameters>]

Detailed Description

This cmdlet starts a volume on a specific node.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID.	True	True
NodeName	String	The name of the node.	True	True

Examples

Dx-StartVolume "3caa25ce-3866-283c-1243-b48e92a6cd1d" "NODE1"

Dx-StopDisk

Take a disk offline.

Syntax

Dx-StopDisk [-DiskID] <string> [<CommonParameters>]

Detailed Description

This cmdlet takes a disk offline.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID or disk label of the disks to take offline.	True	True

Examples

Dx-StopDisk "3caa25ce-3866-283c-1243-b48e92a6cd1d"

Dx-StopDiskAssociates

Take a disk and all associated disks offline.

Syntax

Dx-StopDiskAssociates [-DiskID] <string> [<CommonParameters>]

Detailed Description

This cmdlet takes a disk offline. If the disk is part of a volume set, the system will take all associated disks, as part of the volume, offline also.

Parameters

Name	Type	Description	Required	Command-line Input
DiskID	String	The GUID Disk ID or disk label of the disk to take offline.	True	True

Examples

Dx-StopDiskAssociates "3caa25ce-3866-283c-1243-b48e92a6cd1d"

Dx-StopDiskGroup

Administratively take a Vhosts' diskgroup offline.

Syntax

Dx-StopDiskGroup [-VhostName] <string> [<CommonParameters>]

Detailed Description

This cmdlet administratively takes a Vhost's diskgroup offline. Applications that depend on the diskgroup may be affected when the diskgroup goes offline.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True

Examples

Dx-StopDiskGroup "VHOST1"

Dx-StopDocker

Stop an instance of a Docker container.

Syntax

Dx-StopDocker [-VhostName] <string> [-DockerName] <string> [[-IsDisabled] <bool>] [<CommonParameters>]

Detailed Description

This cmdlet stops an instance of a Docker container and marks the instance as administratively disabled.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
DockerName	String	The name of the Docker container.	True	True
IsDisabled	Bool	Whether or not to administratively disable the Docker instance after stopping. This will prevent the instance from starting back up.	True	True

Examples

Dx-StopDocker "VHOST1" "MSSQL1"

Dx-StopInstance

Stop an instance of SQL Server.

Syntax

Dx-StopInstance [-InstanceName] <string> [-IsDisabled] <bool> [<CommonParameters>]

Detailed Description

This cmdlet stops a named instance of SQL Server and marks the instance as administratively disabled.

Parameters

Name	Type	Description	Required	Command-line Input
InstanceName	String	The target instance name. Valid value is <Vhost>\<InstanceName>.	True	True
IsDisabled	Bool	Whether or not to administratively disable the Docker instance after stopping. This will prevent the instance from starting back up.	True	True

Examples

Dx-StopInstance "VHOST1\CUSTOMER"

Dx-StopService

Stop a service on a Vhost.

Syntax

Dx-StopService [-VhostName] <string> [-ServiceName] <string> [[-IsDisabled] <bool>] [<CommonParameters>]

Detailed Description

This cmdlet stops a service on a Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
ServiceName	String	The name of the service.	True	True
IsDisabled	Bool	Whether or not to administratively disable the Docker instance after stopping. This will prevent the instance from starting back up.	True	True

Examples

Dx-StopService "VHOST1" "ALG"

Dx-StopVolume

Stop a running volume.

Syntax

Dx-StopVolume [-VolID] <string> [<CommonParameters>]

Detailed Description

This cmdlet stops a specified volume.

Parameters

Name	Type	Description	Required	Command-line Input
VolID	String	The GUID Volume ID of the volume to stop.	True	True

Examples

Dx-StopVolume "dad325ce-3866-283c-1243-b48e92a6cd1d"

Dx-TestWitness

Test witness network share(s).

LEGACY

This command has been superseded by Dx-TestWitnessEx. Do not use this command for Azure Blob Storage.

Syntax

Dx-TestWitness [-Shares] <string> [-UserName] <string> [-Password] <string> [-EncryptedPassword] [<CommonParameters>]

Detailed Description

This cmdlet tests the availability and authentication to the witness network share(s).

Parameters

Name	Type	Description	Required	Command-line Input
Shares	String	The share path(s).	True	True
UserName	String	The user name to access the witness share paths(s).	True	True
Password	String	The Password to access the witness share path(s).	True	True
EncryptedPassword	Switch Parameter	Whether or not the supplied password value is an encrypted string obtained from Dx-EncryptText cmdlet. Default is false.	False	False

Examples

Dx-TestWitness "\\SERVER1\Witness1" "ShareAdmin" "Pa$$word"

Dx-TestWitnessEx

Test network share(s) or Azure Blob Storage witness. This cmdlet supercedes Dx-TestWitness.

Syntax

Dx-TestWitnessEx [-Witnesses] <string[]> [<CommonParameters>]

Detailed Description

This cmdlet tests the availability and authentication to the witness network share(s) and Azure Blob Storage.

Parameters

Name	Type	Description	Required	Command-line Input
Witnesses	String	The witness settings in the format of <witness_path>|<username>|<password> for UNC file shares. Prefix with az: for Azure Blob Storage connection string or SAS URL.	True	True

Examples

Local File Share

Dx-TestWitnessEx "\server1\myshare1|user1|6pnFaDrRS+W/F+dkRuPKAA=="

Cloud File Share

Dx- TestWitnessEx
"\mystorage.file.core.windows.net\azshare1|mystorage|/nbFVz1fOKH7b0RaY/5Ms8uytbY99PZsspZkcHvNtVRj//pUk4jUPV7owaUSuDd6eExv96sBvkCXsleATEsT33=="

Azure Blog Storage via Access Key

Dx- TestWitnessEx
"az:DefaultEndpointsProtocol=https;AccountName=mystorage;AccountKey=/nbFVz1fOKH7b0RaY/5Ms8uytbY99PZsspZkcHvNtVRj//pUk4jUPV7owaUSuDd6eExv96sBvkCXsleATEsT33==;EndpointSuffix=core.windows.net"

Azure Blog Storage via SAS URL

Dx- TestWitnessEx
"az:https://mystorage.blob.core.windows.net/?sv=2020-02-10&ss=b&srt=o&sp=rwdlactfx&se=2021-06-09T13:15:48Z&st=2021-06-09T05:15:48Z&spr=https&sig=cRDqOc25lpHfbP8X1hlkDnV4H1wJycCyuuqlgu8U1xg%3D"

Mixed File Shares

Dx- TestWitnessEx
"\server1\myshare1|user1|6pnFaDrRS+W/F+dkRuPKAA=="
"\mystorage.file.core.windows.net\azshare1|mystorage|/nbFVz1fOKH7b0RaY/5Ms8uytbY99PZsspZkcHvNtVRj//pUk4jUPV7owaUSuDd6eExv96sBvkCXsleATEsT33=="
"az:DefaultEndpointsProtocol=https;AccountName=mystorage;AccountKey=/nbFVz1fOKH7b0RaY/5Ms8uytbY99PZsspZkcHvNtVRj//pUk4jUPV7owaUSuDd6eExv96sBvkCXsleATEsT33==;EndpointSuffix=core.windows.net"

Dx-UnfreezeNode

Unfreeze a cluster node.

Syntax

Dx-UnfreezeNode [-NodeName] <string> [<CommonParameters>]

Detailed Description

This cmdlet administratively takes a node out of "frozen" state and back into "active" state for all Vhosts and continue to host running applications.

This cmdlet is designed to support in-place upgrade of DxEnterprise software.

Parameters

Name	Type	Description	Required	Command-line Input
NodeName	String	The name of the node.	True	True

Examples

Dx-UnfreezeNode "NODE1"

Dx-UnfreezeVhost

Unfreeze a Vhost.

Syntax

Dx-UnfreezeVhost [-VhostName] <string> [<CommonParameters>]

Detailed Description

This cmdlet administratively takes a Vhost out of the "frozen" state and back into "active" state. Applications running on an active Vhost can now be moved around between the nodes within the Vhost.

Parameters

| VhostName | String | The name of the Vhost. | True | True |

Examples

Dx-UnfreezeVhost "VHOST1"

Dx-UpdateContact

Update the email address for a contact.

Syntax

Dx-UpdateContact [-Name] <string> [-Email] <string> [<CommonParameters>]

Detailed Description

This cmdlet updates the email address for a contact.

Parameters

Name	Type	Description	Required	Command-line Input
Name	String	The contact name.	True	True
Email	String	The new email address.	True	True

Examples

Dx-UpdateContact "support" "support@dh2i.com"

Dx-UpdateFileshare

Update a fileshare.

Syntax

Dx-UpdateFileshare [-VhostName] <string> [-ShareName] <string> -Grants <string[]> [-Comments <string>] [-MaxAllowedUsers <int>] [-Caching <string> {manual | BranchCache | documents | programs | none}] [<CommonParameters>]

Detailed Description

This cmdlet updates a fileshare. This cmdlet can be used to modify permissions, add comments, change the max users or change the caching type.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
ShareName	String	The name of the network share.	True	True
Grants	String	Grant parameter string array delimited by a comma (,). Each parameter name and value pair is delimited by a colon (:).	True	True
Comments	String	User defined comment.	False	False
MaxAllowedUsers	Integer	Max concurrent users allowed to the share. Default is unlimited.	False	False
Caching	String	Caching mode for the share. Possible mode: manual, BranchCache, documents, programs, none.	False	False

Examples

Dx-UpdateFileshare "VHOST1" "SHARE1" "Everyone:full"

Dx-UpdatePolicy

Update a policy.

Syntax

Dx-UpdatePolicy -SYSTEM -PolicyID <string> [-Enabled] [-Description <string>] [-ObjectName <string>] [-Operator <string>] [<CommonParameters>]

Dx-UpdatePolicy -PERF -PolicyID <string> [-Percent] [-Loadbalance] [-Enabled] [-Description <string>] [-ObjectName <string>] [-CounterName <string>] [-Threshold <int>] [-Operator <string>] [-ScriptPath <string>] [-Priority <int>] [<CommonParameters>]

Dx-UpdatePolicy -ALLOC -PolicyID <string> [-Enabled] [-Description <string>] [-ObjectName <string>] [-CounterName <string>] [-Threshold <int>] [-Operator <string>] [-ScriptPath <string>] [<CommonParameters>]

Dx-UpdatePolicy -FILTER -PolicyID <string> [-Enabled] [-Information] [-Warning] [-Error] [-Critical] [-VhostFilter <string>] [-InstanceFilter <string>] [-NodeFilter <string>] [-Description <string>] [-Operator <string>] [<CommonParameters>]

Detailed Description

This cmdlet updates a SYSTEM/PERF/ALLOC/FILTER policy.

Parameters

Name	Type	Description	Required	Command-line Input
SYSTEM	Switch Parameter	System type policy. Used to alert when a system is down.	True	False
PERF	Switch Parameter	Performance type policy.	True	False
ALLOC	Switch Parameter	Allocation type policy.	True	False
FILTER	Switch Parameter	Global filter alert type policy.	True	False
PolicyID	String	Unique policy ID.	False	False
Description	String	User defined description.	False	False
ObjectName	String	Instance or System name.	False	False
CounterName	String	Resource/counter name.	False	False
Threshold	Integer	Trigger limit applicable for PERF and ALLOC policies. When this threshold is met or exceeded the system will raise an alert and carry any predefined corrective actions.	False	False
Percent	Switch Parameter	Whether or not the threshold value is a percentage of the total system resource.	False	False
Operator	String	Email addresses to be sent when the policy is triggered. Delimited by comma.	False	False
ScriptPath	String	Full path to the script file to be executed when the policy is triggered.	False	False
Priority	Integer	Policy priority relative to other policies in the cluster. Valid values are between 1 and 5. With 1 being the lowest or least prioritized. Applicable to PERF policy.	False	False
LoadBalance	Switch Parameter	Whether or not to failover when the policy is triggered. Default is false.	False	False
Enabled	Switch Parameter	Whether or not the policy is enabled. Default is true.	False	False
Information	Switch Parameter	Whether or not filter only for Information severity alerts. Applicable to FILTER policy. Default is true.	False	False
Warning	Switch Parameter	Whether or not filter only for Warning severity alerts. Applicable to FILTER policy. Default is true.	False	False
Error	Switch Parameter	Whether or not filter only for Error severity alerts. Applicable to FILTER policy. Default is true.	False	False
Critical	Switch Parameter	Whether or not filter only for Critical severity alerts. Applicable to FILTER policy. Default is true.	False	False
VhostFilter	String	Inclusive list of Vhosts to raise alert for. Applicable to FILTER policy. Default is all Vhost.	False	False
InstanceFilter	String	Inclusive list of instances to raise alert for. Applicable to FILTER policy. Default is all instances.	False	False
NodeFilter	String	Inclusive list of nodes to raise alert for. Applicable to FILTER policy. Default is all nodes.	False	False

Examples

Dx-UpdatePolicy -SYSTEM -PolicyID "NODE1" -Enabled:$false

Dx-UpdatePolicy -PERF -PolicyID "51A9353D-4D59-43B4-B722-04D4517CF277"
-Enabled:$false

Dx-UpdatePolicy -ALLOC -PolicyID "8F257E80-E253-4FD7-B3CC-1715DA58A94B"
-Enabled:$false

Dx-UpdatePolicy -FILTER -PolicyID "D92BA14F-F3D2-432A-BFA8-3BDF454B7140"
-Enabled:$false

Dx-UpdateVhost

Update a Vhost.

Syntax

Dx-UpdateVhost [-VhostName] <string> [-Nodes <string>] [-AutoFailback <bool>] [-Priority <int>] [-Force] [-VIPs <string>] [<CommonParameters>]

Detailed Description

This cmdlet updates a Vhost. This cmdlet can be used to re-order the node list, set autofailback property, set priority for a Vhost and/or change the IP address assignments.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
Nodes	String	List of nodes participating in the Vhost. Delimited by comma.	True	True
AutoFailback	Bool	Whether or not to support auto failback for the Vhost. No change if not specified.	False	True
Priority	Integer	Vhost priority relative to other Vhosts in the cluster. Valid values are between 1 and 5. With 1 being the lowest or least prioritized. No change if not specified.	False	True
Force	Switch Parameter	Must be specified if the VIPS list is being modified.	False	False
VIPs	String	Virtual IP addresse(s) to be assigned to the Vhost. Comma (,) delmited.	False	False

Examples

Dx-UpdateVhost "VHOST1" "NODE2,NODE3,NODE1"

Dx-UpgradeSQL

Upgrade SQL Server instance.

Syntax

Dx-UpgradeSQL [-InstanceName] <string> [-Nodes] <string> [-ExecutingCommand] <string[]> [-CIFSUserName] <string> [-CIFSPassword] <string> [-EncryptedPassword] [<CommonParameters>]

Detailed Description

This cmdlet pushes an unattended upgrade/patch installation of SQL Server instance to specified nodes. Full command line must be provided for the service pack executable and the path to the executable must be accessible on all nodes involved. Check Microsoft website for appropriate supported unattended patch commands and syntax.

Parameters

Name	Type	Description	Required	Command-line Input
InstanceName	String	The name of the instance.	True	True
Nodes	String	A list of nodes to execute the unattended SQL Server installation. Delimited by comma.	True	True
ExecutingCommand	String	Subsequent <string> parameters after the Nodes list to form proper unattended SQL Server patching command.	True	True
CIFSUserName	String	SQL Server Login username.	False	True
CIFSPassword	String	SQL Server password.	False	True
EncryptedPassword	Switch Parameter	Whether or not the supplied password value is encrypted string obtained from Dx-EncryptText cmdlet. Default is false.	False	False

Examples

Dx-UpgradeSQL "CUSTOMER" "NODE1,NODE2" <commands>

Dx-VhostGetDockerImages

Get a list of Docker images and the running status from the specified Vhost.

Syntax

Dx-VhostGetDockerImages [-VhostName] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns a list of Docker images on the specified Vhost and the running status of the images.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True

Examples

Dx-VhostGetDockerImages "VHOST1"

Dx-VhostGetInstances

Get a list of SQL Server instances and the running status from the specified Vhost.

Syntax

Dx-VhostGetInstances [-VhostName] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns a list of SQL Server instances on the specified Vhost and the running status of the instance.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True

Examples

Dx-VhostGetInstances "VHOST1"

Dx-VhostGetServices

Get a list of services and the running status from the specified Vhost.

Syntax

Dx-VhostGetServices [-VhostName] <string> [<CommonParameters>]

Detailed Description

This cmdlet returns a list of services on the specified Vhost and the running status of the service.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True

Examples

Dx-VhostGetService "VHOST1"

Dx-VhostSetDiskGroup

Associate a list of disks to a Vhost.

Syntax

Dx-VhostSetDiskGroup [-VhostName] <string> [-DiskIDs] <string> [<CommonParameters>]

Detailed Description

A delimited list of disk IDs to be added to the specified Vhost. The disk(s) will be brought online on the active node of the Vhost. The list of disk IDs must include all disk(s) that are to be assigned to the diskgroup.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
DiskIDs	String	A delimited list of GUID Disk IDs or disk labels to be added. Pipe (|) or comma (,) delimited.	True True

Examples

Dx-VhostSetDiskGroup "VHOST1" "dad325ce-3866-283c-1243-b48e92a6cd1d,368525ce-3866-283c-1243-b48e92a6c222"

Dx-VhostSetDockerImage

Set the Docker image assigned to the specified Vhost.

Syntax

Dx-VhostSetDockerImage [-VhostName] <string> [-DockerName] <string> [-Image] <string> [<CommonParameters>]

Detailed Description

This cmdlet sets the Docker image that is assigned to the specified Vhost.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
DockerName	String	The name of the Docker container.	True	True
Image	String	The image name, image ID or both. Valid format is <ImageName>@<ImageID>.	True	True

Examples

Dx-SetDockerImage "VHOST1" "MSSQL1" "microsoft/mssql-server-linux@ab1edc3f85cd"

Dx-VhostStartNode

Start hosting on a node.

Syntax

Dx-VhostStartNode [-VhostName] <string> [-NodeName] <string> [<CommonParameters>]

Detailed Description

This cmdlet starts a Vhost and all associated instances on a specific node. Stops the Vhost, and all associated instances, if it is currently running on a different node.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
NodeName	String	The name of the node.	True	True

danger

Forcing failover to an asynchronous availability group replica can result in data loss.

Examples

Dx-VhostStartNode "VHOST1" "NODE1"

Dx-VhostStopNode

Stop hosting on a node.

Syntax

Dx-VhostStopNode [-VhostName] <string> [-NodeName <string>] [<CommonParameters>]

Detailed Description

This cmdlet stops a Vhost and all associated instances, if the Vhost is active, it marks the Vhost as administratively disabled. Administratively disabled Vhosts are not automatically restarted as part of failover actions.

Parameters

Name	Type	Description	Required	Command-line Input
VhostName	String	The name of the Vhost.	True	True
NodeName	String	The name of the node.	False	False

Examples

Dx-VhostStopNode "VHOST1"