/// <summary>
/// Gets a human readable plain text of the QueryPreparationTimes (Please use monospace font).
/// </summary>
/// <param name="indentLevel">The indent / nesting level of the QueryPreparationTimes object.</param>
/// <returns>A human readable plain text of the QueryPreparationTimes.</returns>
public string ToTextString(int indentLevel = 0)
{
if (indentLevel == int.MaxValue)
{
throw new ArgumentOutOfRangeException("indentLevel", "input must be less than Int32.MaxValue");
}
StringBuilder stringBuilder = new StringBuilder();
// Checked block is needed to suppress potential overflow warning ... even though I check it above
checked
{
QueryMetricsUtils.AppendHeaderToStringBuilder(
stringBuilder,
QueryMetricsConstants.QueryPreparationTimesText,
indentLevel);
QueryMetricsUtils.AppendMillisecondsToStringBuilder(
stringBuilder,
QueryMetricsConstants.QueryCompileTimeText,
this.QueryCompilationTime.TotalMilliseconds,
indentLevel + 1);
QueryMetricsUtils.AppendMillisecondsToStringBuilder(
stringBuilder,
QueryMetricsConstants.LogicalPlanBuildTimeText,
this.LogicalPlanBuildTime.TotalMilliseconds,
indentLevel + 1);
QueryMetricsUtils.AppendMillisecondsToStringBuilder(
stringBuilder,
QueryMetricsConstants.PhysicalPlanBuildTimeText,
this.PhysicalPlanBuildTime.TotalMilliseconds,
indentLevel + 1);
QueryMetricsUtils.AppendMillisecondsToStringBuilder(
stringBuilder,
QueryMetricsConstants.QueryOptimizationTimeText,
this.QueryOptimizationTime.TotalMilliseconds,
indentLevel + 1);
}
return(stringBuilder.ToString());
}
/// <summary>
/// Gets a human readable plain text of the RuntimeExecutionTimes (Please use monospace font).
/// </summary>
/// <param name="indentLevel">The indent / nesting level of the RuntimeExecutionTimes.</param>
/// <returns>A human readable plain text of the QueryMetrics.</returns>
public string ToTextString(int indentLevel = 0)
{
if (indentLevel == int.MaxValue)
{
throw new ArgumentOutOfRangeException("indentLevel", "input must be less than Int32.MaxValue");
}
StringBuilder stringBuilder = new StringBuilder();
// Checked block is needed to suppress potential overflow warning ... even though I check it above
checked
{
QueryMetricsUtils.AppendHeaderToStringBuilder(
stringBuilder,
QueryMetricsConstants.RuntimeExecutionTimesText,
indentLevel);
QueryMetricsUtils.AppendMillisecondsToStringBuilder(
stringBuilder,
QueryMetricsConstants.TotalExecutionTimeText,
this.QueryEngineExecutionTime.TotalMilliseconds,
indentLevel + 1);
QueryMetricsUtils.AppendMillisecondsToStringBuilder(
stringBuilder,
QueryMetricsConstants.SystemFunctionExecuteTimeText,
this.SystemFunctionExecutionTime.TotalMilliseconds,
indentLevel + 1);
QueryMetricsUtils.AppendMillisecondsToStringBuilder(
stringBuilder,
QueryMetricsConstants.UserDefinedFunctionExecutionTimeText,
this.UserDefinedFunctionExecutionTime.TotalMilliseconds,
indentLevel + 1);
}
return(stringBuilder.ToString());
}
public static void AppendNewlineToStringBuilder(StringBuilder stringBuilder)
{
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, string.Empty, 0);
}
/// <summary>
/// Gets a human readable plain text of the ClientSideMetrics (Please use monospace font).
/// </summary>
/// <param name="indentLevel">The indent / nesting level of the ClientSideMetrics.</param>
/// <returns>A human readable plain text of the ClientSideMetrics.</returns>
public string ToTextString(int indentLevel = 0)
{
if (indentLevel == int.MaxValue)
{
throw new ArgumentOutOfRangeException("indentLevel", "input must be less than Int32.MaxValue");
}
StringBuilder stringBuilder = new StringBuilder();
checked
{
// Properties
QueryMetricsUtils.AppendHeaderToStringBuilder(
stringBuilder,
QueryMetricsConstants.ClientSideQueryMetricsText,
indentLevel);
QueryMetricsUtils.AppendCountToStringBuilder(
stringBuilder,
QueryMetricsConstants.RetriesText,
this.Retries,
indentLevel + 1);
QueryMetricsUtils.AppendRUToStringBuilder(
stringBuilder,
QueryMetricsConstants.RequestChargeText,
this.RequestCharge,
indentLevel + 1);
QueryMetricsUtils.AppendNewlineToStringBuilder(stringBuilder);
// Building the table for fetch execution ranges
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, QueryMetricsConstants.FetchExecutionRangesText, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, PartitionExecutionTimelineTable.TopLine, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, PartitionExecutionTimelineTable.Header, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, PartitionExecutionTimelineTable.MiddleLine, 1);
foreach (FetchExecutionRange fetchExecutionRange in this.FetchExecutionRanges.OrderBy(fetchExecutionRange => fetchExecutionRange.StartTime))
{
QueryMetricsUtils.AppendHeaderToStringBuilder(
stringBuilder,
PartitionExecutionTimelineTable.GetRow(
fetchExecutionRange.PartitionId,
fetchExecutionRange.StartTime.ToUniversalTime().ToString("hh:mm:ss.ffffff"),
fetchExecutionRange.EndTime.ToUniversalTime().ToString("hh:mm:ss.ffffff"),
(fetchExecutionRange.EndTime - fetchExecutionRange.StartTime).TotalMilliseconds.ToString("0.00"),
fetchExecutionRange.NumberOfDocuments,
fetchExecutionRange.RetryCount),
1);
}
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, PartitionExecutionTimelineTable.BottomLine, 1);
QueryMetricsUtils.AppendNewlineToStringBuilder(stringBuilder);
// Building the table for scheduling metrics
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, QueryMetricsConstants.SchedulingMetricsText, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, SchedulingMetricsTable.TopLine, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, SchedulingMetricsTable.Header, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, SchedulingMetricsTable.MiddleLine, 1);
foreach (Tuple <string, SchedulingTimeSpan> partitionSchedulingTimeSpan in this.PartitionSchedulingTimeSpans.OrderBy(x => x.Item2.ResponseTime))
{
string partitionId = partitionSchedulingTimeSpan.Item1;
SchedulingTimeSpan schedulingTimeSpan = partitionSchedulingTimeSpan.Item2;
QueryMetricsUtils.AppendHeaderToStringBuilder(
stringBuilder,
SchedulingMetricsTable.GetRow(
partitionId,
schedulingTimeSpan.ResponseTime.TotalMilliseconds.ToString("0.00"),
schedulingTimeSpan.RunTime.TotalMilliseconds.ToString("0.00"),
schedulingTimeSpan.WaitTime.TotalMilliseconds.ToString("0.00"),
schedulingTimeSpan.TurnaroundTime.TotalMilliseconds.ToString("0.00"),
schedulingTimeSpan.NumPreemptions),
1);
}
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, SchedulingMetricsTable.BottomLine, 1);
}
return(stringBuilder.ToString());
}