SSAS 2008 slow multiple partition processing

[Joe Sampino]

Hi all,
I’m working on a conversion from SSAS 2005 to 2008. I'm getting extremely
poor performance when processing multiple partitions simultaneously.

I’m using the oracle 64 bit client for 2008, and if i process a single
partition on 2005 and 2008 they complete in almost identical time.

However, when i process 10 partitions in parallel, the difference is huge.
The 2008 box, which is far superior, takes 102 min while the inferior box
with 2005 takes 43 min. And no, i have not set the processing to sequential.

Any suggestions?

Thanks,
--Joe

[Joe Sampino]

some more info...the new server is "server 2008" which required using a new
64 bit Oracle driver. has anyone seen good processing speed with mutliple
threads using this new driver?

[Joe Sampino]

Found the solution:
The issue was the oracle driver. We are using a Server 2008 64 bit OS which
required a new oracle driver. The Server 2003 64 bit driver does not work on
the new OS.

The one we used was 10.2.0.4.0 and it would not spawn multiple sessions in
Oracle. Our local Oracle guru suggested using the 11g driver, 11.1.0.7.0,
which has been tested with server 2008 and is backward compatible.

It works fine now.

[Classiarius]

On Nov 9, 5:17 pm, Joe Sampino <JoeSamp...@discussions.microsoft.com>
wrote:

Late to this thread. Joe, it sounds like you've found the right
solution for your Oracle performance problem, but on a related note,
I've found the Microsoft Connectors for Oracle for SSIS far superior
to the standard Oracle source or destination within SSIS. Similarly,
my setup is SQL Server 2008 on Windows Server 2008, all 64-bit. This
might be useful to other who need to copy the Oracle data to MS SQL
Server to transform before OLAP can be done.

http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en