March 5, 2012 at 9:30 pm
is there any way to find out the cluster node type(A-A or A-P) through SSMS ?
March 5, 2012 at 11:59 pm
select serverproperty('isclustered') -- will give clusterd or not
declare @Out nvarchar(400)
SELECT @Out = COALESCE(@Out+'' ,'') + Nodename
from sys.dm_os_cluster_nodes
select @out
Above is to display nodes
But not sure how to get A_A or A_P from SSMS.
Thre is no way to find out a-a or a-p from ssms i guess.
March 6, 2012 at 12:08 am
charipg (3/5/2012)
is there any way to find out the cluster node type(A-A or A-P) through SSMS ?
To detect whether you have multiple instances active on multiple nodes you need to query the following for each instance
select serverproperty('computernamephysicalnetbios')
If the results for each instance return a different node name you have multiple instances active on multiple nodes. If the node name is the same then all instances are active on the single node.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2012 at 12:32 am
If we have standalone instances on same the box...then ..it might be confusing right?
March 6, 2012 at 12:44 am
Why on earth would you put a stand alone instance of SQL server onto a cluster node?
The serverproperty element would still return the physical node name for any non clustered instances so it would still be relevant.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply