SERVERPROPERTY('IsClustered') does not return the correct value in a cluster configuration
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: SQLAGCLU 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... Some one can give a feedback about it? Thanks ALEN
SQL Always On when QUORUM fails
Hello friends, i have a sql cluster with always on and today i noticed a scenario. When I restarted the domain / dns server that is my quorum when trying to authenticate to the databases I had difficulty and generated several failures in the cluster of quorum unavailable. So I asked myself regarding the importance of the availability of my domain controller server to access the databases. However I have another domain controller server (secondary) which is also DNS. Can anyone tell me how long it takes servers that authenticate to the domain/dns server need to direct connections to the secondary server? Can this be adjusted to be faster? Thanks.
