Monday, March 26, 2012

GetIsClustered() returns FALSE for Veritas Cluster Server

With both SQL Server 2000 and SQL Server 2005 when running in a Veritas Cluster, the GetIsClustered() API returns FALSE.

Does anyone know if this is working as designed?

Does GetIsClustered() really only mean MSCS clustered or should Veritas be setting that server property?

Thanks

Del Hoobler

Posting the last email thread that we had on the topic.

From: Michiel Wories
Sent: Monday, January 09, 2006 10:34 PM
To: 'Del Hoobler'
Cc: Mark Wistrom
Subject: RE: SQL Server 2005 - "IsClustered" - Is it just for MSCS?

Hi Del, as it seems Veritas clusters do not express their ‘cluster-ness’ through this serverproperty, so you would need to check with them how this is done. This is specific to their implementation so I am afraid I cannot help you with that.

Thanks,

Michiel

From: Del Hoobler
Sent: Monday, January 09, 2006 6:52 PM
To: Michiel Wories
Cc: Mark Wistrom
Subject: RE: SQL Server 2005 - "IsClustered" - Is it just for MSCS?


Hi Michiel,
Yes... this is what gets called for GetIsClustered(): (Here is the profile snippet):
14:29.9 select convert(int, serverproperty(N'isclustered'))
14:29.9 select convert(int, serverproperty(N'isclustered'))
14:29.9 select convert(int, serverproperty(N'isclustered'))
But... it sounds like what Mark is saying is that this field only pertains to MSCS... and we need
another way to determine if the server is clustered. Do you agree?

Thanks,
Del

No comments:

Post a Comment