Cluster Configuration I’m looking at some of the SQL servers in a (new to me) SQL estate. The servers are configured for AOAGs; there are two nodes, both are part of the WSFC. However, if I look at the SQL Server advanced properties the 'Clustered' attribute = 'No'. Would we expect them to be in a SQL cluster sat on a WSFC? In which case I would expect the 'Clustered' attribute = 'Yes'.
This will be Yes if the server is configured as a failover cluster, this does not change based on being  a part of a WSFC or Always On AG.

Source:


  IsClustered:  Server instance is configured in a failover cluster.


1 = Clustered.

0 = Not Clustered.
"
NULL = Input is not valid, an error, or not applicable.

Query to check this:

SELECT SERVERPROPERTY ('IsClustered')