• 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
1 Solution

This talks about Network IO waits and access specifically.
polaris101Author Commented:
Thanks VOSSJCK - I'm more interested in the locks now.  Any info on that?
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.

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