Results 1 to 4 of 4

Thread: Linked Servers

  1. #1
    Join Date
    Oct 2002
    Location
    BC Canada
    Posts
    61

    Unanswered: Linked Servers

    We are creating a newServer grabbing data from an extrnal data source.

    We need to perform regular audits to verify the record counts (for now) are the same.


    We have 2 physically separate SQL servers 1 with old 1 with new.

    I have created a linked server but when i do a query on the linked server the performace is pathetic (2mins 12 secs) to do a simple count.

    Is there a better way, or can improv the perf?

    Thanks
    Greg C

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Something is grieviously broken, but I don't have enough information to tell you what is broken or how it should be fixed.

    The first step would be to attempt the same query the new server using Query Analyzer. The purpose of this step is to determine if the problem lies in the connection between the two machines or within the SQL Server itself. If the query runs poorly in Query Analyzer, then the problem is in the connection between the machines (something is impeding SQL communications between them). If the query runs acceptably in Query Analyzer but does not using the linked server, then the problem is in the linked server.

    -PatP

  3. #3
    Join Date
    Oct 2002
    Location
    BC Canada
    Posts
    61

    Linked Server

    Yep thanks, field i was counting wasnt indexed.. thanks

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    That would be what we call a "bad thing" for lack of a better term! I'm glad to know that the answer was so simple.

    -PatP

Posting Permissions

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