poor preformance usinng sql 2005 with access 2003 application

Hot Topic

Please post setup and installation questions in the Setup forum
SQLCLR 32-bit Vs 64-bit
Where to put DISTINCT in a CTE?
SSIS does not recognize CRLF as the en of line
Attach database - error 602
SQL Server and Local Account Login
Advanced Lookup in a Data Flow
Documentation
How to enforce SQL Server 2005 to use Worktable?
Stuck between "Failed to generate user instance" and "An attempt to attach...failed"

SQL Server

Force at least one parameter (2K5)
Need all rows within each group to be shown on 1 page
How to use variables for server connections
Here is an error that I get when running a DTS package.
Erasing digit
Database Snapshot Disk IO considerations and Best Practices
OUT and OUTPUT - Stored procedure parameters.
SQL Server Service Pack 2 Released
Dynamically changing task name displayed within ForEach Loop Container
OLE DB Destination not writing data

poor preformance usinng sql 2005 with access 2003 application

we have run access 2003 application using SQL 2005 server
and the data transfer rate is extreamly slow.
we are using ODBC connection
and the access apllication works very fast with SQL 2000.

we have the tested the comptabilty of the application to SQL 2005 with Microsoft wizard and it had no problems.
even when i run simple application on the sql 2005 server, it runs very slowly.

i am using the MDAC clients ODBC component and the SQL Native Clients one.
which eliminates the possibilty of network problem.

what could be the problem



Answer this question

poor preformance usinng sql 2005 with access 2003 application

  • Kiran Pillai

    Most likely the problem is improper indexing on the SQL Server side. Typically the driver used is not going to have a huge impact on overall performance. The simplest way to verify if you have index issues is run your application against SQL 2005 and capture a SQL Profiler trace of the activity. Then take the profiler trace and run it though the "Database Engine Tuning Advisor" tool that comes with SQL 2005 and it will analyze the trace and make recommendations as to what indexes to build.

  • poor preformance usinng sql 2005 with access 2003 application
Answer this question