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
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.