Conectare
 
Pagina de pornireBibliotecăInformațiiFişiere de descărcatSuportComunitateForumuri
Resurse pentru profesionişti IT >
> 
> 
Cluster Log Question

Answered Cluster Log Question

  • 28 martie 2012 11:09
     
     
    Sign in pentru a vota
    0

    Hi

    Can anyone assist me? One of my SQL nodes failed over today, and Ive no idea why. I cant see in the cluster log what exactly happens, can anyone see point me in the right direction as to the cause?

    https://skydrive.live.com/redir.aspx?cid=4a44dd20ee06f98f&resid=4A44DD20EE06F98F!120&parid=4A44DD20EE06F98F!118

    Thanks

    Phil


    • Editat de Pilly170 28 martie 2012 11:10
    •  
     

Toate mesajele

  • 28 martie 2012 13:33
     
     
    Sign in pentru a vota
    0

    Hi Phil,

    Have you checked the SQL log at the same time where the failover occured ?

    What OS and SQL version are you running ?

    Br

    René

     
  • 28 martie 2012 13:48
     
     
    Sign in pentru a vota
    0

    OS = 2008 R2

    SQL = 2008R2

    Looks like there was a backup of a single database happening at that time

    Phil

     
  • 30 martie 2012 15:40
     
     Răspuns
    Sign in pentru a vota
    0

    Hi Phil,

    The clusterlog that was uploaded doesn't contain any info regarding the failover. It seems that it has been overwritten. Please notice that the cluster log contains data in GMT.

    Here is a nice blog from Jeff which explains the cluster log:

    Understanding the Cluster Debug Log in 2008

    http://blogs.technet.com/b/askcore/archive/2010/04/13/understanding-the-cluster-debug-log-in-2008.aspx

    Also, I noticed that the cluster log level is set to 5 (DBG). That means that the cluster log will quickly get filled. My suggestions:

    1. Increade the cluster log size: <cluster log /size:200>

    2. Set the cluster log level to 3 (default): <cluster log /level:3>