SQL 2000 clustering

Question

Post reply

SQL 2000 clustering

shanila_minnu

Hall of Fame

Points: 3465
More actions
February 18, 2010 at 5:19 am

#145298

How can we check,which is the active node in ACTIVE-PASSIVE clustering

Viewing 8 posts - 1 through 7 (of 7 total)

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

jshailendra SSCrazy Points: 2260 More actions · Answer 1

Login to your Cluster (Virtual Server) and type hostname at command prompt.

shanila_minnu Hall of Fame Points: 3465 More actions · Answer 2

shanila_minnu

Hall of Fame

Points: 3465

February 18, 2010 at 5:29 am

#1120820

thank u very much for the prompt response

shanila_minnu Hall of Fame Points: 3465 More actions · Answer 3

Is there any way to check when did the last failover happens

jshailendra SSCrazy Points: 2260 More actions · Answer 4

I dont have Cluster server with me as of now...but I guess you should able to get this info in Cluster Management Console..or in event logs

shanila_minnu Hall of Fame Points: 3465 More actions · Answer 5

In my environment there is 2 node clustering(A & B).For the past two months active node was 'A' ,At that time in aparticular time say ,3.00 PM memory usage was hitting 95%.This month the node is changed to 'B'..now the memory is not hitting..

Can anyone suggest why it is like that

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 6

shanila_minnu (2/18/2010)
Is there any way to check when did the last failover happens

Easiest way is check your sql server error log.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 7

Opening Event Viewer and viewing events related to failover clustering

To open Event Viewer and view events related to failover clustering:

If Server Manager is not already open, click Start, click Administrative Tools, and then click Server Manager. If the User Account Control dialog box appears, confirm that the action it displays is what you want, and then click Continue.

In the console tree, expand Diagnostics, expand Event Viewer, expand Windows Logs, and then click System.

To filter the events so that only events with a Source of FailoverClustering are shown, in the Actions pane, click Filter Current Log. On the Filter tab, in the Event sources box, select FailoverClustering. Select other options as appropriate, and then click OK.

To sort the displayed events by date and time, in the center pane, click the Date and Time column heading.

Verify

To perform this procedure, you must be a member of the local Administrators group on each clustered server, and the account you use must be a domain account, or you must have been delegated the equivalent authority.

http://technet.microsoft.com/en-us/library/dd353973(WS.10).aspx

MJ