Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Chicago
    Posts
    2

    Unanswered: Poor Performance On Cross-Server Join

    Was running cross-server queries between SQL65 and SQL2000, query ran fine. Upgraded the SQL65 server to SQL2000, the cross-server queries starting running extremly slow. Nothing has changed but the upgrade to SQL200, can some one help why my cross-server queries are taking so long.

  2. #2
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    perhaps delete & recreate the linked server definition (if it is the same one as created to the 6.5 server)

  3. #3
    Join Date
    Sep 2003
    Location
    Chicago
    Posts
    2
    Actually, after my search for info on this found nothing, I dropped and recreated all the links between the two servers and that did fix the issue.

    So your advice was a good one

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •