select transactionId, queryString from FSLogging..tbl_STP_Activity where cleanQueryString is null update FSLogging..tbl_STP_Activity set cleanQueryString = where transactionId = select max( transactionId ) lastTransactionId from FSLogging..tbl_STP_Activity delete from FSLogging..tbl_STP_Activity where transactionId <= select scriptName, cleanQueryString, requestMethod, count(*) hits, avg( requestTimeMs ) avgResponseTime, min( requestTimeMs ) minResponseTime, max( requestTimeMs ) maxResponseTime, count(*) * avg( requestTimeMs ) impactRank from FSLogging..tbl_STP_Activity with (nolock) where requestTimeMs is not null and ownerType = and ownerId = and scriptName = and transactionDate >= dateadd( day, #url.days * -1#, getDate() ) group by scriptName, cleanQueryString, requestMethod order by avgResponseTime desc order by minResponseTime desc order by maxResponseTime desc order by hits desc select sum( hits ) totalHits from qmd_stats select count(*) hitsPerMinute from fslogging..tbl_STP_Activity with (nolock) where transactionDate > dateadd( second, -60, getDate() ) select count(*) / 60 hitsPerMinute from fslogging..tbl_STP_Activity with (nolock) where transactionDate > dateadd( second, -60 * 60, getDate() ) select count(*) / 10 hitsPerMinute from fslogging..tbl_STP_Activity with (nolock) where transactionDate > dateadd( second, -60 * 10, getDate() )

Total Hits: #lsnumberformat( qmd_totals.totalHits )# || Per Minute: #lsnumberformat( qmd_lastMinute.hitsPerMinute )# || Per Minute (Last Ten): #lsnumberformat( qmd_lastTen.hitsPerMinute )# || Per Minute (Last Hour): #lsnumberformat( qmd_lastHour.hitsPerMinute )#

				Response Time
Method	Script	QueryString	Hits	Min	Max	Avg
#htmleditformat( requestMethod )#	#htmleditformat( scriptName )#	#htmleditformat( replace( cleanQueryString, "&", ", ", "ALL" ))#&##160;	#lsnumberformat( hits )#	#lsnumberformat( minResponseTime )#	#lsnumberformat( maxResponseTime )#	#lsnumberformat( avgResponseTime )#

select top 200 ownerId, ownerType, scriptName, queryString, requestMethod, requestTimeMs, transactionDate from FSLogging..tbl_STP_Activity with (nolock) where requestTimeMs is not null and cleanQueryString = and scriptName = and ownerType = and ownerId = order by transactionId desc select count(*) totalHits from qmd_stats

Total Hits: #lsnumberformat( qmd_totals.totalHits )#

Time	Client	Method	Script	QueryString	Response Time
#lsdateformat( transactionDate, "MM/DD/YY" )# @ #lstimeformat( transactionDate )#	#ownerType# #ownerId#	#htmleditformat( requestMethod )#	#htmleditformat( scriptName )#	#htmleditformat( replace( queryString, "&", ", ", "ALL" ))#&##160;	#lsnumberformat( requestTimeMs )#