Post reply

how do we find out cluster environment?

  • September 5, 2012 at 9:57 am

    #280814

    Could you pls helpme out to find out the environment?

    Thank you in Advance 🙂

  • September 5, 2012 at 10:16 am

    #1533984

    there's a SERVERPROPERTY function you can use, but do you need to discover that within a TSQL command?

    SELECT 'IsClustered', SERVERPROPERTY('IsClustered')

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 6, 2012 at 12:34 am

    #1534245

    What exactly are you trying to find out?

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • September 7, 2012 at 4:51 am

    #1534986

    SQL Server cluster related T-SQL queries which helps in finding SQL Server Cluster Nodes and their shared drives.

    1. Find name of the Node on which SQL Server Instance is Currently running

    SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS [CurrentNodeName]

    If the server is not cluster, then the above query returns the Host Name of the Server.

    2. Find SQL Server Cluster Nodes

    a. Using Function SELECT * FROM fn_virtualservernodes()

    b. Using DMVSELECT * FROM sys.dm_os_cluster_nodes

    3. Find SQL Server Cluster Shared Drives

    a. Using FunctionSELECT * FROM fn_servershareddrives()

    b. Using DMVSELECT * FROM sys.dm_io_cluster_shared_drives

    Not sure if this is what you are looking for.:-)

    But, please be specific about your needs while posting questions!!!!

    *******:cool:

    Sudhakar

    *******:cool:
    Sudhakar

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

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