lock: timeout in Profiler

Posted on 2004-11-11
Last Modified: 2008-03-17

I was trying to trace timeouts in Profiler on a particular database.
Using the lock: timeout parameter I would get timeouts with a LoginName of 'sa'
there would be an ObjectID, StartTime, SPID and nothing else.

sa isn't used by any process in this app and nothing else runs on the server.
All db options except AUTO_UPDATE_STATS have been turned off and I that
isn't even running when this happens.

I checked a few of our other SQL Servers and databases and the same thing
happens there too.

Why is this happening?
Question by:jhachmann
    1 Comment
    LVL 34

    Accepted Solution

    if you do a SP_WHO in query analyzer, I think you will find that several connections do show up with the SA account (lazy writer, etc)....

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Suggested Solutions

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    794 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

    14 Experts available now in Live!

    Get 1:1 Help Now