public void ParseStats3()
{
var statsString = @"SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
(9 rows affected)
Table 'Workfile'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Users'. Scan count 1, logical reads 13, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
(1 row affected)
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 153 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.";
var parser = new StatisticsParser(LanguageType.English);
var results = parser.ParseStatistics(statsString);
}
public async Task ShouldParseStatsFromCourseDetails(string domain, string filePath, ParkrunStats expectedStats)
{
using (var cancellationsPage = File.OpenRead(filePath))
{
var parser = new StatisticsParser();
var stats = await parser.Parse(cancellationsPage, domain);
stats.Should().BeEquivalentTo(expectedStats);
}
}
public void StopCollector()
{
_timer.Stop();
_timer.Dispose();
StatisticsParser.Parse(
_statisticsOutputPath,
_percentileList,
_latencyStep,
_latencyMax,
Log.Information);
}
public static void ParseResult(string content)
{
var simpleModel = new SimpleBenchmarkModel();
var configData = simpleModel.Deserialize(content);
var percentileList = SignalRConstants.PERCENTILE_LIST.Split(",")
.Select(ind => Convert.ToDouble(ind)).ToArray();
StatisticsParser.Parse(
configData.Config.ResultFilePath,
percentileList,
SignalRConstants.LATENCY_STEP,
SignalRConstants.LATENCY_MAX,
Log.Information);
}
public void ParseStats()
{
var statsString = @"
SQL Server parse and compile time:
CPU time = 108 ms, elapsed time = 108 ms.
(13431682 row(s) affected)
Table 'PostTypes'. Scan count 1, logical reads 2, physical reads 1, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Users'. Scan count 5, logical reads 42015, physical reads 1, read-ahead reads 41306, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Comments'. Scan count 5, logical reads 1089402, physical reads 248, read-ahead reads 1108174, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'PostTags'. Scan count 5, logical reads 77500, physical reads 348, read-ahead reads 82219, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Posts'. Scan count 5, logical reads 397944, physical reads 9338, read-ahead reads 402977, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Worktable'. Scan count 999172, logical reads 16247024, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 156527 ms, elapsed time = 284906 ms.
SQL Server parse and compile time:
CPU time = 16 ms, elapsed time = 19 ms.
(233033 row(s) affected)
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Votes'. Scan count 1, logical reads 250128, physical reads 10, read-ahead reads 250104, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Posts'. Scan count 1, logical reads 165586, physical reads 18, read-ahead reads 49191, lob logical reads 823463, lob physical reads 42854, lob read-ahead reads 3272.
Table 'Users'. Scan count 1, logical reads 41405, physical reads 3, read-ahead reads 41401, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 17207 ms, elapsed time = 38163 ms.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'scores'.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
";
var parser = new StatisticsParser(LanguageType.English);
var results = parser.ParseStatistics(statsString);
}
protected BenchResult GetBenchResult(string output = null)
{
var resultFile = output != null ? output : SimpleBenchmarkModel.DEFAULT_OUTPUT_PATH;
if (File.Exists(resultFile))
{
var percentileList = SignalRConstants.PERCENTILE_LIST.Split(",")
.Select(ind => Convert.ToDouble(ind)).ToArray();
var sb = new StringBuilder();
StatisticsParser.Parse(
resultFile,
percentileList,
SignalRConstants.LATENCY_STEP,
SignalRConstants.LATENCY_MAX,
x => { sb.Append(x); },
true);
var jsonResult = sb.ToString();
_output.WriteLine(jsonResult);
var benchResult = JsonConvert.DeserializeObject <BenchResult>(jsonResult);
return(benchResult);
}
return(null);
}
public void DoesBlacklistAppInsightsUserAgentStrings(string userAgent)
{
Assert.True(StatisticsParser.IsBlackListed(userAgent));
}
public void DoesNotBlacklistEmptyUserAgentStrings(string userAgent)
{
Assert.False(StatisticsParser.IsBlackListed(userAgent));
}
public ParseStatisticsFunction(StatisticsParser parser, ILogger logger)
{
_parser = parser;
_logger = logger;
}
