Saturday, April 9, 2011

How to find cluster node and its drive name in Sql QueryAnalyzer

select* from sys.dm_os_cluster_nodes
 --output
NodeName
if nodename have values-->server is clustered

or

select * from fn_virtualservernodes()
--output
NodeName


select* from sys.dm_io_cluster_shared_drives
--output
DriveName

If DriveName column have values-->Drive in sqlclustergroup

No comments:

Post a Comment

MYSQL::Setting Validate_Password componet for MySQL Database to ensure password policy settings

Inadequate Password Settings for MySQL Database We observed that the `validate_password%` settings on hostname `<insert hostname>` a...