Post reply

SQL cluster

  • December 12, 2011 at 10:04 am

    #248013

    Hi ,

    Is there any query to find out about sql server is running in which node in cluster setup?

    Thanks

  • December 12, 2011 at 10:06 am

    #1420174

    Here is a query for this.

    SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

    SQL Server Cluster Nodes:

    SELECT * FROM sys.dm_os_cluster_nodes

    SQL Server Cluster Shared Drives:

    SELECT * FROM sys.dm_io_cluster_shared_drives

    java[/url]

  • December 12, 2011 at 10:09 am

    #1420176

    One way is looking in the SQL error log. One of the earlier messages in the current log will state which node the service is running on.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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