In one of my earlier post's "Finding Cluster Nodes or Cluster Name" , I had told about the query which can be used to find the name of the node on which the SQL Server Instance is currently running.
Here are more such SQL Server cluster related T-SQL queries which helps in finding SQL Server Cluster Nodes and their shared drives.
Here are more such SQL Server cluster related T-SQL queries which helps in finding SQL Server Cluster Nodes and their shared drives.
- Find name of the Node on which SQL Server Instance is Currently running
If the server is not cluster, then the above query returns the Host Name of the Server.SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS [CurrentNodeName]
- Find SQL Server Cluster Nodes
a. Using Function
SELECT * FROM fn_virtualservernodes()
b. Using DMV
SELECT * FROM sys.dm_os_cluster_nodes
- Find SQL Server Cluster Shared Drives
a. Using Function
SELECT * FROM fn_servershareddrives()
b. Using DMV
SELECT * FROM sys.dm_io_cluster_shared_drives
13 comments:
thank you these comments are very useful.
Thanks. That was great!
Is there code to return the name of the cluster which the instance is hosted on? Not the name of the nodes, but the higher level cluster name which the groups/nodes sit under.
Select @@ServerName will give you the virtual cluster name.
Good stuff bro!
Select @@ServerName will not give you cluster name, but cluster_node/instance_name.. I do not know how to pull cluster name using T-SQL though...
Ed
Very cool, very helpful, thanks so much!
Very Helpful
Excellent!! Thank you very much!!
a pride for me to be able to discuss on a quality website because I just learned to make an article on
cara menggugurkan kandungan
Cool.. helped me :)
Really Awesome Blog Thanks for Sharing...
clipping path
clipping path service
remove white background
car photo editing
now present in your city cara menggugurkan hamil
1. manfaat kurma untuk persalinan
2. manfaat buah nanas
3. aktivitas penyebab keguguran
4. apakah usg berbahaya
5. penyebab telat haid
Post a Comment