Sample Header Ad - 728x90

High ASYNC_NETWORK_IO when user locks computer with Excel open

3 votes
1 answer
2482 views
I have a user who gets in at 8AM and leaves at 6PM every day, and every day I see the same strange pattern in SolarWinds DPA. It seems that Excel is refreshing the Query Table when the user locks their screen. My questions are: 1. Is there any way to stop Excel from doing that? I can't be the only DBA who has fought such problems. 2. Is there any way I can reproduce the problem on my machine? 3. Help finding Google keywords to search for a known issue... I've tried unsuccessfully High Async Network IO from Excel *UPDATE* It occurred to me there could be other factors at play here, so here goes: 1. The file is on a Network-Attached Storage Drive shared among a work group. 2. I looked into various Network Interface Card powersaving feature issues that could be causing Excel to think the file handle is lost (???) 3. "Refresh data when opening the file" is checked under Connection Properties 4. This may be occurring on a Virtual Machine. I have found one other user with a similar problem: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bcc35121-1575-4a7f-b82f-1c20f6fed58d/process-blocked-by-asyncnetworkio-status-blocks-other-queries?forum=sqldatabaseengine
Asked by John Zabroski (485 rep)
Jul 11, 2017, 05:06 PM
Last activity: Nov 24, 2020, 02:16 AM