1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

MSSQL

Transaction Log Full - SNAP_NO_NEW_ENTRY

Tuesday, 17 September 2019 23:25

Problem Statement : In one of the SAP BW production system, we noticed that 45.6% of transaction log was used, when we reported it to the functional team, they came back saying there are no dataloads/heavy transactions running in the system. This reaction from functional team triggered a question that is "Why in the world, the transaction log space does not get freed up even after performing the transaction log backup at regular intervals (15 minutes).

 

Read more...