SSAS – MSMDPUMP.DLL failing occasionally under high user loads

Hi,

Recently in one of our systems, we started experiencing that the cube which were hosted out by the use of MSMDPUMP.DLL, on some occasions responded with failed request during the high load by multiple users.

And researching for the same, provided us with the following steps with which we were able to restore the service normal for the wide users of the system.

In the msmdpump web hosted folder locate the “msmdpump.ini” file and add the following entries to the same

<MinThreadPoolSize>0</MinThreadPoolSize>
<MaxThreadPoolSize>0</MaxThreadPoolSize>
<MaxThreadsPerClient>20</MaxThreadsPerClient>

And in the IIS which hosted the msmdpump we made the following changes to the app pool settings

CropperCapture[1]

and eventually resetting the IIS, resolved the issue.

Hope it helps !!!

One Reply to “SSAS – MSMDPUMP.DLL failing occasionally under high user loads”

  1. Thank you for the tip!
    Adding the 3 lines in the msmdpump.ini file solved our issue we had in Power BI: Can’t load visual…
    Thanks again

Leave a Reply

Your email address will not be published. Required fields are marked *

*