Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Jeff York — Fri, 08 Apr 2011 15:34:45 GMT

<time>

<avg_total>139586</avg_total>

<avg_min>8166</avg_min>

<avg_max>44772</avg_max>

<min_min>0</min_min>

<max_max>600004882</max_max>

<total_stats>31387</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Chris — Fri, 08 Apr 2011 15:49:52 GMT

<time>

<avg_total>1182174</avg_total>

<avg_min>20863</avg_min>

<avg_max>125767</avg_max>

<min_min>0</min_min>

<max_max>233555665</max_max>

<total_stats>35622</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Srdjan — Fri, 08 Apr 2011 17:25:24 GMT

<time>

<avg_total>165614</avg_total>

<avg_min>4068</avg_min>

<avg_max>11144</avg_max>

<min_min>4</min_min>

<max_max>36331573</max_max>

<total_stats>11014</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Sankar Reddy — Fri, 08 Apr 2011 18:29:32 GMT

<time>

<avg_total>26534094</avg_total>

<avg_min>48282</avg_min>

<avg_max>379208</avg_max>

<min_min>0</min_min>

<max_max>601375977</max_max>

<total_stats>7134</total_stats>

</time>

<time>

<avg_total>18814983</avg_total>

<avg_min>584624</avg_min>

<avg_max>754379</avg_max>

<min_min>0</min_min>

<max_max>941254883</max_max>

<total_stats>13225</total_stats>

</time>

<time>

<avg_total>382198</avg_total>

<avg_min>1251</avg_min>

<avg_max>34765</avg_max>

<min_min>0</min_min>

<max_max>150887696</max_max>

<total_stats>4874</total_stats>

</time>

<time>

<avg_total>13825</avg_total>

<avg_min>768</avg_min>

<avg_max>12190</avg_max>

<min_min>0</min_min>

<max_max>1944336</max_max>

<total_stats>178</total_stats>

</time>

<time>

<avg_total>129010</avg_total>

<avg_min>1662</avg_min>

<avg_max>87329</avg_max>

<min_min>0</min_min>

<max_max>2006836</max_max>

<total_stats>47</total_stats>

</time>

<time>

<avg_total>10340820</avg_total>

<avg_min>0</avg_min>

<avg_max>2015136</avg_max>

<min_min>0</min_min>

<max_max>2015625</max_max>

<total_stats>2</total_stats>

</time>

<time>

<avg_total>270290</avg_total>

<avg_min>3954</avg_min>

<avg_max>32815</avg_max>

<min_min>0</min_min>

<max_max>600723633</max_max>

<total_stats>42793</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Chris — Fri, 08 Apr 2011 20:14:24 GMT

<time>

<avg_total>862925</avg_total>

<avg_min>2793</avg_min>

<avg_max>32330</avg_max>

<min_min>0</min_min>

<max_max>197649414</max_max>

<total_stats>9139</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Michael — Fri, 08 Apr 2011 21:31:32 GMT

Server was restarted yesterday so counts are low:

<time>

<avg_total>2095945</avg_total>

<avg_min>1176836</avg_min>

<avg_max>1333943</avg_max>

<min_min>0</min_min>

<max_max>6471953125</max_max>

<total_stats>15492</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

namraja — Sat, 09 Apr 2011 18:57:36 GMT

<time>

<avg_total>6869934</avg_total>

<avg_min>528188</avg_min>

<avg_max>1831242</avg_max>

<min_min>3</min_min>

<max_max>7025659629</max_max>

<total_stats>12994</total_stats>

</time>

<time>

<avg_total>5532677</avg_total>

<avg_min>603139</avg_min>

<avg_max>792353</avg_max>

<min_min>0</min_min>

<max_max>2568274349</max_max>

<total_stats>57944</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

George — Sun, 10 Apr 2011 01:44:39 GMT

<time>

<avg_total>227330</avg_total>

<avg_min>47312</avg_min>

<avg_max>82609</avg_max>

<min_min>0</min_min>

<max_max>600673829</max_max>

<total_stats>38655</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Alvaro — Mon, 11 Apr 2011 09:21:28 GMT

<time>

<avg_total>1792570</avg_total>

<avg_min>122323</avg_min>

<avg_max>159202</avg_max>

<min_min>1</min_min>

<max_max>1639573662</max_max>

<total_stats>99944</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Fabricio Lima — Mon, 11 Apr 2011 17:00:50 GMT

<time>

<avg_total>9741620</avg_total>

<avg_min>26870</avg_min>

<avg_max>414240</avg_max>

<min_min>1</min_min>

<max_max>603658341</max_max>

<total_stats>4663</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Calvin — Tue, 12 Apr 2011 14:33:10 GMT

<time>

<avg_total>866008</avg_total>

<avg_min>10895</avg_min>

<avg_max>92887</avg_max>

<min_min>0</min_min>

<max_max>13201171</max_max>

<total_stats>591</total_stats>

</time>

<time>

<avg_total>2767665</avg_total>

<avg_min>1625</avg_min>

<avg_max>90274</avg_max>

<min_min>0</min_min>

<max_max>599994140</max_max>

<total_stats>7261</total_stats>

</time>

<time>

<avg_total>368355456</avg_total>

<avg_min>2881</avg_min>

<avg_max>19027</avg_max>

<min_min>0</min_min>

<max_max>1768554</max_max>

<total_stats>161</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Clyde Jin — Tue, 12 Apr 2011 14:33:50 GMT

<time>

<avg_total>3020341</avg_total>

<avg_min>9720</avg_min>

