Databases
StackOverflow2013
Postsdbo
PODebugDiag shows long Running Since
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODebugDiag shows long Running Since
    primarykey
    data
    text
    <p>Our app pool recycles several times a day. I'm pretty sure it's because it hits the memory limit. I'm also pretty sure that it should NOT hit the memory limit of ~3GB. I tried using WinDbg to analyze the memory dump, with little success. I might try again later. However using DebugDiag gives me some nice visualizations on the data and already lead to some changes that have reduced the number of times it recycles. One report that has me a bit confused and worried is the HttpContext Report. It shows some output like this :</p> <pre><code>HttpContext Timeout Completed RunningSince ThreadId ReturnCode Verb RequestPath+QueryString 0x02374c94 110 Sec No 995 Sec --- 302 GET /Loans/Details/529146/517006 0x02472a44 110 Sec No 993 Sec --- 200 GET /Login ReturnUrl=%2fLoans%2fDetails%2f529146%2f517006 0x024d2f94 110 Sec No 979 Sec --- 302 POST /Loans/UpdateDealer 0x025773c0 110 Sec No 951 Sec --- 302 GET /Applicants 0x025d6bb4 110 Sec No 951 Sec --- 200 GET /Login ReturnUrl=%2fApplicants 0x025f5adc 110 Sec No 935 Sec --- 302 GET /Applicants/Details/537358 0x02654708 110 Sec No 935 Sec --- 200 GET /Login ReturnUrl=%2fApplicants%2fDetails%2f537358 0x026b1bb4 110 Sec No 926 Sec --- 200 POST /Loan/InsertLoanChecklistItem 0x027710dc 110 Sec No 914 Sec --- 200 GET /Applicants 0x02779320 110 Sec No 915 Sec --- 302 POST /Login ReturnUrl=%2fApplicants 0x02797448 110 Sec No 914 Sec --- 200 GET /Loans/Details/523729/526198 0x02867070 110 Sec No 911 Sec --- 200 POST /Loans/UpdateAmount </code></pre> <p>There are, of course, many many more lines in the report. Do I really have requests that have been running for 995 seconds (~15 minutes) and are still not complete? Are they just hung there? are they waiting for something else to finish? I'm not sure I can even believe it, let alone start diagnosing it. Can someone else give me some insight into how to interpret this data?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAl W
    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. PODebugDiag shows long Running Since
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODebugDiag shows long Running Since
      1. USNaresh Goradara
      1. VTBountyStart
    3. VO
      singulars
      1. PODebugDiag shows long Running Since
      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