Finance | Project Operations, Human Resources, ...

Database Log file size

(0) Share

Report

Posted on by Community Member

Dear Folks,

We implement D365 on premises around one and half year ago, till last two month data base size was around 15 GB and log files were around a120 GB. drastically now it is increased to database size to 55 GB and log files around 1 TB.

we have physical server which is going to out space due to this issue.

any help you can provide to analyze this change.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

vinitgoyal2005 6,332 on at

Like (0)

Report

Hi,

User SQL scripts like here stackoverflow.com/.../7892349 to analyze the data in SQL. If you use BYODW exports a lot, then use the cleanup jobs d365foe.blogspot.com/.../how-to-configure-cleanup-of-data.html

For Logs, check link www.sqlshack.com/.../

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report
Hi Naveed Nawaz,

Please check your backup strategy.

Usually,transaction log backup should be ran in frequent intervals (5-15 minute intervals is fairly common).

You could check if there is any long running transactions happening:
SELECT DB_NAME(dbid) AS DBNAME, (SELECT text FROM sys.dm_exec_sql_text(sql_handle)) AS SQLSTATEMENT FROM master..sysprocesses WHERE open_tran > 0

In addition to what Vinit mentioned, also you could use DBCC SHRINKFILE statement to shrink log file size.

docs.microsoft.com/.../manage-the-size-of-the-transaction-log-file

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Naveed,

What happened last month?

If I read your data correctly then suddenly the db size increased almost by the factor 4 and the log file size by 10.

Were there some major changes implemented? New programs, changes in the configuration, etc.?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

A.Prasanna 8,223 on at

Like (0)

Report

Check whether your backup schedules are running and Check Log file settings. also chek that have you or anyone changed Log file Autogrow/Max Size settings recently .

use this for check Log file usage status : www.mssqltips.com/.../,

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Naveed,

Like mentioned above, check the backup schedules. Check also the auto cleanup options for older backups. The backup may fail due to insufficient diskspace. If the backup failed, the auto shrinking will not work, which causes growing log files. I have also seen the insufficient disk space when a user parked a very large file on the same disk as used for the backups.

Was this reply helpful? Yes No