Home Forums SQL Server 2008 SQL Server 2008 - General Very interested to know what can be done in the case of a long running select query RE: Very interested to know what can be done in the case of a long running select query

  • Would need to look at the exec plan to say anything useful. Could be a bad execution plan for one reason or another and the query is just running and running.

    Async network IO is usually an application problem, maybe take this up with whoever developed the system that is running the query.

    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