Browse by Tags

All Tags » performance » i/o » wait
  • ASYNC_NETWORK_IO: query is slow

    When you run normal SELECT statement from the Activity Monitor, the session has a status of ''suspended'', a command of ''SELECT'' and a wait type of ''ASYNC_NETWORK_IO''. What do you expect to the see the results and within the column status, we will see quite a few requests which are in the status ‘suspended’ and some others as ‘running’. The ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on August 29, 2007