public void BasicQueriesWork()
{
var config = new MeasurementStoreConfig()
{
StoreType = StoreType.MicrosoftSqlServer,
ConnectionString = @"server=(localdb)\MSSqlLocalDb;Database=QueryTests;MultipleActiveResultSets = True"
};
using (var store = new MeasurementStore(config))
{
store.Database.EnsureCreated();
store.Database.EnsureDeleted();
store.Database.EnsureCreated();
foreach (var n in new[] { 1, 2, 3 })
{
var trace = new MeasuredTrace()
{
PackageFileName = $"Trace{n}"
};
var measurement = new CpuSampled()
{
ProcessName = "ProcessX",
IsDpc = true,
Count = 100,
TotalSamplesDuringInterval = 1000,
CpuCoreCount = 1
};
var measurement2 = new TraceAttribute()
{
Name = "AttributeX", WholeNumberValue = n
};
trace.AddMeasurement(measurement);
trace.AddMeasurement(measurement2);
Assert.True(store.SaveTraceAndMeasurements(trace) == 3);
trace.ProcessingRecords.Add(new ProcessingRecord()
{
Path = "xxx",
StateChangeTime = new DateTime(1980, 2, 2),
ProcessingState = ProcessingState.Discovered
});
Assert.True(store.SaveChanges() == 1);
}
}
using (var store = new MeasurementStore(config))
{
foreach (var trace in store.GetTraceByFilter(t => true, true))
{
Assert.NotEmpty(trace.ProcessingRecords);
var measurements = trace.GetMeasurementsAll();
Assert.True(measurements.Count() == 2);
}
}
}
public void SimpleProcessingTest()
{
var dataSource =
@"https://github.com/MatthewMWR/WinPerf/blob/master/Scenarios/BOOT-REFERENCE__NormalLightlyManaged.zip?raw=true";
var dataIncomingDir = Path.Combine(Path.GetTempPath(), "SimpleProcessingTest-In");
Directory.CreateDirectory(dataIncomingDir);
var dataArchiveDir = Path.Combine(Path.GetTempPath(), "SimpleProcessingTest-Archive");
Directory.CreateDirectory(dataArchiveDir);
var dataDownloadStageDir = Path.Combine(Path.GetTempPath(), "SimpleProcessingTest-DownloadStage");
Directory.CreateDirectory(dataDownloadStageDir);
var stagedDownlodFilePath = Path.Combine(dataDownloadStageDir, "original.zip");
if (!File.Exists(stagedDownlodFilePath))
{
var webClient = new WebClient();
webClient.DownloadFile(dataSource, stagedDownlodFilePath);
}
var testCopyCount = 26;
var i = 0;
while (i < testCopyCount)
{
i++;
File.Copy(stagedDownlodFilePath, Path.Combine(dataIncomingDir, $"Copy{i}.zip"), true);
}
var storeConfig = new MeasurementStoreConfig()
{
StoreType = StoreType.MicrosoftSqlServer,
ConnectionString = @"server=(localdb)\MSSqlLocalDb;Database=SimpleProcessingTest"
};
var processingConfig = new ProcessingConfig()
{
DestinationDataPath = dataArchiveDir
};
processingConfig.IncomingDataPaths.Add(dataIncomingDir);
using (var store = new MeasurementStore(storeConfig))
{
store.Database.EnsureCreated();
store.Database.EnsureDeleted();
store.Database.EnsureCreated();
}
Automate.InvokeProcessingOnce(processingConfig, storeConfig);
using (var store = new MeasurementStore(storeConfig))
{
Assert.True(store.Traces.Count() == testCopyCount);
var measuredCount = store.Traces
.Include(t => t.ProcessingRecords)
.Count(t => t.ProcessingRecords.OrderBy(pr => pr.StateChangeTime).Last().ProcessingState == ProcessingState.Measured);
Assert.True(measuredCount == processingConfig.ParallelMeasuringThrottle);
var movedCount = store.ProcessingRecords.Count(pr => pr.ProcessingState == ProcessingState.Moved);
Assert.True(movedCount == processingConfig.ParallelMovesThrottle);
}
Automate.InvokeProcessingOnce(processingConfig, storeConfig);
Automate.InvokeProcessingOnce(processingConfig, storeConfig);
Automate.InvokeProcessingOnce(processingConfig, storeConfig);
using (var store = new MeasurementStore(storeConfig))
{
var measuredCount = store.Traces
.Include(t => t.ProcessingRecords)
.Count(t => t.ProcessingRecords.OrderBy(pr => pr.StateChangeTime).Last().ProcessingState == ProcessingState.Measured);
Assert.True(measuredCount == testCopyCount);
var measuredCountByDifferentPath = store.GetTraceByState(ProcessingState.Measured).Count();
Assert.True(measuredCountByDifferentPath == testCopyCount);
var measuredCountByThirdPath =
store.GetTraceByFilter(t => t.ProcessingRecords.Latest().ProcessingState == ProcessingState.Measured).Count();
Assert.True(measuredCountByThirdPath == testCopyCount);
Assert.True(store.GetTraceByName("copy1.zip", false) != null);
Assert.True(store.GetTraceByFilter(t => t.ProcessingRecords.Count == 3).AsEnumerable().Count() == testCopyCount);
Assert.NotEmpty(store.GetTraceByName("copy1.zip", true).GetMeasurements <DiskIo>());
}
}