Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Clustering Questions Expand / Collapse
Author
Message
Posted Thursday, March 3, 2011 11:50 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 2, 2014 12:02 AM
Points: 185, Visits: 726
Hi,

Can someone provide few important interview questions on clustering with answers?



Rajesh Kasturi
Post #1072773
Posted Friday, January 25, 2013 2:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 8, 2014 8:46 AM
Points: 6, Visits: 144
1.What is clustering?
2.How many IP addresses are required to configure a 2 node cluster?
3.What are the requirements to install a SQL server cluster?

these are some questions that I would ask in an interview for a start!!
good luck with the answers!!
Post #1411935
Posted Sunday, January 27, 2013 10:57 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 23, 2014 9:40 AM
Points: 41, Visits: 161
Hi Raj

1) What is cluster service ?
2) What is quorum ?
3)What are types of quorum ?
4) What you means private and public network ?
5) What is difference between install SQL server 2005 and SQL server 2008
6) What is difference between the troubleshooting in SQL server 2005 and SQL Server 2008 while installation .
7) How is internal behavior of SQL server 2005 and SQl server 2008
8)What is means of Virtual IP Address and Virtual Name
9) Max number of instance instance in SQL server 2005 and 2008
10) Service pack applying in SQl server 2005 and 2008
11)How internal structure of Quorum?
12)Why is means by MSDTC and It is mandatory for sql server 2005 and 2008
13)How you validating the SQL Cluster ?
14) If your cluadmin is not working then how you validating the whether your resources are online or not
15) What means by prepared owner and possible owner ?
16) What are ip address required when you installing 3 node cluster with 2 instance
Post #1412185
Posted Monday, January 28, 2013 5:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:53 AM
Points: 6,318, Visits: 13,622
Shouldn't you be actually gaining the required knowledge rather than brain dumping a few answers. No doubt if you do manage to land the role any support you require will be gained form this site and others like it

If you really want to under clusters and SQL Server, follow my guide at these links for more info

Part1
Part2
Part3


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1412355
Posted Tuesday, January 29, 2013 1:15 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 7:20 AM
Points: 38, Visits: 432
Hi
Recently I was asked lots of questions on SQL Failover Clustering.
Like :
1. What is the difference between Active/Active , Active/Passive Clustering.
2. What are the main things to be considered while setting up a Failover Clustering.
3. Give a real life scenario when you had a problem/issue with Failover Clustering and how did you tackle it.
4. What is your best achievement on administering Failover Clustering in your DBA life.

Prepare to give them the real life example that you had faced before. If you have already forgotten it , this will be the time to practice again. It is not very difficult to setup and practice this High Availability on a local VM Machine. I would encourage you to be more practical and test it on some test VM pcs.
Hope this will help..
Post #1413297
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse