server to sybase database

Hi
I created linked server to sybase database using adaptive server odbc driver.
But the performance sucks while loading large tables even after manipulating
performance tab in odbc driver.
Can anyone suggest some tuning work on linked server environment to sybase.
Thanks for your wonderful help
Praveen MohanAlso, it can be really revealing to look at the query plan when you go against a linked server. Some
manual optimization can be applied using OPENQUERY instead of 4-part table naming. For example,
pushing a WHERE predicate inside the OPENQUERY function to you know for sure the filtering is
performed at the remote site.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:3D332524-E849-4449-B2BD-15BB443BE6F1@.microsoft.com...
> Hi
> What do you regard as "suck"?
> If you are pulling 1'000'000 records, you are limited by your network
> performance.
> How many records are you dealing with? is the linked server a part of a JOIN
> query?
> Regards
> Mike
> "PraveenMohan" wrote:
>> Hi
>> I created linked server to sybase database using adaptive server odbc driver.
>> But the performance sucks while loading large tables even after manipulating
>> performance tab in odbc driver.
>> Can anyone suggest some tuning work on linked server environment to sybase.
>> Thanks for your wonderful help
>> Praveen Mohan|||Hi
What do you regard as "suck"?
If you are pulling 1'000'000 records, you are limited by your network
performance.
How many records are you dealing with? is the linked server a part of a JOIN
query?
Regards
Mike
"PraveenMohan" wrote:
> Hi
> I created linked server to sybase database using adaptive server odbc driver.
> But the performance sucks while loading large tables even after manipulating
> performance tab in odbc driver.
> Can anyone suggest some tuning work on linked server environment to sybase.
> Thanks for your wonderful help
> Praveen Mohan|||Praveen
Can you describe how did you do that?
I am having the problem with setting up my connection so your input will be
very helpfull.
Thank you, Gene.
"PraveenMohan" wrote:
> Hi
> I created linked server to sybase database using adaptive server odbc driver.
> But the performance sucks while loading large tables even after manipulating
> performance tab in odbc driver.
> Can anyone suggest some tuning work on linked server environment to sybase.
> Thanks for your wonderful help
> Praveen Mohan