Sunday, October 11, 2015

SQL Server Failover Cluster Resource Properties & Using PowerShell “FailOverClusters” module

image

image

image

image

image

image

image

image

image

image

image

image

 

PS C:\Users\administrator.DBAGLOBE> Import-Module FailOverClusters

PS C:\Users\administrator.DBAGLOBE> Get-Module

ModuleType Version    Name                                ExportedCommands
---------- -------    ----                                ----------------
Manifest   2.0.0.0    failoverclusters                    {Add-ClusterCheckpoint, Add-ClusterDisk, Add-ClusterFileSe...
Manifest   3.1.0.0    Microsoft.PowerShell.Management     {Add-Computer, Add-Content, Checkpoint-Computer, Clear-Con...
Manifest   3.1.0.0    Microsoft.PowerShell.Utility        {Add-Member, Add-Type, Clear-Variable, Compare-Object...}

PS C:\Users\administrator.DBAGLOBE> Get-Command -Module FailOverClusters

CommandType     Name                                               ModuleName
-----------     ----                                               ----------
Alias           Add-VMToCluster                                    failoverclusters
Alias           Remove-VMFromCluster                               failoverclusters
Cmdlet          Add-ClusterCheckpoint                              failoverclusters
Cmdlet          Add-ClusterDisk                                    failoverclusters
Cmdlet          Add-ClusterFileServerRole                          failoverclusters
Cmdlet          Add-ClusterGenericApplicationRole                  failoverclusters
Cmdlet          Add-ClusterGenericScriptRole                       failoverclusters
Cmdlet          Add-ClusterGenericServiceRole                      failoverclusters
Cmdlet          Add-ClusterGroup                                   failoverclusters
Cmdlet          Add-ClusteriSCSITargetServerRole                   failoverclusters
Cmdlet          Add-ClusterNode                                    failoverclusters
Cmdlet          Add-ClusterPrintServerRole                         failoverclusters
Cmdlet          Add-ClusterResource                                failoverclusters
Cmdlet          Add-ClusterResourceDependency                      failoverclusters
Cmdlet          Add-ClusterResourceType                            failoverclusters
Cmdlet          Add-ClusterScaleOutFileServerRole                  failoverclusters
Cmdlet          Add-ClusterServerRole                              failoverclusters
Cmdlet          Add-ClusterSharedVolume                            failoverclusters
Cmdlet          Add-ClusterVirtualMachineRole                      failoverclusters
Cmdlet          Add-ClusterVMMonitoredItem                         failoverclusters
Cmdlet          Block-ClusterAccess                                failoverclusters
Cmdlet          Clear-ClusterDiskReservation                       failoverclusters
Cmdlet          Clear-ClusterNode                                  failoverclusters
Cmdlet          Get-Cluster                                        failoverclusters
Cmdlet          Get-ClusterAccess                                  failoverclusters
Cmdlet          Get-ClusterAvailableDisk                           failoverclusters
Cmdlet          Get-ClusterCheckpoint                              failoverclusters
Cmdlet          Get-ClusterGroup                                   failoverclusters
Cmdlet          Get-ClusterLog                                     failoverclusters
Cmdlet          Get-ClusterNetwork                                 failoverclusters
Cmdlet          Get-ClusterNetworkInterface                        failoverclusters
Cmdlet          Get-ClusterNode                                    failoverclusters
Cmdlet          Get-ClusterOwnerNode                               failoverclusters
Cmdlet          Get-ClusterParameter                               failoverclusters
Cmdlet          Get-ClusterQuorum                                  failoverclusters
Cmdlet          Get-ClusterResource                                failoverclusters
Cmdlet          Get-ClusterResourceDependency                      failoverclusters
Cmdlet          Get-ClusterResourceDependencyReport                failoverclusters
Cmdlet          Get-ClusterResourceType                            failoverclusters
Cmdlet          Get-ClusterSharedVolume                            failoverclusters
Cmdlet          Get-ClusterSharedVolumeState                       failoverclusters
Cmdlet          Get-ClusterVMMonitoredItem                         failoverclusters
Cmdlet          Grant-ClusterAccess                                failoverclusters
Cmdlet          Move-ClusterGroup                                  failoverclusters
Cmdlet          Move-ClusterResource                               failoverclusters
Cmdlet          Move-ClusterSharedVolume                           failoverclusters
Cmdlet          Move-ClusterVirtualMachineRole                     failoverclusters
Cmdlet          New-Cluster                                        failoverclusters
Cmdlet          Remove-Cluster                                     failoverclusters
Cmdlet          Remove-ClusterAccess                               failoverclusters
Cmdlet          Remove-ClusterCheckpoint                           failoverclusters
Cmdlet          Remove-ClusterGroup                                failoverclusters
Cmdlet          Remove-ClusterNode                                 failoverclusters
Cmdlet          Remove-ClusterResource                             failoverclusters
Cmdlet          Remove-ClusterResourceDependency                   failoverclusters
Cmdlet          Remove-ClusterResourceType                         failoverclusters
Cmdlet          Remove-ClusterSharedVolume                         failoverclusters
Cmdlet          Remove-ClusterVMMonitoredItem                      failoverclusters
Cmdlet          Repair-ClusterSharedVolume                         failoverclusters
Cmdlet          Reset-ClusterVMMonitoredState                      failoverclusters
Cmdlet          Resume-ClusterNode                                 failoverclusters
Cmdlet          Resume-ClusterResource                             failoverclusters
Cmdlet          Set-ClusterLog                                     failoverclusters
Cmdlet          Set-ClusterOwnerNode                               failoverclusters
Cmdlet          Set-ClusterParameter                               failoverclusters
Cmdlet          Set-ClusterQuorum                                  failoverclusters
Cmdlet          Set-ClusterResourceDependency                      failoverclusters
Cmdlet          Start-Cluster                                      failoverclusters
Cmdlet          Start-ClusterGroup                                 failoverclusters
Cmdlet          Start-ClusterNode                                  failoverclusters
Cmdlet          Start-ClusterResource                              failoverclusters
Cmdlet          Stop-Cluster                                       failoverclusters
Cmdlet          Stop-ClusterGroup                                  failoverclusters
Cmdlet          Stop-ClusterNode                                   failoverclusters
Cmdlet          Stop-ClusterResource                               failoverclusters
Cmdlet          Suspend-ClusterNode                                failoverclusters
Cmdlet          Suspend-ClusterResource                            failoverclusters
Cmdlet          Test-Cluster                                       failoverclusters
Cmdlet          Test-ClusterResourceFailure                        failoverclusters
Cmdlet          Update-ClusterIPResource                           failoverclusters
Cmdlet          Update-ClusterNetworkNameResource                  failoverclusters
Cmdlet          Update-ClusterVirtualMachineConfiguration          failoverclusters

PS C:\Users\administrator.DBAGLOBE> Get-ClusterResourceType

Name                                                        DisplayName
----                                                        -----------
DFS Replicated Folder                                       DFS Replicated Folder
DHCP Service                                                DHCP Service
Disjoint IPv4 Address                                       Disjoint IPv4 Address
Disjoint IPv6 Address                                       Disjoint IPv6 Address
Distributed File System                                     Distributed File System
Distributed Network Name                                    Distributed Network Name
Distributed Transaction Coordinator                         Distributed Transaction Coordinator
File Server                                                 File Server
File Share Witness                                          File Share Quorum Witness
Generic Application                                         Generic Application
Generic Script                                              Generic Script
Generic Service                                             Generic Service
IP Address                                                  IP Address
IPv6 Address                                                IPv6 Address
IPv6 Tunnel Address                                         IPv6 Tunnel Address
iSCSI Target Server                                         iSCSI Target Server
Microsoft iSNS                                              iSNS Cluster Resource
MSMQ                                                        (Resource Type Unavailable)
MSMQTriggers                                                (Resource Type Unavailable)
Nat                                                         Network Address Translator
Network File System                                         Network File System
Network Name                                                Network Name
Physical Disk                                               Physical Disk
Provider Address                                            Hyper-V Network Virtualization Provider Address
Scale Out File Server                                       Scale Out File Server
SQL Server                                                  SQL Server
SQL Server Agent                                            SQL Server Agent
SQL Server Availability Group                               SQL Server Availability Group
SQL Server FILESTREAM Share                                 SQL Server FILESTREAM Share
Storage Pool                                                Storage Pool
Task Scheduler                                              Task Scheduler
Virtual Machine                                             Virtual Machine
Virtual Machine Configuration                               Virtual Machine Configuration
Virtual Machine Replication Broker                          Virtual Machine Replication Broker
WINS Service                                                WINS Service

PS C:\Users\administrator.DBAGLOBE> Get-ClusterResourceType | Format-List –Property *


Cluster                : VMMCLU01
DisplayName            : DFS Replicated Folder
Name                   : DFS Replicated Folder
Characteristics        : 0
DllName                : dfsrclus.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 180000
PendingTimeout         : 300000
DeadlockTimeout        : 300000
Id                     : 525ede72-0064-0066-7320-7265706c6963

Cluster                : VMMCLU01
DisplayName            : DHCP Service
Name                   : DHCP Service
Characteristics        : SingleClusterInstance
DllName                : clnetres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 3e771522-0064-0068-6370-207365727669

Cluster                : VMMCLU01
DisplayName            : Disjoint IPv4 Address
Name                   : Disjoint IPv4 Address
Characteristics        : 0
DllName                : clusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 58e2f869-0064-0069-736a-6f696e742069

Cluster                : VMMCLU01
DisplayName            : Disjoint IPv6 Address
Name                   : Disjoint IPv6 Address
Characteristics        : 0
DllName                : clusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 5905086b-0064-0069-736a-6f696e742069

Cluster                : VMMCLU01
DisplayName            : Distributed File System
Name                   : Distributed File System
Characteristics        : 0
DllName                : clusres2.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : e9317b20-0064-0069-7374-726962757465

Cluster                : VMMCLU01
DisplayName            : Distributed Network Name
Name                   : Distributed Network Name
Characteristics        : Clones
DllName                : clusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : d9304048-0064-0069-7374-726962757465

Cluster                : VMMCLU01
DisplayName            : Distributed Transaction Coordinator
Name                   : Distributed Transaction Coordinator
Characteristics        : SingleGroupInstance
DllName                : mtxclu.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 72f49561-0064-0069-7374-726962757465

Cluster                : VMMCLU01
DisplayName            : File Server
Name                   : File Server
Characteristics        : Clones
DllName                : clusres2.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : f582c84f-0066-0069-6c65-207365727665

Cluster                : VMMCLU01
DisplayName            : File Share Quorum Witness
Name                   : File Share Witness
Characteristics        : Quorum
DllName                : clusres2.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 60000
IsAlivePollInterval    : 120000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 3ca26018-0066-0069-6c65-207368617265

Cluster                : VMMCLU01
DisplayName            : Generic Application
Name                   : Generic Application
Characteristics        : 0
DllName                : clusres2.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 6e99410b-0067-0065-6e65-726963206170

Cluster                : VMMCLU01
DisplayName            : Generic Script
Name                   : Generic Script
Characteristics        : 0
DllName                : clusres2.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 6eaba686-0067-0065-6e65-726963207363

Cluster                : VMMCLU01
DisplayName            : Generic Service
Name                   : Generic Service
Characteristics        : 0
DllName                : clusres2.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : bd178b1c-0067-0065-6e65-726963207365

Cluster                : VMMCLU01
DisplayName            : IP Address
Name                   : IP Address
Characteristics        : 0
DllName                : clusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 032c59e7-0069-0070-2061-646472657373

Cluster                : VMMCLU01
DisplayName            : IPv6 Address
Name                   : IPv6 Address
Characteristics        : 0
DllName                : clusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 9c4abb4f-0069-0070-7636-206164647265

Cluster                : VMMCLU01
DisplayName            : IPv6 Tunnel Address
Name                   : IPv6 Tunnel Address
Characteristics        : 0
DllName                : clusres2.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 7435499b-0069-0070-7636-2074756e6e65

Cluster                : VMMCLU01
DisplayName            : iSCSI Target Server
Name                   : iSCSI Target Server
Characteristics        : SingleGroupInstance
DllName                : wtclusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : a513cd83-0069-0073-6373-692074617267

Cluster                : VMMCLU01
DisplayName            : iSNS Cluster Resource
Name                   : Microsoft iSNS
Characteristics        : 0
DllName                : isnsclusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 200c166f-006d-0069-6372-6f736f667420

Cluster                : VMMCLU01
DisplayName            : (Resource Type Unavailable)
Name                   : MSMQ
Characteristics        :
DllName                :
Description            :
AdminExtensions        :
LooksAlivePollInterval :
IsAlivePollInterval    :
PendingTimeout         :
DeadlockTimeout        :
Id                     : 6e5866c8-006d-0073-6d71-000000000000

Cluster                : VMMCLU01
DisplayName            : (Resource Type Unavailable)
Name                   : MSMQTriggers
Characteristics        :
DllName                :
Description            :
AdminExtensions        :
LooksAlivePollInterval :
IsAlivePollInterval    :
PendingTimeout         :
DeadlockTimeout        :
Id                     : f9967861-006d-0073-6d71-747269676765

Cluster                : VMMCLU01
DisplayName            : Network Address Translator
Name                   : Nat
Characteristics        : 0
DllName                : natresource.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 297c91b3-006e-0061-7400-000000000000

Cluster                : VMMCLU01
DisplayName            : Network File System
Name                   : Network File System
Characteristics        : 0
DllName                : nfsres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 2fb1d58d-006e-0065-7477-6f726b206669

Cluster                : VMMCLU01
DisplayName            : Network Name
Name                   : Network Name
Characteristics        : 0
DllName                : clusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 13eb851d-006e-0065-7477-6f726b206e61

Cluster                : VMMCLU01
DisplayName            : Physical Disk
Name                   : Physical Disk
Characteristics        : Quorum, BroadcastDelete, MonitorReattach
DllName                : clusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 7cacdaa4-0070-0068-7973-6963616c2064

Cluster                : VMMCLU01
DisplayName            : Hyper-V Network Virtualization Provider Address
Name                   : Provider Address
Characteristics        : 0
DllName                : provideraddressresource.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 496942c7-0070-0072-6f76-696465722061

Cluster                : VMMCLU01
DisplayName            : Scale Out File Server
Name                   : Scale Out File Server
Characteristics        : Clones
DllName                : clusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : d1138f95-0073-0063-616c-65206f757420

Cluster                : VMMCLU01
DisplayName            : SQL Server
Name                   : SQL Server
Characteristics        : 0
DllName                : sqsrvres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 2fca2427-0073-0071-6c20-736572766572

Cluster                : VMMCLU01
DisplayName            : SQL Server Agent
Name                   : SQL Server Agent
Characteristics        : 0
DllName                : sqagtres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 21e43270-0073-0071-6c20-736572766572

Cluster                : VMMCLU01
DisplayName            : SQL Server Availability Group
Name                   : SQL Server Availability Group
Characteristics        : 0
DllName                : hadrres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 1000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 6a66a1b5-0073-0071-6c20-736572766572

Cluster                : VMMCLU01
DisplayName            : SQL Server FILESTREAM Share
Name                   : SQL Server FILESTREAM Share
Characteristics        : 0
DllName                : fssres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 1000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : c4549e12-0073-0071-6c20-736572766572

Cluster                : VMMCLU01
DisplayName            : Storage Pool
Name                   : Storage Pool
Characteristics        : BroadcastDelete, MonitorDetach, MonitorReattach
DllName                : clusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 76c76b05-0073-0074-6f72-61676520706f

Cluster                : VMMCLU01
DisplayName            : Task Scheduler
Name                   : Task Scheduler
Characteristics        : SingleClusterInstance
DllName                : clusres2.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : da9cde5a-0074-0061-736b-207363686564

Cluster                : VMMCLU01
DisplayName            : Virtual Machine
Name                   : Virtual Machine
Characteristics        : PlacementAware, MonitorDetach, MonitorReattach, OperationContext
DllName                : vmclusres.dll
Description            :
AdminExtensions        : {{B0CA44F2-1FFC-4BD1-8930-F4480301981B}}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : df7c6e10-0076-0069-7274-75616c206d61

Cluster                : VMMCLU01
DisplayName            : Virtual Machine Configuration
Name                   : Virtual Machine Configuration
Characteristics        : MonitorDetach, MonitorReattach, NotPreemptable
DllName                : vmclusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 24049dca-0076-0069-7274-75616c206d61

Cluster                : VMMCLU01
DisplayName            : Virtual Machine Replication Broker
Name                   : Virtual Machine Replication Broker
Characteristics        : SingleClusterInstance
DllName                : vmclusres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 257087d3-0076-0069-7274-75616c206d61

Cluster                : VMMCLU01
DisplayName            : WINS Service
Name                   : WINS Service
Characteristics        : SingleClusterInstance
DllName                : clnetres.dll
Description            :
AdminExtensions        : {}
LooksAlivePollInterval : 5000
IsAlivePollInterval    : 60000
PendingTimeout         : 180000
DeadlockTimeout        : 300000
Id                     : 44673666-0077-0069-6e73-207365727669

PS C:\Users\administrator.DBAGLOBE> Get-ClusterResource| Format-List –Property *


Cluster                 : VMMCLU01
IsCoreResource          : False
IsNetworkClassResource  : True
IsStorageClassResource  : False
OwnerNode               : VMMSQL01
ResourceType            : IP Address
State                   : Online
OwnerGroup              : Cluster Group
Name                    : Cluster IP Address
MaintenanceMode         : False
MonitorProcessId        : 2564
Characteristics         : 0
Description             :
SeparateMonitor         : False
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : 146c9bef-218d-4111-86b4-520f8356c56a

Cluster                 : VMMCLU01
IsCoreResource          : True
IsNetworkClassResource  : False
IsStorageClassResource  : False
OwnerNode               : VMMSQL01
ResourceType            : Network Name
State                   : Online
OwnerGroup              : Cluster Group
Name                    : Cluster Name
MaintenanceMode         : False
MonitorProcessId        : 2564
Characteristics         : 0
Description             :
SeparateMonitor         : False
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : 2f08170c-2467-4349-bcf9-f98849a24cdf

Cluster                 : VMMCLU01
IsCoreResource          : True
IsNetworkClassResource  : False
IsStorageClassResource  : False
OwnerNode               : VMMSQL01
ResourceType            : File Share Witness
State                   : Online
OwnerGroup              : Cluster Group
Name                    : File Share Witness
MaintenanceMode         : False
MonitorProcessId        : 2564
Characteristics         : Quorum
Description             :
SeparateMonitor         : False
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : f358a8fa-b3f4-41b5-abaf-a3e1971142e8

Cluster                 : VMMCLU01
IsCoreResource          : False
IsNetworkClassResource  : True
IsStorageClassResource  : False
OwnerNode               : VMMSQL01
ResourceType            : IP Address
State                   : Online
OwnerGroup              : SQL Server (PROD3)
Name                    : SQL IP Address 1 (SQLCLU02)
MaintenanceMode         : False
MonitorProcessId        : 2564
Characteristics         : 0
Description             :
SeparateMonitor         : False
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : 7e2e5620-3c93-41fc-b887-4687d5ecdb29

Cluster                 : VMMCLU01
IsCoreResource          : False
IsNetworkClassResource  : False
IsStorageClassResource  : False
OwnerNode               : VMMSQL01
ResourceType            : Network Name
State                   : Online
OwnerGroup              : SQL Server (PROD3)
Name                    : SQL Network Name (SQLCLU02)
MaintenanceMode         : False
MonitorProcessId        : 2564
Characteristics         : 0
Description             :
SeparateMonitor         : False
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : 54b6dc4d-0277-495b-a0b1-500916f7d30c

Cluster                 : VMMCLU01
IsCoreResource          : False
IsNetworkClassResource  : False
IsStorageClassResource  : False
OwnerNode               : VMMSQL01
ResourceType            : SQL Server
State                   : Online
OwnerGroup              : SQL Server (PROD3)
Name                    : SQL Server (PROD3)
MaintenanceMode         : False
MonitorProcessId        : 3260
Characteristics         : 0
Description             :
SeparateMonitor         : True
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : b6641d74-2973-4333-a0b4-25b05e23c14a

Cluster                 : VMMCLU01
IsCoreResource          : False
IsNetworkClassResource  : False
IsStorageClassResource  : False
OwnerNode               : VMMSQL01
ResourceType            : SQL Server Agent
State                   : Online
OwnerGroup              : SQL Server (PROD3)
Name                    : SQL Server Agent (PROD3)
MaintenanceMode         : False
MonitorProcessId        : 3288
Characteristics         : 0
Description             :
SeparateMonitor         : True
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : a3115cbf-29f7-48e4-b7d3-6e0102c91e7b

Cluster                 : VMMCLU01
IsCoreResource          : False
IsNetworkClassResource  : False
IsStorageClassResource  : False
OwnerNode               : VMMSQL02
ResourceType            : SQL Server Availability Group
State                   : Online
OwnerGroup              : SSRS_AG
Name                    : SSRS_AG
MaintenanceMode         : False
MonitorProcessId        : 2544
Characteristics         : 0
Description             :
SeparateMonitor         : False
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : 0e99016e-ef29-4710-9203-bda20ee7e64a

Cluster                 : VMMCLU01
IsCoreResource          : False
IsNetworkClassResource  : True
IsStorageClassResource  : False
OwnerNode               : VMMSQL02
ResourceType            : IP Address
State                   : Online
OwnerGroup              : SSRS_AG
Name                    : SSRS_AG_10.0.2.202
MaintenanceMode         : False
MonitorProcessId        : 2536
Characteristics         : 0
Description             :
SeparateMonitor         : False
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : 5d26728f-583d-44c6-92cc-6f6e822057a0

Cluster                 : VMMCLU01
IsCoreResource          : False
IsNetworkClassResource  : False
IsStorageClassResource  : False
OwnerNode               : VMMSQL02
ResourceType            : Network Name
State                   : Online
OwnerGroup              : SSRS_AG
Name                    : SSRS_AG_VMMAG02
MaintenanceMode         : False
MonitorProcessId        : 2536
Characteristics         : 0
Description             :
SeparateMonitor         : False
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : 694e2bcd-7b38-43a8-9b93-518730e4d403

Cluster                 : VMMCLU01
IsCoreResource          : False
IsNetworkClassResource  : False
IsStorageClassResource  : False
OwnerNode               : VMMSQL02
ResourceType            : SQL Server Availability Group
State                   : Online
OwnerGroup              : TestDB1_AG
Name                    : TestDB1_AG
MaintenanceMode         : False
MonitorProcessId        : 2544
Characteristics         : 0
Description             :
SeparateMonitor         : False
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : b98b7aa8-d84d-403c-86a8-117aedf278a0

Cluster                 : VMMCLU01
IsCoreResource          : False
IsNetworkClassResource  : True
IsStorageClassResource  : False
OwnerNode               : VMMSQL02
ResourceType            : IP Address
State                   : Online
OwnerGroup              : TestDB1_AG
Name                    : TestDB1_AG_10.0.2.201
MaintenanceMode         : False
MonitorProcessId        : 2536
Characteristics         : 0
Description             :
SeparateMonitor         : False
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : b9e43465-2ba9-455b-830e-9a07483db7ba

Cluster                 : VMMCLU01
IsCoreResource          : False
IsNetworkClassResource  : False
IsStorageClassResource  : False
OwnerNode               : VMMSQL02
ResourceType            : Network Name
State                   : Online
OwnerGroup              : TestDB1_AG
Name                    : TestDB1_AG_VMMAG01
MaintenanceMode         : False
MonitorProcessId        : 2536
Characteristics         : 0
Description             :
SeparateMonitor         : False
StatusInformation       : 0
PersistentState         : 1
LastOperationStatusCode : 0
LooksAlivePollInterval  : 4294967295
IsAlivePollInterval     : 4294967295
RestartAction           : 2
RestartThreshold        : 1
EmbeddedFailureAction   : 2
RestartDelay            : 500
RestartPeriod           : 900000
RetryPeriodOnFailure    : 3600000
PendingTimeout          : 180000
DeadlockTimeout         : 300000
ResourceSpecificData1   : 0
ResourceSpecificData2   : 0
ResourceSpecificStatus  :
Id                      : fc7ecd8c-f18d-4059-98e6-d8291d0e99f2

No comments:

Post a Comment