• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 547
  • Last Modified:

SQL Activity Monitor Resource Waits

I have an MS Access 2007 application using ODBC to connect to a SQL 2008 backend.  I'm beginning to use the SQL Activity monitor because end users are complaining of sluggish performance.  At one point this is what I saw- see attach;  

Is Access causing this?  Would these Locks cause many of the end users to see performance problems at the same time?? What is the next best step to troubleshoot? SQL Perf
0
polaris101
Asked:
polaris101
1 Solution
 
vossjckCommented:
http://www.confio.com/English/Tips/Async_Network_IO.php

This talks about Network IO waits and access specifically.
0
 
polaris101Author Commented:
Thanks VOSSJCK - I'm more interested in the locks now.  Any info on that?
0
 
mastooCommented:
You might start by isolating performance to either the client, network, or server.  During slowness, use taskmgr on a client to watch cpu; your choice of tools to look at network throughput between client and server; and your choice to look at server cpu.  Access can easily drag too much data down to the client, saturating the network or the client cpu.
0

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now