BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

MS Sql 2000 -- Federated model


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
sbauer
Senior Member
Senior Member



Joined: 31 Mar 2006

Posts: 76
Location: VA


flag
PostPosted: Fri Mar 31, 2006 2:19 pm 
Post subject: MS Sql 2000 -- Federated model

Is anyone using the sql server 2000 federated model, using distributed partition views?

I am getting some inconsistant results, and AWFUL runtimes when accessing data through the distributed partition view, even though I am passing the complete key that will 'drill down' to the appropriate machine/table/index. The query plans look good.... but things run poorly. When I create the sql to directly access the table on the machine in question, bypassing the distributed view, things run well.

Any other experience with this?
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10593
Location: Germany


flag
PostPosted: Fri Mar 31, 2006 2:32 pm 
Post subject: Re: MS Sql 2000 -- Federated model

You might want to ask that in the BO report section, not the Data Integrator part of the forum!
_________________
Werner Daehn
ex Product Manager Data Services at SAP SE

www.rtdi.io
Back to top
sbauer
Senior Member
Senior Member



Joined: 31 Mar 2006

Posts: 76
Location: VA


flag
PostPosted: Fri Mar 31, 2006 2:34 pm 
Post subject: Re: MS Sql 2000 -- Federated model

Why?? I am running Data Integrator loading to a federated model. This is not a reporting question (I don't think).
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10593
Location: Germany


flag
PostPosted: Fri Mar 31, 2006 4:26 pm 
Post subject: Re: MS Sql 2000 -- Federated model

icon_redface.gif
_________________
Werner Daehn
ex Product Manager Data Services at SAP SE

www.rtdi.io
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0276 seconds using 17 queries. (SQL 0.0028 Parse 0.0009 Other 0.0239)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo