Hello, We’ve been using ReportPortal for a number of years to serve our OLAP data to our users. Recently, we’ve added a new client that is noticing extremely long response times when viewing reports on our site that contain reportportal views. There is 1-2 minute wait between changing filters, and 2-3 minute wait to stream a download file from the site to the client system. The only difference we’ve seen between this client and others is they use a proxy server. We performed a network trace and the one thing i do see are high delta times in several instances. These deltas occur between the client sending us a packet and then the client sending us a fin ack. It is as if the client does not get an answer to it's last packet quick enough so they send the fin. Then a new tcp connection is initiated.
Has anyone else ever experienced an issue like this?
The performance problem can be caused by one of three things: Server, Network or the Client. To identify the source of the problem please open OLAP report in the design mode, click the MDX button and check “Show Query Time” option, click the Execute button. The status bar below will show the download and render time in seconds. The download time represent the combination of Server and Network time where as render time represents the time it takes for the client to render the data on the screen. To see which fraction of the download time is taken up by the Server execution, please copy the MDX and run it on the SSAS server using SQL Server Management Studio.
a. The network performance can be improved by enabling the HTTP compression on the IIS server.
b. The Server performance can be improved by:
i. Partition the cube across time or region
ii. Design Cube aggregations based on cube Usage table
iii. Reduce the size of your large dimensions by elimination records not used by fact data
iv. Setup attribute relationships for large hierarchies
c. The Client (ReportPortal) OLAP Report performance can be improved by:
i. Use the Drilldown mode instead of the default Expand mode
ii. Use “Top-N” or “Bottom-N” features when looking at the detailed data.
iii. Try enabling record paging
iv. Try “Non-Empty Cross join” option. In OLAP Report design mode please go to Options > Non-Empty tab.
We have seen problems similar due to network auth delays. You would click the button and it would just sit there spinning for 30-60 sece before returning results. We were originally using NTLM but we are on a huge network with 40 odd auth servers. It had to run trhough each server to find the use user. When we setup Kerberos it solved the problem. It was a real pain but it was the only way to get the performance. We saw similar delays with Performance Point servers and other reporting systems. Not sure is this could be your problem. We have a large network with many proxies and firewalls
Report Portal
ReportPortal and Proxy Servers
Posted - 07/13/2011 : 07:02:24
