Re: Very slow access using MDAC2.8

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Val Mazur \(MVP\) (group51a_at_hotmail.com)
Date: 03/10/05 

Date: Wed, 9 Mar 2005 19:56:43 -0500

Hi,

I do not think performance related to the version of MDAC. Do you have exact
same indexes for the tables on all SQL Servers? If index is missing and
table is huge, then it could affect performance. It also could be a slow
connection to the linked server. 

-- 
Val Mazur
Microsoft MVP
http://xport.mvps.org
"Adam" <Adam@discussions.microsoft.com> wrote in message 
news:88D754E3-B0CE-457B-B525-31921AC2A236@microsoft.com...
> Hi,
>
> I have a stored procedure that gets data from another SQL server (it's a
> linked server). The database on which the data is requested from is 
> Windows
> 2K and SQL2000 SP3, using MDAC2.7 SP1.
> From 2 remote machines, both with MDAC 2.7 SP1, SQL 2000 SP3 and Win 2K, 
> the
> query runs fine, and return a result in less than a second.
>
> However, 2 other machines, one Windows 2K3 the other XP, both with SQL2000
> SP3 and MDAC 2.8, the query takes about 5 minutes to run (I print the date
> and time before and after the query).
>
> Using the trace facility of Query Analyser, it can be seen that the line
> taking the time is indeed the one accessing the linked server.
>
> Anyone any ideas?
>
> Thanks
>
> Adam

Relevant Pages

  • Re: Very slow access using MDAC2.8
    ... It is not part of a multicolumn index. ... The query is being run from different servers, but all the data is on one ... the worst affected server (and the one I want ... > connection to the linked server. ...
    (microsoft.public.data.ado)
  • Re: Server: Msg 7399
    ... linked server, but when I query them the below error occurs. ... server works fine on my development server. ... OLE DB provider 'MSDAORA' reported an error. ...
    (microsoft.public.sqlserver.connect)
  • Re: Error in Stored Procedure when trying to query another linked server
    ... > use Query Analyzer to create this stored proc. ... > Microsoft SQL Server Support ... > Please reply only via newsgroups, as I rarely reply to email. ...
    (microsoft.public.sqlserver.programming)
  • RE: SMS Reporting with linked DB
    ... Create a linked Server on the SMS 2003 DB. ... Running the query in Query Analyzer works fine, ... > Native Error: 7405 ...
    (microsoft.public.sms.tools)
  • Re: Rolling out structural changes to a distributed SQL environment
    ... We pop a job on all the destination SQL servers that execute a payload. ... > script that pushes a job and set of scripts out to each server. ... this is a poor man's solution in the absence of a fancy tool. ...
    (microsoft.public.sqlserver.replication)