MSSQL Interview Question Clustering- Part4

Q: What is the standard setting of Lookslive, IsAlive and Pending Timeout?

Ans: LooksAlive - 5 sec IsAlive - 30 sec Pending Timeout - 180 sec

Note- Do not modify Pending Timeout. The value, represented in seconds, is the amount of time the resource in either the Offline Pending or Online Pending states has to resolve its status before the Cluster Service puts the resource in either Offline or Failed status.

Q: Can you change failover policy? If Yes then how?

Ans: To configure the failover policy, in the Threshold box, enter the number of times the group is allowed to fail over within a set span of hours. In the Period box, enter the set span of hours. For example, if Threshold is set to 10 and Period is set to 6, the Cluster Service fails the group over a maximum of 10 times in a 6-hour period. At the 11th failover in that 6-hour period, the server cluster leaves the group offline. This affects only resources that were failed over; therefore, if the SQL Server resource failed 11 times, it would be left offline, but the IP could be left online.

Q: What is the status of the Cluster Service and SQL service on both the nodes? Would they both were stop on the passive node?

Ans: Cluster service is automatic and started mode on all the nodes. But SQL Service will run only on the active node.

Q: Is it possible to put Cluster Group and SQL Group on different nodes?

Ans: Yes it is Possible. If you have one group on one node and another group on another node... that will run.

Q: Do you know any kind of limitation for Clustering?

Ans: Yes, We cannot do clustering with Windows 2000 Professional or lower server versions. Clustering is only available on servers running Windows 2000 Advanced Server (which supports 2-node clusters), Windows 2000 Datacenter Server (which supports up to 4-node clusters), or Windows 2003 Enterprise Edition and Windows 2003 Datacenter Server (which support up to 8-node clusters).

Q: How does Cluster perform at the time of failover?

Ans: Clusters use an algorithm to detect a failure, and use failover policies to determine how to handle the work from a failed server. These policies also specify how a server is to be restored to the cluster when it becomes available again.

Q: What are all resources controlled by Cluster?

Ans: The short list of resources controlled by the cluster will be-

•Physical Disks (Q:—Quorum disk, E:—Shared disks, F:, so on)
•Cluster IP Address
•Cluster Name (Network Name)
•SQL Server Virtual IP Address
•SQL Server Virtual Name (Network Name)
•SQL Server
•SQL Agent
•SQL Full Text Service Instance (if installed)

Q: How to configure MSDTC as a cluster resource?

Ans: Setup DTC using following command
C:\Windows\System32> DTCSetup.exe
From a DOS command prompt, run comclust.exe on node A. This will configure MS DTC for use with cluster services.
C:\Windows\System32> comclust.exe

Reader of This blog also showed their interest in following blogs:
  1. SQL Server DBA “Interview Questions And Answers”
  2. SQL Azure Interview Questions and Answers Part – 1
  3. SQL Azure Interview Questions and Answers Part – 2
  4. Powershell Interview Questions and Answers
Along with technical learning I would like to share some great articles for anyone interested in the betterment of his/her family life



Popular posts from this blog

Understand Query Execution Plan- Index Scan, Index Seek And Key Lookup

MSSQL Interview Question Clustering- Part1

DBCC CheckDB The operating system returned error 21(The device is not ready.)