Have you tried slipstreaming SP1 and performing the install with that already on? It might resolve this.

Check out http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx for slipstreaming sp1 onto the SQL2008 RTM.

I tried the manager route for a while and ultimately decided it was not for me. I would go home at the end of the day feeling that I accomplished...

Get the MCTS BI Dev/Maintenance 2008 out of the way before it kills me (why I cannot wrap my head around SSAS I have NO idea). Then I can get...

No argument there. In fact I would have loved to setup a dblink from Oracle to perform that task however trying to set one of those up against a 64bit...

Gift Peddie (12/10/2009)

I never had issues using DTS with either Oracle or DB2 so when the problems came up with SSIS just worked through it. Here is the blog...

Back in the good old days (DTS) we did the same thing. Thought I would be smart (well try to be cool) and do it in SSIS. Until that connector...

After much pain I have a solution....download the Attunity Oracle connector from http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en

Had to redo the datapumps, however went from 40 minutes to under 60 seconds!!! :w00t:

I don't have the 11G client installed (although I am testing on another machine and seeing the same performance issue). Windows is running SP2, so no issues there.

I don't have...

If you can perform a side-by-side upgrade with new hardware then you will be infinitely better off. For a start this allows you to perform multiple cutover tests (and multiple...

It happens though. Been there, done that.

No worries, let us know what you find.

Set lock pages in memory and see if that makes a difference as regards the paging.

Ouch, that's brutal, they give you all that hardware and then cripple you (ok, not cripple but kinda ruin the fun a bit)

How many distribution agents are running on the...

What are your min/max settings for SQL? (I'm guessing that you are running the x64 versions of the OS and SQL and so PAE/AWE/3GB are not factors)

Jeffrey Williams-493691 (11/5/2009)

SQL Server should not be paging at all - if it is, you have problems...