SERVERPROPERTY('IsClustered') does not return the correct value in a cluster configuration

Alen Cappelletti 1,047 Reputation points
2025-03-26T18:40:30.92+00:00

Hi all!

I'm testing some t-sql SQL properties for a data collection project and I got a strange case with the query below:

	SELECT 

		SERVERPROPERTY(''MachineName') AS [MachineName], 
 		SERVERPROPERTY('ServerName') AS [ServerName],  
 		SERVERPROPERTY('InstanceName') AS [Instance], 
 		SERVERPROPERTY('IsClustered') AS [IsClustered], 
 		SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS [ComputerNamePhysicalNetBIOS], 
 		SERVERPROPERTY('Edition') AS [Edition]

I have two test instances of SQL Server 2019. They both belong to a cluster without shared storage, as the availability groups allow it: SQLAGCLUUser's image

I don't understand why the query is returning "incorrect" properties. I expected them to have the value 1 for the "IsClustered" column. From the query that I use, I have no idea witch SQL instance are in a cluster...

User's image

Some one can give a feedback about it?
Thanks ALEN


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.