Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Analyzer
Posting Yak Master
115 Posts |
 Posted - 2007-09-06 : 10:53:28
|
| Calling any OLAP Guru's. Were attempting to improve a vendors BI process which involves running MDX queries against our SSAS cube, then saves the data into their own proprietary database which is taking to long.We currently run this process on a x16 CPU, 65GB top end server attached to expensive disk subsystem, however a dual-core processorlaptop completely out performs the expensive hardware by around 45% quicker. Both when the configuration is identical or when we ramp up the processes on the expensive hardware it still performs miserably compared to the laptop. Perfmon counters or Profiler don't so much difference when comparing the server and laptop. Does anyone know why the laptop completely outstrips the expensive top end hardware perfmance wise although the configuration profile is identical? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-06 : 22:42:11
|
| Do you run sql and AS on same machine? Does laptop have cube and db on it or it connects to remote server? |
 |
|
|
Analyzer
Posting Yak Master
115 Posts |
Posted - 2007-09-07 : 04:38:53
|
| The considerably better performing laptop consists of SQL, AS, vendors BI app. Our prod servers were made up of seperate SQL, AS and application machines. Testing has since substantiated when the vendors BI app is installed on the same AS machine, performance is excellent. This means there is performance issue when data is transfered across our network from AS to application server, the root course of this is still undentified since no other network issues have surfaced |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-09-07 : 12:20:34
|
| What are your network card specs....and settings (which could be "under defined")? |
|
|
|
|
|
|
OLAP Performance Mystery