home *** CD-ROM | disk | FTP | other *** search
/ moodle.waes.ac.uk / moodle.waes.ac.uk.zip / moodle.waes.ac.uk / TMG / SP1-TMG-KB981324-AMD64-ENU.msp / PCW_CAB_SHFx2 / F2143_msfpcui.dll / BINARY / 25058 < prev    next >
Text File  |  2010-06-15  |  1KB  |  39 lines
  1. CREATE PROCEDURE [dbo].[ISA_spTrafficSummaryMonthly] 
  2.     @CurrentMonthFirstDay datetime,
  3.     @CurrentMonthLastDay datetime,
  4.     @LastDailyToKeep datetime,
  5.     @LastMonthlyToKeep datetime
  6. AS
  7. BEGIN
  8.     SET NOCOUNT ON;
  9.  
  10. -- move dailies to monthlies
  11.     INSERT INTO dbo.tblTrafficSummary_Monthly
  12.     SELECT 
  13.          [Interval],
  14.          SUM([CacheHits]),
  15.          SUM([CachedRequests]),
  16.          SUM([NonCachedRequests]),
  17.          SUM([CachedProcessingTime]),
  18.          SUM([NonCachedProcessingTime]),
  19.          SUM([TotalBytes]),
  20.          SUM([WebRequests]),
  21.          SUM([Requests]),
  22.          MAX([MaxConcurrentConnectionsPerMinute]), 
  23.          @CurrentMonthFirstDay AS Date
  24.     FROM dbo.tblTrafficSummary_Daily
  25.     WHERE (Date >= @CurrentMonthFirstDay) AND
  26.           (Date <= @CurrentMonthLastDay)
  27.     GROUP BY
  28.         [Interval]
  29.  
  30. -- cleanup dailies
  31.     DELETE FROM [ISA_RS_Db].[dbo].[tblTrafficSummary_Daily]
  32.     WHERE (Date < @LastDailyToKeep)
  33.  
  34. -- cleanup monthlies
  35.     DELETE FROM [ISA_RS_Db].[dbo].[tblTrafficSummary_Monthly]
  36.     WHERE (Date < @LastMonthlyToKeep)
  37.  
  38. END
  39.