SSAS connections are not happening through msmdpump.dll while doing the load tests. What to do?

sathish hanumandla 0 Reputation points
2024-10-16T07:20:28.5433333+00:00

Hi All,

We are performing a 1 hour load test of 300 users and 370 users on SSAS and we are seeing that application is working fine under 300 user load. However, when we are conducting 370 users test, in the first 20 minutes CPU was getting occupied 100% and after 20 minutes, the CPU suddenly dropped to 1-5% till the end of the test. I tried to login to SSAS through SSMS tool and I was not able to connect to it using pump.dll. However, the connection is happening quickly directly using server name. we have even tried to increase the connectionpoolsize setting in msmdpump.ini file. But we still seeing the issue. Is there anything I need to check further from IIS or any other settings I need to consider to avoid this behaviour

Internet Information Services
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,285 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.