Post reply

Slow query to Linked Server

  • September 18, 2008 at 3:28 am

    #92488

    Server A is a Prod SQL 7.0 server

    Server B is an MI SQL 7.0 server

    Server C is the linked SQL 2000 server

    Server C has just been moved to a new SQL 2000 server. All was fine before this.

    Server A and B both fire the same query to Server C

    Now Server A takes several minutes to run a query that runs on server B in 1 second.

    The query has no joins and does no update. i.e.:

    SELECT TOP 2 cols FROM ServerC.db.dbo.table WHERE index = "id"

    If I add a second condition it takes forever.

    Any thoughts would be appreciated.

  • September 18, 2008 at 3:50 am

    #873468

    Sorted. Set Collation Compatible on the linked server on Server A and it's fine. Not sure why, as collations are exactly as they were before and it's not set on Server B, which has the same collation as Server A.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply