Post reply

Transaction Log full on DR mirror dbs

  • November 28, 2018 at 7:22 am

    #382369

    I m getting this alert below and i cant understand why since this is on the DR server where the databases are mirror synchronized. 

  • DESCRIPTION:   TheSQL Server performance counter 'Percent Log Used' (instance '_Total') of object'SQLServer:Databases' is now above the threshold of 80.00 (the current value is99349633784.00).

    • Can someone share some light?

  • November 28, 2018 at 10:40 am

    #2014847

    All transactions are replayed on the mirror, so log space is used. You have an alert on the DR server looking for the log being above 80%. Not sure what your config is, but you should look at the sizes and free space on both the primary and mirror. They should be the same, but the primary might not have an alert set.

  • November 28, 2018 at 2:31 pm

    #2014884

    I have set up alerting on both sides but only the mirror is the one that sends messages with threshold alerts ... the alert comes when 80 per sent threshold has exceeded

    Any ideas

    • Viewing 3 posts - 1 through 2 (of 2 total)

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