table scan stopped

  • In live environment which is having sql server 2008 R2, table scan stopped for certain period of time. Please let me know possible reasons for table scan stopping.

  • Locking? Deadlock?

    What do you mean with table scan?

    Did you use a SELECT statement in a query?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • What exactly do you mean?

    The query was doing table scans and now isn't? Something else?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • do you mean its timing out?

    ---------------------------------------------------------------------

  • Blocking caused by another process doing an INSERT/UPDATE/DELETE which will stop the scan.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply