cluster

Question

cluster

giri10488

Right there with Babe

Points: 729
More actions
July 6, 2015 at 7:06 am

#309670

can u pls tell me what is the role of sql dba in cluster environment?
which things he has to monitor & how?
main role of dba if one node goes down?
Give me all the details plsss

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

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

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

giri10488 (7/6/2015)
can u pls tell me what is the role of sql dba in cluster environment?
which things he has to monitor & how?
main role of dba if one node goes down?
Give me all the details plsss

depends on the organisation, I have worked in environments where the DBA is not allowed to touch the windows server or failover cluster and in some cases where the DBA manages the whole lot cluster too

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

"Ya can't make an omelette without breaking just a few eggs" 😉

Steve Jones - SSC Editor SSC Guru Points: 736362 More actions · Answer 2

There is no complete list of all the details. Really for a cluster you need to respond just like any other instance failure. However what you do will be different because you're dealing with multiple nodes that are linked.

If you don't understand how a cluster works, I'd start there. Learn what happens when it fails over, and how you need to fix things. The items that you must do, versus what others may do, varies, as Perry mentioned.

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 3

Start Here :

https://www.microsoftvirtualacademy.com/en-us/training-courses/failover-clustering-in-windows-server-2012-r2-8489

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]

giri10488 Right there with Babe Points: 729 More actions · Answer 4

I know the working of cluster but i only want to know what is the role of dba in cluster from beginning to end

pls tell me

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

it depends on the organisation

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

"Ya can't make an omelette without breaking just a few eggs" 😉

giri10488 Right there with Babe Points: 729 More actions · Answer 6

i want general role of dba on cluster if something happen and organisation will tell us to do that and if that task related to system admin to determine task i want the role of dba in cluster

r.sundarmca10 Newbie Points: 5 More actions · Answer 7

Hi Team,

This is my first post.

Please give me set off high-availability interview Q&A with some real time examples.

[font="Verdana"][/font]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

r.sundarmca10 (7/8/2015)
Please give me set off high-availability interview Q&A with some real time examples.

Sure.

"Describe to me the last high-availability implementation you did. What technology did you use and why? What problems did you encounter in the implementation, how did you solve them?"

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 9

GilaMonster (7/8/2015)
r.sundarmca10 (7/8/2015)
Please give me set off high-availability interview Q&A with some real time examples.
Sure.
"Describe to me the last high-availability implementation you did. What technology did you use and why? What problems did you encounter in the implementation, how did you solve them?"

Good question. Please post your response here.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

GilaMonster (7/8/2015)
r.sundarmca10 (7/8/2015)
Please give me set off high-availability interview Q&A with some real time examples.
Sure.
"Describe to me the last high-availability implementation you did. What technology did you use and why? What problems did you encounter in the implementation, how did you solve them?"

Add...

"Why did you leave the position where this HA implementation was for which you just described?"

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Perry Whittle SSC Guru Points: 234013 More actions · Answer 11

what core cluster resources are created during an install of a failover cluster instance?

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

"Ya can't make an omelette without breaking just a few eggs" 😉