| T O P I C R E V I E W |
| Bruce |
Posted - 11/01/2007 : 10:02:45
Is there any suggested minimum PC we should have? I have been running for a while, but noticed that different computers seem to pull of reports quicker than others. Our IT person says as long as the PC can use IE explorer, it is good enough. They claim the server is doing all the work.
However I suspect that certain machines are better than than others, and if I do an OLAP report and then do the same report in OWC, the OWC takes much less time to pull for large reports.
What do you suggest we concentrate on to upgrade 1st? Ram, the server, the PC's, or something else?
Thanks for any advice can can give us.
 |
| 1 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 11/02/2007 : 22:14:59
It should be useful to indentify where the performance bottleneck is: IE (iexplore.exe), Web Server or the Analysis Services. This can be done by looking on the Memory and CPU utilization using the Task Manager or the Performance Monitor (perfmon).
You can see how well the SSAS server performs by extracting the MDX from a slowly running report (in the design mode click the MDX toolbar button). Next you can test the performance by running the MDX in the MDX sample application (SSAS 2000) or SQL Server Management Studio (SSAS 2005).
To test the web server and IE performance of the OLAP report please follow these steps:
1. Open the OLAP report design mode
2. Open click the MDX toolbar button
3. Open a slowly running report
4. Click the “Show Query Time” checkbox
5. Click Execute button
6. Look at the status bar: The “Download time” is the time it takes for IE to receive the request. “Render time” is the time it takes IE to process the data.
If the render time is bigger than the download time then getting more RAM for your client PC will probably help.
|
|
|
Report Portal
