January 2, 2014 at 2:19 pm
Hello,
I am trying to document the environment I am working at.
I want to document our clustered servers.
1) Server Name
2) Virtual Server Name
3) Primary node name
4) Active node name
I have the first two covered. Now, I am trying to get the primary node name. I've been looking at different websites and I still do not have a good understanding this server property.
Does SERVERPROPERTY('ComputerNamePhysicalNetBIOS') give the primary node name or the active node name? It seems to me that it gives the active node name? However, I really need the primary node name.
I've tried SERVERPROPERTY('MachineName'), but that gives the same thing as select @@servername.
Thanks.
Tony
Things will work out. Get back up, change some parameters and recode.
January 2, 2014 at 3:02 pm
WebTechie38 (1/2/2014)
Hello,I am trying to document the environment I am working at.
I want to document our clustered servers.
1) Server Name
2) Virtual Server Name
3) Primary node name
4) Active node name
I have the first two covered. Now, I am trying to get the primary node name. I've been looking at different websites and I still do not have a good understanding this server property.
Does SERVERPROPERTY('ComputerNamePhysicalNetBIOS') give the primary node name or the active node name? It seems to me that it gives the active node name? However, I really need the primary node name.
I've tried SERVERPROPERTY('MachineName'), but that gives the same thing as select @@servername.
Thanks.
Tony
ComputerNamePhysicalNetBIOS does give the active node - the one running the current query. http://technet.microsoft.com/en-us/library/ms174396%28v=sql.100%29.aspx I don't know about getting the primary node. If you have an Active-Active cluster, which one would you call the primary?
January 2, 2014 at 3:07 pm
does this query from technet, which purportedly gets cluster information by reading the registry and other items via TSQL help?
COLLECT CLUSTER INFORMATION USING TSQL
i see it identifies node names and node ip's, for example.
Lowell
January 3, 2014 at 2:47 am
WebTechie38 (1/2/2014)
Hello,I am trying to document the environment I am working at.
I want to document our clustered servers.
1) Server Name
2) Virtual Server Name
3) Primary node name
4) Active node name
I have the first two covered. Now, I am trying to get the primary node name. I've been looking at different websites and I still do not have a good understanding this server property.
Does SERVERPROPERTY('ComputerNamePhysicalNetBIOS') give the primary node name or the active node name? It seems to me that it gives the active node name? However, I really need the primary node name.
I've tried SERVERPROPERTY('MachineName'), but that gives the same thing as select @@servername.
Thanks.
Tony
For a clustered instance of SQL Server SERVERPROPERTY('ComputerNamePhysicalNetBIOS') will return the active node name, the node that currently owns the resources. The logic of a primary node name within the SQL instance is non existant, this is ultimately controlled by the Windows cluster. The instance only knows the nodes for which it can failover to. On SQL Server 2008 onwards, this query will provide this info
select * from sys.dm_os_cluster_nodes
Within the Windows cluster itself you are able to define preferred nodes and also possible owners of the resources, these are set by the installer initially but can be changed providing you understand the ramifications of what you are doing 😉
They don't specify that a set node will always own the resources, the preferred node option will still attempt failover to any possible owner of the resources. You can use failback to ensure that a preferred node is always failed back to but this can have undesired consequences on a live service.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply