Solved

Linked Table Slow

Posted on 1998-08-19
1
181 Views
Last Modified: 2010-03-19
I am connecting to SQL through OBDC from MSAccess.  I have approx. 50 machines that will be using the SQL. There are currently about 15 machines on SQL. about 25% of them run very fast. the other 75% run very slow.  All the odbc settings are the same, all the SQL drivers are the same. It seems to be computer oriented.  The same machines run fast no matter what scenario.  What network protocol should I be running and would this make a difference.
0
Comment
Question by:rvindust
1 Comment
 

Accepted Solution

by:
bmccaig earned 20 total points
ID: 1089630
What you might be running into is a network protocol problem.  I have seen similiar problems where the client was running IPX, TCP/IP and NetBeui.  Unless you have specific needs (i.e. connecting to a Novell server) then I won't run IPX.  NetBeui should do the job for you just fine.  You can also run TCP/IP at the same if you need it (for Internet connectivity and the like).  You will also need to make sure that your NT server is running the NetBeui protocol.

Also, some performance differences can be measured by the hardware.  For example, a pc with a Pentium II 400 is naturally going to run things faster than a 486.  Another difference might be the amount of memory each workstation has.  If some of the workstations have less than 32 meg memory, you could be running into a situation where the operating system is spending time swapping in and out from virtual memory.

I hope this helps.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL LINE CONTINUATION ISSUE 12 32
Linked Server Issue with SQL2012 3 24
SQL Server 2012 - Merge Replication Issue 1 20
sql server service accounts 4 22
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question