Analysis Services MaxFileSize and MaxNumberOfLogFiles

ANDREA SORIA 1 Reputation point
2021-02-23T21:46:57.307+00:00

I need to limit the size of msmdsrv.log file and clean up a certain number of old logs according to documentation for MaxFileSizeMB and MaxNumberFiles.
I followed the steps on https://learn.microsoft.com/en-us/analysis-services/instances/log-operations-in-analysis-services?view=asallproducts-allversions#bkmk_msmdsrv but it seems that it does not work.
I set them for example to:
MaxFileSizeMB = 1
MaxNumberFiles = 3
After modifying this configurations I also restarted the service and It created files with about 10 MB and keeps all old files.
Is there any other configuration to be done to have this working?
Is something that I could check ?

Thanks in advance

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-02-24T06:47:47.503+00:00

    Hi,

    You need to check the XML configuration you have made, check if you have committed exact same property name and number for your need.

    For what I see, it should be

    <MaxNumberOfLogFiles>3</MaxNumberOfLogFiles>

    Instead of "MaxNumberFiles"

    Regards,
    Lukas