64bit to 32bit connectivity

Main Point: Views I have on my 64bit server will UNION ALL to my 32bit server
to gather core data. The 32bit server view needs some staic data
(CountryCode) so it INNER JOINs back to the 64bit server to get the staic
data. This is extremely slow. On my 32bit => 32bit server it works fine, but
on this new 64bit => 32bit server it's dog slow.
Details:
My 32bit server has SP3a and the InstCat.sql from the 64bit
\SETUP\IA64\Install directory, I can now call my stored procedures that use
distributed views.
My previous server setup was:
Primary = OS Window Advanced Server 2000 32bit; 32bit SQL Server Enterprise
Secondary = OS Window Advanced Server 2000 32bit; 32bit SQL Server Enterprise
32bit Server (Primary;One Year of Data) + 32bit Server (Secondary; Seven
Years of Data)
My new server setup is:
Primary = OS Window Advanced Server 2000 64bit; 64bit SQL Server Enterprise
Secondary = OS Window Advanced Server 2000 32bit; 32bit SQL Server Enterprise
64bit Server (Primary;One Year of Data) + 32bit Server (Secondary; Seven
Years of Data)
The big problem: The views on the 64bit machine (64Views) UNION ALL to the
views on the 32bit machine (32Views) to allow me to retrieve data from both
machines. The concept of distributed views won't be discussed here for
brevity. These work fine.
But, as soon as I add to the 32Views, the SQL code that will INNER JOIN to
the CountryCodes static table on the 64bit machine it takes "forever"; 28
minutes to return a handful of records (162 to be exact). The reason for
doing this because I only want one location to store CountryCode details and
the 64bit machine is the primary machine to update these. I do have them on
the 32bit machine and I could change all my production machine databases to
look there, but I don't want to have to deal with this.
Tests:
On my previous setup of 32Views => 32Views => 32CountryCode, it works fine.
On a test of 64Views => 32Views, it works fine
Now, on the new setup of 64Views => 32Views => 64CountryCode, it is DOG SLOW.
Anyone help me. If you need some code I can probably put together a small
sample (instead of my big view sets). I will plan on that, but thought I
would at least get the question out into the newsgroup.
--
dbArchitect
Greg L. Wright"dbArchitect" <dbArchitect@.discussions.microsoft.com> wrote in message
news:EE5AFA0D-BE0C-43F6-B4AE-37D52498A6B2@.microsoft.com...
> Main Point: Views I have on my 64bit server will UNION ALL to my 32bit
> server
> to gather core data. The 32bit server view needs some staic data
> (CountryCode) so it INNER JOINs back to the 64bit server to get the staic
> data. This is extremely slow. On my 32bit => 32bit server it works fine,
> but
> on this new 64bit => 32bit server it's dog slow.
>
Apart from figuring out why this is slow (or figuring out how on earth it
was ever _not_ slow), this seems like a case for replicating the static data
to the 32bit servers. You could use one of the built-in Replication types
or just schedule a job that runs
insert into CountryCode
select * from 64bitServer.MyDB.CountryCode
David