News and Announcements icon

Dynamics 365 CommunityForums Supply Chain Management forum Database Capacity FSCM...

Supply Chain Management forum

Suggested answer

Database Capacity FSCM / PowerPlatform

(1) Share

Report

Report

Posted on by CU06060545-0

6

Hi All,

I need your swarm intelligence...

Following Situation:

We have several D365FSCM Environments created via LCS.

I Also can see these Environments within PPAC:

The marked Environment is just a Test - Environment where we truncated some Tables with some trash data today in the morning. Now, about 4 hours later, I still see this usage. We truncated data with about a usage of about 50GB.

So I requested Access to the SQL - Database via LCS and had a look to the used Storage. The Storage is still as high as seen within the image above.

I'm not able to shrink the Database or something else.

Am I making a mistake? Or does it take more time to maintainance and refresh in background?

Categories:

Dynamics 365 Administration

All responses Img

All responses (3)

Answers Img

Answers (0)

Anton Venter 6,730 Super User on at

Like (0)

Report

Database Capacity FSCM / PowerPlatform

Great, good to know it is reduced autmatically.
Suggested answer

CU06060545-0 6 on at

Like (1)

Report

Database Capacity FSCM / PowerPlatform

Hi Anton,

thanks for answering my question.

Meanwhile the size was reduced.

I just had to wait :)
Suggested answer

Anton Venter 6,730 Super User on at

Like (0)

Report

Database Capacity FSCM / PowerPlatform

Hi,

Deleting data in the database does not automatically reduce the size of the database files and log files. It seems to be case, so I am assuming this.

If the size of the database files / log files is not reduced automatically, you will have to try and shrink the database and the database files / log files. I have not tried this on Tier 2 environments so don't know if it's even possible or not. Many options have been locked down on the Tier 2 environments.

Helpful resources

News and Announcements

Just out! June 2024 Dynamics 365 Community Newsletter

Community forum and blog attachments are now available!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 284,877 Super User

#2

Martin Dráb 225,425 Super User

#3

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans