Forum Discussion
Bad Enterprise Gateway Performance SSAS
brodtgaard I won't downplay the issue, but there will be at least some difference as the Desktop is all within your network and the service is making calls from Azure. You can see if the queries being sent back and forth are different by using SQL Profiler to watch the incoming calls. Test against Desktop and the Service for the same report pages. At minimum, it should give you an idea of where things are slow.
Thank you!
I've been analyzing the SQL Server Profiler output.
1)
I've noticed that it sometimes it can take minutes from filtering in the browser until something happens in the profiler. How to troubleshoot that?
2)
More interesting when filtering from the browser SSAS gets queries like:
EVALUATE
FILTER(
KEEPFILTERS(VALUES('Customer'[CustomerId])),
NOT(ISBLANK('Customer'[CustomerId]))
)
ORDER BY 'Customer'[CustomerId]
This query when run in Management Studio takes 35 seconds and returns all the customers from the customer dimension (about 3 million entries). My reports does not use the customer dimension!!!
It should definitely not be necessary to send these customerid’s to the front end, as the report only displays data on a much more aggregated level. That is one of the reasons to use cubes.
Why does this happen !!!?
bump
Having exactly the same problem, come on guys sort it out
bump!
