Bild_go-cluster+(S.+34)+-+NICHT+IN+SOCIAL+MEDIA+VERWENDEN

Any DBA going for new environment he should know how many nodes Exist in SQL Server Cluster he will mange it so today i will share with small DMV can tell us this information easily without doing more effort

“” SELECT * FROM ::FN_VIRTUALSERVERNODES() “”

DMV Return :

Node Name : the name of the Windows Server (Computer Name)

Status : Sever Status (Ruining / DOWN )

Is Current owner : it will tell you which node your SQL sever up and running on it now

Follow the author:

View all my tips , LinkedIn , Website , Slideshare  , ABOUT ME

Published by Mustafa EL-Masry

MY NAME IS MUSTAFA ELMASRY I have total years’ Experience +10 in SQL Server technology started my carrier path in 2008 as technical Support and now I am working as a Database Consultant in the banking sector managing around 200 DB Servers AS Production servers plus other environments UAT, SIT and staging servers, I have High-level experience in Database Administration, Performance Tuning, disaster recovery, development (T-SQL), SSRS. And Good Experiences in SSIS, SSAS AZURE DB, Automation (Power-Shell + TSQL) I will be Happy if you take a look on my main profile to know more information about me and to know how you can contact me (https://mostafaelmasry.com/about-me/)

One thought on “How many nodes exist in a SQL Server cluster”

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.