Tag: transaction log

• Bulk Changed Map (BCM): The Minimally Logged Advantage

  

  2014-05-14 - General, Series, SQL Server Internals, Storage Wednesday

  The Bulk-Logged recovery mode can provide a performance gain for your database. Check out how SQL Server uses the Bulk Changed Map to make this possible.

  [more…]

• Log Reuse Waits Explained: LOG_SCAN

  

  2014-01-21 - General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting LOG_SCAN as reason? Read on to find out what that means and what you can do about it.

  [more…]

• Log Reuse Waits Explained: DATABASE_SNAPSHOT_CREATION

  

  2014-01-20 - General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting DATABASE_SNAPSHOT_CREATION as reason? Read on to find out what that means and what you can do about it.

  [more…]

• Log Reuse Waits Explained: REPLICATION

  

  2014-01-19 - General, Log Reuse Wait, Replication, Series, Transaction Log

  Is your database log file growing out of bound and reporting REPLICATION as reason? Read on to find out what that means and what you can do about it.

  [more…]

• Log Reuse Waits Explained: DATABASE_MIRRORING

  

  2014-01-18 - General, High Availability, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting DATABASE_MIRRORING as reason? Read on to find out what that means and what you can do about it.

  [more…]