Browse by Tags

• disks
• performance
• sql server
• tuning
• type
• wait

ASYNC_NETWORK_IO: query is slow
29 August 07 03:00 AM | SQL Master | 2 Comments   

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 Read More...

Filed under: tuning, performance, sql server, wait, object, i/o, disks, type