<avg_max>157467</avg_max>

<min_min>0</min_min>

<max_max>7486087179</max_max>

<total_stats>85928</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Patrick — Wed, 13 Apr 2011 17:18:58 GMT

<time>

<avg_total>259316330</avg_total>

<avg_min>140868</avg_min>

<avg_max>32967763</avg_max>

<min_min>0</min_min>

<max_max>1663169055000</max_max>

<total_stats>51106</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Woodler — Thu, 14 Apr 2011 09:49:31 GMT

<time>

<avg_total>19862</avg_total>

<avg_min>550</avg_min>

<avg_max>4759</avg_max>

<min_min>0</min_min>

<max_max>405600</max_max>

<total_stats>12410</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Adam Machanic — Fri, 15 Apr 2011 14:47:45 GMT

Thanks, all, for taking the time to run the query and for pasting the XML back here.

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

MyChoreBoy — Tue, 19 Apr 2011 17:31:06 GMT

<time>

<avg_total>21367621</avg_total>

<avg_min>393321</avg_min>

<avg_max>642318</avg_max>

<min_min>0</min_min>

<max_max>721951171</max_max>

<total_stats>6953</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

John — Wed, 20 Apr 2011 20:14:01 GMT

Thanks for the blog and the tool Adam. I'm a few days behind, but if you still want more results here is a sampling of mine...kind of all over the board.

<time>

<avg_total>26474279</avg_total>

<avg_min>19519832</avg_min>

<avg_max>21040860</avg_max>

<min_min>0</min_min>

<max_max>7501082031</max_max>

<total_stats>2385</total_stats>

</time>

<time>

<avg_total>554602</avg_total>

<avg_min>28025</avg_min>

<avg_max>96354</avg_max>

<min_min>0</min_min>

<max_max>600015625</max_max>

<total_stats>14287</total_stats>

</time>

<time>

<avg_total>3372854</avg_total>

<avg_min>173265</avg_min>

<avg_max>323275</avg_max>

<min_min>0</min_min>

<max_max>1213653320</max_max>

<total_stats>7463</total_stats>

</time>

<time>

<avg_total>403215</avg_total>

<avg_min>107058</avg_min>

<avg_max>128744</avg_max>

<min_min>0</min_min>

<max_max>1377140767</max_max>

<total_stats>49047</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

David Howard — Thu, 21 Apr 2011 18:46:51 GMT

<time>

<avg_total>345579</avg_total>

<avg_min>227361</avg_min>

<avg_max>258244</avg_max>

<min_min>0</min_min>

<max_max>14200316406</max_max>

<total_stats>69141</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Barny — Tue, 26 Apr 2011 08:37:28 GMT

Twenty Nine Days of Activity Monitoring (A Month of Activity Monitoring, Part 30 of 30)

Adam Machanic — Sat, 30 Apr 2011 15:45:05 GMT

This post is part 30 of a 30-part series about the Who is Active stored procedure. A new post will run

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

John Stanley — Tue, 17 May 2011 13:40:00 GMT

<time>

<avg_total>381860</avg_total>

<avg_min>6260</avg_min>

<avg_max>23816</avg_max>

<min_min>4</min_min>

<max_max>601124930</max_max>

<total_stats>58682</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Anton — Wed, 15 Jun 2011 21:37:56 GMT

<time>

<avg_total>161106</avg_total>

<avg_min>16309</avg_min>

<avg_max>43152</avg_max>

<min_min>0</min_min>

<max_max>5181641</max_max>

<total_stats>1914</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

reader — Fri, 05 Aug 2011 17:49:37 GMT

<time>

<avg_total>2732887</avg_total>

<avg_min>11434</avg_min>

<avg_max>43464</avg_max>

<min_min>4</min_min>

<max_max>112866885</max_max>

<total_stats>35243</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Adam W — Mon, 21 Nov 2011 21:43:35 GMT

<time>

<avg_total>17119867</avg_total>

<avg_min>8973</avg_min>

<avg_max>321737</avg_max>

<min_min>3</min_min>

<max_max>600219818</max_max>

<total_stats>28339</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Nadia — Wed, 15 Feb 2012 17:49:30 GMT

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

yazalpizar — Fri, 15 Mar 2013 09:52:43 GMT

Prod server:

<time>

<avg_total>3688008</avg_total>

<avg_min>19725</avg_min>

<avg_max>141714</avg_max>

<min_min>0</min_min>

<max_max>2114197239</max_max>

<total_stats>60209</total_stats>

</time>

Test server:

<time>

<avg_total>1702154</avg_total>

<avg_min>69230</avg_min>

<avg_max>308920</avg_max>

<min_min>0</min_min>

<max_max>600035156</max_max>

<total_stats>6462</total_stats>

</time>

re: Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

Tiago — Wed, 24 Apr 2013 11:25:47 GMT

Prod Server:

<time>

<avg_total>5723106</avg_total>

<avg_min>22759</avg_min>

<avg_max>122039</avg_max>

<min_min>2</min_min>

<max_max>1074079088</max_max>

<total_stats>31966</total_stats>

</time>

<time>

<avg_total>3001623</avg_total>

<avg_min>369102</avg_min>

<avg_max>1064351</avg_max>

<min_min>0</min_min>

<max_max>1441361441</max_max>

<total_stats>15980</total_stats>

</time>

<time>

<avg_total>515299</avg_total>

<avg_min>49183</avg_min>

<avg_max>75345</avg_max>

<min_min>2</min_min>

<max_max>600012033</max_max>

<total_stats>32961</total_stats>

</time>