clustering

• shanila_minnu

  Hall of Fame

  Points: 3465

  More actions

  February 19, 2010 at 1:45 am

  #138286

  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

• sql_lock

  SSCrazy Eights

  Points: 9373

  More actions

  February 19, 2010 at 1:52 am

  #1121619

  I have a few questions...

  - What is the spec of node A? COU/Mem/Disk setup, using x86 or x64

  - Out of the available memory how much is allocated to SQL

  - Are there any jobs running around that time?

  - What queries were running @ that time?

  - How many users are connected around that time?