Results 1 to 6 of 6

Thread: SQl clustering

  1. 10-13-2005, 01:11 PM #1
    jannat
    jannat is offline Registered User
    Join Date
    Oct 2002
    Location
    queens
    Posts
    139

    SQl clustering

    I have a job interview and I need to know what type of questions can be asked about working in a cluster environment, I don't have much experience in clustering, can someone please give me an idea?

    Thanks in advance!!
    Reply With Quote Reply With Quote
  2. 10-13-2005, 01:36 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Microsoft has many white papers on the subject, read them. Be prepared for questions like how to setup clustering, anything to look out for?, what is failover, failback etc.

    For SQL Server, how many default instance you can have in a cluster?, what's the advantage over log shipping?
    Reply With Quote Reply With Quote
  3. 10-13-2005, 02:28 PM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    When I conduct interview I usually ask few of these questions. This will tell me decide whether to hire the candidate or not.

    a. What is QUORUM
    b. How long it takes to failover from one node to another node
    c. How many nodes you had on your clustering environment
    d. How will you know which node is active node now
    e. How will you find all the shared drives on your cluster server
    f. How will you find the node names
    g. Is clustering and load balancing are same?
    h. What is heartbeat.

    Practice clustering at home. You can use MS virtual server.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  4. 10-13-2005, 02:34 PM #4
    jannat
    jannat is offline Registered User
    Join Date
    Oct 2002
    Location
    queens
    Posts
    139
    where are the answers for those questions?
    Reply With Quote Reply With Quote
  6. 10-13-2005, 02:38 PM #5
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    You will know the answer when you understand clustering.

    Try reading this.

    http://www.sql-server-performance.co...g_shipping.asp

    Jannat. Send me your resume.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  7. 10-13-2005, 02:39 PM #6
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    you can google.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules