sql clustering

  • Hi All,

    Am very new to SQL Server Clusttering ?? I have less knowledge in this area nor i got any chance to work on it which involves

    resources , resource groups , storage (SAN) etc....

    If am a fresher / or a new comer to SQL Admin area what questions can be asked to test the knowlege on sql clusttering??

    Is that mandatory to have hands on experience on what is sql clusttering and failover happens in sql clusttering??

    Recently, i have attended some interviews and am able to answer to types and some concepts on clusttering. I don't exactly know what they

    are expecting from the a Jr.DBA on this regard???

    Can anyone share there thoughts on this ?

    Thanks in Advance.

  • Oracle_91 (6/7/2010)


    Hi All,

    Am very new to SQL Server Clusttering ?? I have less knowledge in this area nor i got any chance to work on it which involves

    resources , resource groups , storage (SAN) etc....

    all of these can be reproduced in virtual environments for test\educational purposes! I have a tech article that details how to do this if you need it

    Oracle_91 (6/7/2010)


    If am a fresher / or a new comer to SQL Admin area what questions can be asked to test the knowlege on sql clusttering??

    Is that mandatory to have hands on experience on what is sql clusttering and failover happens in sql clusttering??

    clustering isnt necessarily mandatory, some organisations do not haveeed this technology. Depends on the requirements

    Oracle_91 (6/7/2010)


    Recently, i have attended some interviews and am able to answer to types and some concepts on clusttering. I don't exactly know what they

    are expecting from the a Jr.DBA on this regard???

    Can anyone share there thoughts on this ?

    Thanks in Advance.

    Interview techniques are a law unto themselves. It depends on the knowledge of the person interviewing you firstly. If they have clustering they would surely expect you to at least understand things like

    resource dependenices,

    adding or removing resources

    failing over groups

    configuring quorum

    preventing or allowing failback, etc

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Perry Whittle (6/7/2010)


    all of these can be reproduced in virtual environments for test\educational purposes! I have a tech article that details how to do this if you need it

    I think it would be great if you would post it. Others following this thread will probably find it useful.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • Hi Perry,

    Can you provide the tech article what you have mentioned.

    It would be great help for everyone.

    Thanks πŸ™‚

  • Hi

    the documents are fairly large but here they are

    Installing Clustered SQL Server 2008 using VMWare Server2

    Installing Clustered SQL Server 2005 using VMWare Server2

    They allow you to create a ringfenced SQL Server cluster installation which you may use to your hearts content without fear of breaking anything (apart from the virtual installation) πŸ˜‰

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Is there some other way other than using vm ware Kindly specify with necessary step documents.

    Thanks in advance.

    Regards
    Durai Nagarajan

  • Thanks Friend!

  • Is there some other way other than using vm ware Kindly specify with necessary step documents.

    I suggest you get Perry's documents, they look very comprehensive.

    If you want to install using Hyper-V then Google can help you find documents on how to set up a Hyper-V cluster, and then follow Perry's document on setting up SQL Server.

    If you are not familiar with installing Windows and SQL Server in non-clustered mode then you will have a great deal to learn in order to get a clustered installation working, expect this learning to take many days to complete.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop HΓ©lder CΓ’mara

  • durai nagarajan (6/8/2010)


    Is there some other way other than using vm ware Kindly specify with necessary step documents.

    Thanks in advance.

    you could also use Microsoft Virtual Server 2005 R2, but to be honest VMWare server is a lot better at the job especially for clustering virtual machines!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • EdVassie (6/9/2010)


    expect this learning to take many days to complete.

    As Ed has said at the very least!

    This is not something you learn and become an expert on in a few days. The environments I show you how to build are designed to be used for ongoing education and testing.

    Clustering requires a certain amount of Windows infrastructure knowledge (i.e. Windows Server, AD, DNS, storage, etc) and this is what you also need to gain experience with.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Thanks guys

    In my company sql is in cluster mode,SAN drive but the server team guys handling it, so they are not ready to expose those knowledge to me. so though of leaning from an DBA level surely i'll learn it after getting little more in windows and other areas specified.

    Regards
    Durai Nagarajan

Viewing 11 posts - 1 through 10 (of 10 total)

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