2019 Transaction log size increase during index maintenance

• Kev

  Default port

  Points: 1435

  More actions

  August 11, 2020 at 11:45 pm

  #3779123

  Hi

  I have recently migrated our 2018 databases from 2016 servers (VMWare onsite) to 2019 servers (VMWare AWS)

  and added TDE Encryption to the mix.

  During the nightly index maintenance the log files expand as expected, however onsite (1016) the log files rarely go over 9gb however they now expand to 35gb (2019)

  Does TDE have an effect on size during index maintenance ?

  Does 2019 have an effect ?

  • This topic was modified 4 years, 3 months ago by  Kev.

  Kevin

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  August 13, 2020 at 12:10 am

  #3780047

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• August 18, 2020 at 12:53 pm

  This was removed by the editor as SPAM

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  August 20, 2020 at 3:13 pm

  #3781985

  When the tlog file grows it is because it is not getting backed up. Below is an article on index and log files .

   

  https://docs.microsoft.com/en-us/sql/relational-databases/indexes/transaction-log-disk-space-for-index-operations?view=sql-server-ver15

  MCSE SQL Server 2012\2014\2016

• Kev

  Default port

  Points: 1435

  More actions

  August 21, 2020 at 5:01 am

  #3782148

  Hi

  Thanks for that info. Yes i am aware of trn backups etc.....

  My question related to TDE and 2019 Server having an effect on the size of transaction logs.

   

  Kevin