AWS DMS(Database migration service) causing the DB log file usage to increase

Question

I am seeing issues wherein the sessions that run from the AWS DMS service go into sleeping state resulting the DB log file usage to increase and we are unable to shrink the log file due to this. DMS service was stopped to resolve the issue. Could some one please advise if they came across this issue and what needs to be done to resolve the same.

Thanks in Advance!

Answer 1

You should probably inquire in an Amazon forum about their products.

But I get a little worried when you say "we are unable to shrink the log file due to this". Why would you shrink the log file in the first place? That's a very exceptional thing to do.

Answer 2

Hi @Kranthi DBA ,

Log for AWS DMS migration task growing? If so, please post your issue on AWS Database Migration Service forum, people there will give you a better help. SQL server general tag that talking about issues about MS SQL server.

By the way, check if below log could help you.

Introducing log management in AWS Database Migration Service

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Answer 3

Hi @Kranthi DBA ,

>It i s the SQL log file that is growing in size.

If you want to reduce the log file size. You need to find the reason that why the log file growth rapidly, then shrink the SQL log file to reduce the log size.

Normally we follow the steps below to shrink SQL log file:

1. Perform full backup of database
2. Perform transaction log backup
   sometimes, we have to perform multi transaction log backup before the transaction log could be shrank.
3. Shrink transaction log
   if the transaction log cannot be shrank, please execute the following statement to check why the transaction log cannot be shrink:
   SELECT log_reuse_wait_desc FROM sys.databases WHERE name='<database name>'
   if the result is other than NOTHING, please perform corresponding operation. Then please try step 2 and 3 again.