Post reply

Script hanging

  • April 20, 2011 at 4:54 am

    #1313840

    Take a look at sys.dm_exec_requests and sys.dm_os_waiting_tasks and you can tell exactly what the process is waiting on and if it's blocked.

    "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

  • April 20, 2011 at 11:20 am

    #1314125

    Thanks.

    We did that and it seems like there is a Citrix server connection who seems to be the blocker. We will try to stop that connection when possible an give it a try.

    Thank you

Viewing 2 posts - 1 through 3 (of 3 total)

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