SQL Activity Monitor Resource Waits

Posted on 2011-05-10
Last Modified: 2012-05-11
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
Question by:polaris101
    LVL 2

    Expert Comment


    This talks about Network IO waits and access specifically.

    Author Comment

    Thanks VOSSJCK - I'm more interested in the locks now.  Any info on that?
    LVL 21

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now