January 19, 2011 at 11:04 am
Does anyone know what system tables store the clustering information for a server?
Someone made a reference two days ago on #sqlhelp and I just want to look something up.
January 19, 2011 at 11:40 am
What info specifically? I don't think there's much in SQL, it's more an OS-level thing afaik.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 19, 2011 at 1:20 pm
Brandie,
I think SERVERPROPERTY provides much of the information. What are you looking for in particular? That function can tell you the name of the machine that a clustered instance is running on now (ComputerNamePhysicalNetBIOS), whether the instance IS clustered (IsClustered). You can also use sys.dm_os_cluster_nodes to get a list of nodes in the cluster..
CEWII
January 20, 2011 at 4:59 am
I was talking to someone on Twitter about breaking a cluster. He says that the instances / servers have to be renamed or the sys catalogs will still think the server is part of the cluster. I'm telling him they don't have to be renamed, because I actually have broken a cluster recently (and both instances / servers still have the same names).
So I wanted to double-check my servers to see if what he was telling me was true.
January 20, 2011 at 8:38 am
FYI: I just found out what he was talking about. Not all sys catalogs, but definitely all SQL Server settings that tell if your server is clustered or not.
select * from sys.dm_os_cluster_nodes;
Select serverproperty('isclustered');
SELECT * FROM fn_virtualservernodes();
So you don't have to rename servers if you break a cluster, which is what he insisted when we were trying to help someone else. @=)
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply