I have two questions regarding SQL Server Monitoring:
1. How can we differentiate between standalone SQL Server and Clustered SQL Server?

2. How can we identify the members of a cluster and their roles ? Is it possible through WMI queries ?

Thanks in advance.

There is no direct way I know of within SQL server. Where I work, we differentiate via nameing standards to know if the sql instance, admin name, physical node name on a cluster or if it's a stand-alone install. Related to your second question, not sure about a WMI interface to Cluster services, but there does exist and COM interfaces to the API - http://msdn.microsoft.com/library/de...start_page.asp

"Ritesh Gupta" wrote:

select serverproperty('isclustered')

See inline ...

I have two questions regarding SQL Server Monitoring:
1. How can we differentiate between standalone SQL Server and Clustered SQL Server?

<uttam>
Connect to the SQL Server using Query Analyzer and run the following query

select serverproperty('isclustered')

If it returns a 1, it is clustered. 0 implies standalone. See SQL Server Books Online for more info.

</uttam>

2. How can we identify the members of a cluster and their roles ? Is it possible through WMI queries ?

<uttam>
I haven't used WMI much and hence cannot comment on this. But you can use the command line utility cluster.exe to find out the information about the members of the
cluster and their roles.

Type cluster /? to get all the options.

For example, if you run
cluster CLUSTERNAME resource
will return you all the resourses, the node on which it is running and its status.

You can do everything using cluster.exe that you can do from cluster administrator and more.

</uttam>

HTH,

Thanks in advance.
Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest
way to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx