MSSQL Interview Question Clustering- Part3

Q6 - Why is this needed to manage the max memory on failover cluster?
Ans: So if you have a two-node cluster, each currently configured with 8 GB of memory as well as two instances of SQL Server (one with 5 GB of memory and the other with 7 GB), 7 + 5 does not equal 8; it equals 12. If they both happen to run on the same node, one will probably be able to get the memory it needs and the other will not. You need to adjust the amount of memory your instances are using so that, in a failover scenario, you do not starve one instance or possibly have it not start up after failover


Q7-Why antivirus should not be run on?
Ans: If there is no reason to put antivirus software on the cluster nodes dedicated to SQL Server, very secure, and without file shares on it, do not install the software. If your corporate security policy dictates that antivirus software must be configured on all servers, you must set the filtering of the antivirus program to exclude the scanning of all SQL Server drives that contain data and log files. You do not want the scanner on another node in the event of a failover to detect the drive and prevent SQL Server from starting because the virus scanner is now scanning your database and log files. Also remember, as noted in Chapter 5, to exclude the \MSCS directory on the quorum if you are using a disk-based quorum

Q8 - How to see the drives?
Ans: Execute the following Transact-SQL query:
select * from ::fn_servershareddrives()

Q9- Fail Resources on a group level?
Ans: To prevent an automatic failback, select Prevent Failback. To allow automatic failback, select Allow Failback, and then one of the following options:


•Immediately This means that the moment Windows Clustering detects that the preferred cluster node is online, it fails back any resources. This is not advisable because it could disrupt clients and applications, especially at peak times in the business day.

•Failback Between N And N1 Hours This option allows a controlled failback to a preferred node (if it is online) during a certain period. The hours are set using numbers from 0 through 23.

Q10- If you dont want the group to fail in case of any resource failure what you shoud do?

Ans: Clear "Affect the group" For that resource.

Q11- what are the parameters for "Affact The Group"?

Ans: Threshold- where you can define the retries of failover-- No of time cluster service will restart the resources
     Period - The amount of time between the retries.
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

Regards,

http://tuitionaffordable.webstarts.com

Comments

  1. TejutejuNovember 2, 2018 at 12:07 AM

    it is very excellent blog and useful article thank you for sharing with us , keep posting
    Azure Online Course


    ReplyDelete

Post a Comment

Popular posts from this blog

MSSQL Interview Question Clustering- Part2

Will Indian Rupee Cross 55?? Q: What will happen if you try to start the SQL service on the passive node? Ans: This will start because error log, mdf and ldf files are possessed by active node. Q: How exactly the SQL service starts on any node? Ans: Below is the list of all the steps in error log at the of SQL Service starting on one node, all the logs are self-explanatory- 1-SQLServerAgent service successfully stopped. 2-[sqsrvres] OnlineThread: asked to terminate while waiting for QP. 3-17148 :SQL Server is terminating due to 'stop' request from Service Control Manager. 4-17104 :Server Process ID is 9344. 5-This instance of SQL Server last reported using a process id of 6804 at 1/23/2011 10:39:34 AM (local) 1/23/2011 6:39:34 PM (UTC). 6-SQL Server is starting at priority class 'normal'(16 CPUs detected). 7-SQL Server configured for thread mode processing. 8-17125 :Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Block
Read more

Error 1067: The cluster service is stopped on passive node of my two node sql cluster. It throws following error when I try to start this:

This is found that the cluster service in one of the passive stops. This throws following error when I try to start this. Error 1067: The process terminated unexpectedly I verified the password under which this cluster service is running. This account is perfect. So there should be some other problem. Let's go ahead and see the problem in the cluster.log file. Info from %WINDIR%\Cluster\cluster.log is as follows: WARN [EVT] EvtBroadcaster: EvPropEvents for node 2 failed. status 1727 WARN [NM] RpcExtErrorInfo: Error info not found. Error from clusterlog Error: Failed to read  (sector 12), error 170. and Failed to write  (sector 12), error 170. 1. started from cmd. net start clussvc 2. The Windows Firewall/Internet Connection Sharing service should neither be enabled nor set to start automatically. FmGetQuorumResource failed, error 170. Failed to read. Failed to form cluster, status 5086. Follwoing was the problem: The Admin NIC threw an error. This caused the netowrk c
Read more

Handle Sexual Harassment

Image
Sexual harassment at work place is prevalent. It can be termed as bullying, unwelcome sexual advances and asking sexual favors at workplace. Harassment can happen to anyone and probability of recurrence increases if not tackled professionally. This is often observed that we don't talk enough on this topic. Some EEOC stats as per  link 79% of victims are women, 21% are men. 51% are harassed by a supervisor. Business, trade, banking, and finance are the biggest industries where sexual harassment occurs. 12% received threats of termination if they did not comply with their requests.  How to handle the sexual harassment- This needs to be documented. Victim should send out a mail to the offender informing that she/he is shocked with his/her actions on date at particular venue. I discussed this situaltion with my relatives and they asked me to inform you about my feelings. The victim has to be very professional. Victim needs to make sure that he seek for the read rece
Read more