Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

connection is very slow

Status
Not open for further replies.

magi

Programmer
Nov 20, 2001
13
US
hi
im using ms access data project to connect ms sql server, suddenly since today my connection to sql server is slow, i mean my application is acting slow while retreiving data into forms etc, anyone know what the problem is

thank u
 
I'm not aware of any psychics on Tek-Tips. It is difficult to guess why a system is slow. There are many factors and the only way to find the reason for slow performance is to analyze what is happening. Here are some items to monitor.

1) Processor usage on the server. Are the processors maxing out?

2) Network activity. Is there a lot of network activity that could slow data transfer across the network? Have you talked to network people about recent changes?

3) Are the SQL tables properly indexed? Are statistics up-to-date?

4) What is the SQL cache buffer hit ratio?

5) Does the slowdown occur on one or multiple PCs?

6) Is there any blocking occurring on the SQL Server? Are applications holding locks on tables?

Ther are many other factors. Start with these. Check the following link for more SQL performance resources.

Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top