90
Hi,
Recently my co-worker asked me to find out possible options to save some space in the Dynamics environments, so here I am asking,
What could be possible ways of saving space?
Also, I would like to add that this is not going to be done on a currently being used system, just a test environment.
Thanks in advance, Emil P.
Hi,
you can use cleanup jobs to remove useless data. please refer to
community.dynamics.com/.../improving-microsoft-dynamics-performance-cleanup-jobs
Best Regards
Are you asking about the database footprint or the AOS server?
On the database, you could probably clear certain tables like SMMTRANSLOG and BATCHHISTORY.
You could make sure your DB LOG is as small as possible by shrinking it and setting the DB option to simple recovery.
On the AOS, it's more difficult to find space, but you could make sure you don't have unnecessary XPO files from previous code promotions.
1) Your model database recovery model should always be Simple.
2) Also in your business db you can usually keep the recovery model to Simple in a test system. But if it's not Simple, you need to have transaction log backup process in SQL server or the log will keep growing all the time.
Once the recovery mode is simple, you can just shrink the log to 0, that's it.
You can speak with your DB admin or search the web if you need more details about transaction logs, recovery models or other db related stuff.
Remember that my advice regarding the business db settings applies only in test system, not in a live system!
Hi Nikolaos,
I personally have not worked with databases that much, i generated a report for disk usage:
-data files space reserved is only 1Gb, so its not like We can save some space there,
-transaction log space reserves about 200 Gb, and has 100% space used,
I saw some tutorials about shrinking the transaction log, is it safe, is there something important I should know before actually trying?
I guess you mean database space.
You can start by looking at the biggest tables of your database (via SQL Server report) and check if there's something that you don't need. Quite often you have batch history, database log, event inbox and other stuff that you should clean up even in prod system. And in test you could perhaps just truncate those tables.
Additionally check if your data / log files have a lot of unused space, and shrink the files accordingly.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (