Databases
StackOverflow2013
Postsdbo
POWhat is SNIReadSyncOverAsync and why would it take a long time to complete?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhat is SNIReadSyncOverAsync and why would it take a long time to complete?
    primarykey
    data
    text
    <p>On our ASP.Net website, we've had some requests timeout. AppDynamics shows that the SQL procedure calls are returning in a matter of seconds, but we're spending 100+ seconds in SNIReadSyncOverAsync.</p> <p>Does anyone know what this method is / does and why it would be taking that much time? We're not using EF which is referenced in every question / post I've been able to find about it.</p> <p>Thanks in advance</p> <p><strong>Update</strong></p> <p>It's been a while and while we never came to a resolution as to why all of the time was being spent in SNIReadSyncOverAsync, I have a few thoughts.</p> <p>I think that in this case, it may have been the way that specific version of AppDynamics was reporting the time spent on the SQL calls, but I have no real data to back that up, just my guess from what I observed. We eventually stopped seeing the time reported as being spent in SNIReadSyncOverAsync and it shifted to the queries themselves timing out.</p> <p>That still didn't make a lot of since because the same queries would run instantly in SSMS on the same database.</p> <p>The ultimate answer ended up being related to ARITHABORT causing our application and SSMS to use two different execution plans (see <a href="https://dba.stackexchange.com/a/9841">https://dba.stackexchange.com/a/9841</a>), explaining why we couldn't reproduce the timeouts with SSMS.</p> <p>Once we resolved that, we were able to identify a few portions of the procedure that needed tuning and we haven't run into the unexplained timeouts or SNIReadSyncOverAsync since.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USryan.rousseau
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhat is SNIReadSyncOverAsync and why would it take a long time to complete?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhat is SNIReadSyncOverAsync and why would it take a long time to complete?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWhat is SNIReadSyncOverAsync and why would it take a long time to complete?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload