protected override void WriteIndexUtilizationInfo(IndexUtilizationInfo indexUtilizationInfo)
{
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.UtilizedIndexes, indentLevel: 1);
foreach (IndexUtilizationData indexUtilizationData in indexUtilizationInfo.UtilizedIndexes)
{
WriteIndexUtilizationData(indexUtilizationData);
}
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.PotentialIndexes, indentLevel: 1);
foreach (IndexUtilizationData indexUtilizationData in indexUtilizationInfo.PotentialIndexes)
{
WriteIndexUtilizationData(indexUtilizationData);
}
void WriteIndexUtilizationData(IndexUtilizationData indexUtilizationData)
{
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, $"{QueryMetricsTextWriter.FilterExpression}: {indexUtilizationData.FilterExpression}", indentLevel: 2);
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, $"{QueryMetricsTextWriter.IndexExpression}: {indexUtilizationData.IndexDocumentExpression}", indentLevel: 2);
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, $"{QueryMetricsTextWriter.FilterExpressionPrecision}: {indexUtilizationData.FilterExpressionPrecision}", indentLevel: 2);
//QueryMetricsTextWriter.AppendHeaderToStringBuilder(stringBuilder, $"{QueryMetricsTextWriter.IndexPlanFullFidelity}: {indexUtilizationData.IndexPlanFullFidelity}", indentLevel: 2); //currently not exposed to the users
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, IndexUtilizationSeparator, indentLevel: 2);
}
}
private string ToTextString()
{
StringBuilder stringBuilder = new StringBuilder();
QueryMetricsTextWriter queryMetricsTextWriter = new QueryMetricsTextWriter(stringBuilder);
queryMetricsTextWriter.WriteQueryMetrics(this);
return(stringBuilder.ToString());
}
protected override void WriteBeforePartitionExecutionTimeline()
{
QueryMetricsTextWriter.AppendNewlineToStringBuilder(this.stringBuilder);
// Building the table for fetch execution ranges
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.FetchExecutionRanges, indentLevel: 1);
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, PartitionExecutionTimelineTable.TopLine, indentLevel: 1);
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, PartitionExecutionTimelineTable.Header, indentLevel: 1);
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, PartitionExecutionTimelineTable.MiddleLine, indentLevel: 1);
}
protected override void WriteBeforeSchedulingMetrics()
{
QueryMetricsTextWriter.AppendNewlineToStringBuilder(this.stringBuilder);
// Building the table for scheduling metrics
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.SchedulingMetrics, indentLevel: 1);
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, SchedulingMetricsTable.TopLine, indentLevel: 1);
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, SchedulingMetricsTable.Header, indentLevel: 1);
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, SchedulingMetricsTable.MiddleLine, indentLevel: 1);
}
private static void AppendBytesToStringBuilder(StringBuilder stringBuilder, string property, long bytes, int indentLevel)
{
const string BytesFormatString = "{0:n0}";
const string BytesUnitString = "bytes";
QueryMetricsTextWriter.AppendToStringBuilder(
stringBuilder,
property,
string.Format(CultureInfo.InvariantCulture, BytesFormatString, bytes),
BytesUnitString,
indentLevel);
}
private static void AppendCountToStringBuilder(StringBuilder stringBuilder, string property, long count, int indentLevel)
{
const string CountFormatString = "{0:n0}";
const string CountUnitString = "";
QueryMetricsTextWriter.AppendToStringBuilder(
stringBuilder,
property,
string.Format(CultureInfo.InvariantCulture, CountFormatString, count),
CountUnitString,
indentLevel);
}
private static void AppendPercentageToStringBuilder(StringBuilder stringBuilder, string property, double percentage, int indentLevel)
{
const string PercentageFormatString = "{0:n2}";
const string PercentageUnitString = "%";
QueryMetricsTextWriter.AppendToStringBuilder(
stringBuilder,
property,
string.Format(CultureInfo.InvariantCulture, PercentageFormatString, percentage * 100),
PercentageUnitString,
indentLevel);
}
private static void AppendTimeSpanToStringBuilder(StringBuilder stringBuilder, string property, TimeSpan timeSpan, int indentLevel)
{
const string MillisecondsFormatString = "{0:n2}";
const string MillisecondsUnitString = "milliseconds";
QueryMetricsTextWriter.AppendToStringBuilder(
stringBuilder,
property,
string.Format(CultureInfo.InvariantCulture, MillisecondsFormatString, timeSpan.TotalMilliseconds),
MillisecondsUnitString,
indentLevel);
}
private static void AppendRUToStringBuilder(StringBuilder stringBuilder, string property, double requestCharge, int indentLevel)
{
const string RequestChargeFormatString = "{0:n2}";
const string RequestChargeUnitString = "RUs";
QueryMetricsTextWriter.AppendToStringBuilder(
stringBuilder,
property,
string.Format(CultureInfo.InvariantCulture, RequestChargeFormatString, requestCharge),
RequestChargeUnitString,
indentLevel);
}
protected override void WriteAfterPartitionSchedulingTimeSpan()
{
QueryMetricsTextWriter.AppendHeaderToStringBuilder(
this.stringBuilder,
SchedulingMetricsTable.GetRow(
this.lastSchedulingPartitionId,
this.lastResponseTime.TotalMilliseconds.ToString("0.00"),
this.lastRunTime.TotalMilliseconds.ToString("0.00"),
this.lastWaitTime.TotalMilliseconds.ToString("0.00"),
this.lastTurnaroundTime.TotalMilliseconds.ToString("0.00"),
this.lastNumberOfPreemptions),
indentLevel: 1);
}
protected override void WriteAfterFetchExecutionRange()
{
QueryMetricsTextWriter.AppendHeaderToStringBuilder(
this.stringBuilder,
PartitionExecutionTimelineTable.GetRow(
this.lastFetchPartitionId,
this.lastActivityId,
this.lastStartTime.ToUniversalTime().ToString(DateTimeFormat),
this.lastEndTime.ToUniversalTime().ToString(DateTimeFormat),
(this.lastEndTime - this.lastStartTime).TotalMilliseconds.ToString("0.00"),
this.lastFetchDocumentCount,
this.lastFetchRetryCount),
indentLevel: 1);
}
protected override void WriteBeforeRuntimeExecutionTimes()
{
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.RuntimeExecutionTimes, indentLevel: 1);
}
protected override void WriteIndexLookupTime(TimeSpan indexLookupTime)
{
QueryMetricsTextWriter.AppendTimeSpanToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.IndexLookupTime, indexLookupTime, indentLevel: 1);
}
protected override void WriteIndexHitRatio(double indexHitRatio)
{
QueryMetricsTextWriter.AppendPercentageToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.IndexUtilization, indexHitRatio, indentLevel: 0);
}
protected override void WriteQueryEngineExecutionTime(TimeSpan queryEngineExecutionTime)
{
QueryMetricsTextWriter.AppendTimeSpanToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.QueryEngineTimes, queryEngineExecutionTime, 2);
}
protected override void WriteAfterSchedulingMetrics()
{
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, SchedulingMetricsTable.BottomLine, indentLevel: 1);
}
protected override void WriteBeforeIndexUtilizationInfo()
{
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.IndexUtilizationInfo, indentLevel: 0);
}
protected override void WriteUserDefinedFunctionExecutionTime(TimeSpan userDefinedFunctionExecutionTime)
{
QueryMetricsTextWriter.AppendTimeSpanToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.UserDefinedFunctionExecutionTime, userDefinedFunctionExecutionTime, 2);
}
protected override void WriteBeforeClientSideMetrics()
{
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.ClientSideQueryMetrics, indentLevel: 0);
}
protected override void WritePhysicalPlanBuildTime(TimeSpan physicalPlanBuildTime)
{
QueryMetricsTextWriter.AppendTimeSpanToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.PhysicalPlanBuildTime, physicalPlanBuildTime, 2);
}
protected override void WriteAfterPartitionExecutionTimeline()
{
QueryMetricsTextWriter.AppendHeaderToStringBuilder(this.stringBuilder, PartitionExecutionTimelineTable.BottomLine, indentLevel: 1);
}
private static void AppendNewlineToStringBuilder(StringBuilder stringBuilder)
{
QueryMetricsTextWriter.AppendHeaderToStringBuilder(stringBuilder, string.Empty, 0);
}
protected override void WriteRequestCharge(double requestCharge)
{
QueryMetricsTextWriter.AppendRUToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.RequestCharge, requestCharge, indentLevel: 1);
}
protected override void WriteRetries(long retries)
{
QueryMetricsTextWriter.AppendCountToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.Retries, retries, indentLevel: 1);
}
protected override void WriteQueryOptimizationTime(TimeSpan queryOptimizationTime)
{
QueryMetricsTextWriter.AppendTimeSpanToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.QueryOptimizationTime, queryOptimizationTime, 2);
}
protected override void WriteSystemFunctionExecutionTime(TimeSpan systemFunctionExecutionTime)
{
QueryMetricsTextWriter.AppendTimeSpanToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.SystemFunctionExecuteTime, systemFunctionExecutionTime, 2);
}
protected override void WriteOutputDocumentSize(long outputDocumentSize)
{
QueryMetricsTextWriter.AppendBytesToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.OutputDocumentSize, outputDocumentSize, indentLevel: 0);
}
protected override void WriteDocumentWriteTime(TimeSpan documentWriteTime)
{
QueryMetricsTextWriter.AppendTimeSpanToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.DocumentWriteTime, documentWriteTime, indentLevel: 1);
}
protected override void WriteOutputDocumentCount(long outputDocumentCount)
{
QueryMetricsTextWriter.AppendCountToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.OutputDocumentCount, outputDocumentCount, indentLevel: 0);
}
protected override void WriteTotalQueryExecutionTime(TimeSpan totalQueryExecutionTime)
{
QueryMetricsTextWriter.AppendTimeSpanToStringBuilder(this.stringBuilder, QueryMetricsTextWriter.TotalQueryExecutionTime, totalQueryExecutionTime, indentLevel: 0);
}
