How to check cluster config with T-SQL queries

Question

Post reply

How to check cluster config with T-SQL queries

nagkarjun1

Ten Centuries

Points: 1020
More actions
July 13, 2012 at 10:07 am

#272558

What are the T-SQL queries used to get the complete information regarding the cluster on the SQL Server?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

Most of the cluster information is available from the Windows cluster itself, What information do you require?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Vikrant S Patil SSCrazy Points: 2294 More actions · Answer 2

Following is a SQL command that you would want to run to check which node is presently active.

select SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

and you can also confirm whether the instance is clustered by executing the following

:

select SERVERPROPERTY('IsClustered')

There may be quite a few additional queries that may be specific only to a clustered instance but generally speaking SQL server is just riding on the windows cluster. To put it in to perspective, most (if not all) of the other parameters for SERVERPROPERTY would return similar result irrespective of the fact whether it is a clustered or a standalone instance,

BTW starting with SQL Server 2008 a lot of additional and useful OS related information can be collected using the newly introduced DMVs so you may want to explore those DMVs as well.

But having mentioned all this it is still windows information at the end of the day and the earlier post seem to suggest the same as well. It would be great if you can disclose the information that you are looking to find through TSQL.

nagkarjun1 Ten Centuries Points: 1020 More actions · Answer 3

nagkarjun1

Ten Centuries

Points: 1020

July 16, 2012 at 8:03 am

#1513087

Thanks a lot for your reply's

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

Perry Whittle (7/13/2012)
What information do you require?

??

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQL Show SSCertifiable Points: 6143 More actions · Answer 5

There is a lot Dos cmd command for Cluster management. So we can use them via xp_cmdshell.

http://technet.microsoft.com/en-us/library/cc779044(v=ws.10).aspx