Clusterd or non clusterd enviroment

Question

Post reply

Clusterd or non clusterd enviroment

Krasavita

SSC-Insane

Points: 23138
More actions
April 15, 2010 at 2:45 pm

#146422

How to find out if I am working in clustered or non clustered enviroment. I know it is a stupid question,but if someone would help me to answer it. I would appreciate it.Thank you very much

Viewing 4 posts - 1 through 3 (of 3 total)

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

From SQL? try:

select serverproperty('ComputerNamePhysicalNetBIOS'), @@ServerName

(See BOL for this). If they are the same, no cluster.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

WayneS SSC Guru Points: 95460 More actions · Answer 2

Also:

select ServerProperty('IsClustered')

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Krasavita SSC-Insane Points: 23138 More actions · Answer 3

Krasavita

SSC-Insane

Points: 23138

April 16, 2010 at 5:35 am

#1152717

Thank you