Re: SQL Server 2000 SP4 - ODBC Performance issues

It may not necessarily be an ODBC performance issue. Have
you tried looking at the execution plans for the queries
that are causing the problems?
You can use profiler to monitor the activity and identify
the worst performers, CPU use if that's the concern.
They query plans may have changed on SP4 and that could be
what's contributing to your issue.
You may also want to monitor the waittypes by querying
sysprocesses and wait stats using dbcc sqlperf(waitstats).

-Sue

On Wed, 5 Oct 2005 03:30:02 -0700, "Deanw"
<Deanw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Server is quad processor with 3 gig of RAM of whcih 2 gig is allocated to SQL.
>Last weekend we upgraded the SQL from SP2 to SP4, since then the ODBC
>queries trhey run via MSQUERY appear to be really hitting the CPU and
>sqlserver.exe is consuming up to 90% of the CPU. It is looking very much like
>the ODBC queries are the cause, they reference a view in the database that is
>made up of a number of selects from a number of databases joined by the union
>command. Is anyone aware of any issues with SP4 that might effect this ? The
>DB server is now using MDAC 2.81 since the upgrade and we have ensured the
>clients are also using MDAC 2.81 as well

.

Relevant Pages

  • Re: Simple query executes fast but renders slow...
    ... After you restart Access and run your query, JET will write an extensive log ... "SQL Queries for Mere Mortals" ... >>Then I wrote queries and reports based on the local ... So, ODBC, right? ...
    (microsoft.public.access.queries)
  • Re: Need ODBC for every front end, or just server?
    ... > Backend, do I lose ALL benefit of having the application split into Front ... used only for the update from ODBC. ... Queries can be run from VB Script. ... > on the server, and, in response to some other signal ...
    (microsoft.public.access.externaldata)
  • Re: oledb-group by
    ... SQL92 rules in queries with GROUP BY. ... > then I set engine behavior to 70 just after opening connection. ... Since the latest ODBC driver only has the SQL ... >> select band, title,; ...
    (microsoft.public.fox.vfp.dbc)
  • Re: Simple query executes fast but renders slow...
    ... Then I wrote queries and reports based on the local versions. ... So, ODBC, right? ... > I've spent a lot of time on a PC running Access Queries against a DB2 ...
    (microsoft.public.access.queries)
  • Re: SQL queries are slow in SQL Server 2005 when compared with SQL Server 2000
    ... For the below mensioned queries the execution plans are similar just only ... plans it might be changed as sql server engine is changed meaning the ... SELECT Int_Key FROM fDocHst ...
    (microsoft.public.sqlserver.clustering)
Loading