public override object Convert(EnvironmentModel obj)
{
var root = new TabObject();
root.AddRow().Key("Machine").Value(BuildMachineDetails(obj.Machine));
root.AddRow().Key("Web Server").Value(BuildWebServerDetails(obj.WebServer));
root.AddRow().Key("Framework").Value(BuildFrameworkDetails(obj.Framework));
root.AddRow().Key("Process").Value(BuildProcessDetails(obj.Process));
root.AddRow().Key("Timezone").Value(BuildTimeZoneDetails(obj.TimeZone));
root.AddRow().Key("Application Assemblies").Value(BuildAssemblyDetails(obj.ApplicationAssemblies));
root.AddRow().Key("System Assemblies").Value(BuildAssemblyDetails(obj.SystemAssemblies));
return(root.Build());
}
public override object Convert(ConfigurationModel obj)
{
var root = new TabObject();
root.AddRow().Key("/configuration/appSettings").Value(obj.AppSettings);
root.AddRow().Key("/configuration/connectionStrings").Value(BuildConnectionStringsDetails(obj.ConnectionStrings));
root.AddRow().Key("/configuration/system.web/authentication").Value(obj.Authentication);
root.AddRow().Key("/configuration/system.web/roleManager").Value(obj.RoleManager);
root.AddRow().Key("/configuration/system.web/customErrors").Value(obj.CustomErrors);
root.AddRow().Key("/configuration/system.web/httpModules").Value(BuildHttpModulesDetails(obj.HttpModules));
root.AddRow().Key("/configuration/system.web/httpHandlers").Value(BuildHttpHandlersDetails(obj.HttpHandlers));
return(root.Build());
}
public override object Convert(RequestModel request)
{
var root = new TabObject();
root.AddRow().Key("Cookies").Value(BuildCookies(request.Cookies));
root.AddRow().Key("Current UI Culture").Value(request.CurrentUiCulture);
root.AddRow().Key("Files").Value(BuildFiles(request.Files));
root.AddRow().Key("Form Variables").Value(BuildFormVariables(request.FormVariables));
root.AddRow().Key("Header Fields").Value(BuildHeaderFields(request.HeaderFields));
root.AddRow().Key("Query String").Value(BuildQueryString(request.QueryString));
root.AddRow().Key("Url").Value(request.Url.ToString());
root.AddRow().Key("Url Referrer").Value(request.UrlReferrer.ToStringOrDefault());
root.AddRow().Key("Raw Url").Value(request.RawUrl);
root.AddRow().Key("Request Type").Value(request.RequestType);
root.AddRow().Key("Url").Value(request.Url);
root.AddRow().Key("Url Referrer").Value(request.UrlReferrer);
root.AddRow().Key("User Agent").Value(request.UserAgent);
root.AddRow().Key("User Host Address").Value(request.UserHostAddress);
root.AddRow().Key("User Host Name").Value(request.UserHostName);
root.AddRow().Key("Path").Value(BuildPathFields(request));
return(root.Build());
}
public override object Convert(RequestModel request)
{
var root = new TabObject();
root.AddRow().Key("Cookies").Value(BuildCookies(request.Cookies));
root.AddRow().Key("Query String").Value(BuildQueryString(request.QueryString));
root.AddRow().Key("Url").Value(request.Url.ToString());
root.AddRow().Key("Url Referrer").Value(request.UrlReferrer.ToStringOrDefault());
root.AddRow().Key("App Relative Current Execution File Path").Value(request.AppRelativeCurrentExecutionFilePath);
root.AddRow().Key("Application Path").Value(request.ApplicationPath);
root.AddRow().Key("Current Execution File Path").Value(request.CurrentExecutionFilePath);
root.AddRow().Key("Current UI Culture").Value(request.CurrentUiCulture);
root.AddRow().Key("File Path").Value(request.FilePath);
root.AddRow().Key("Path").Value(request.Path);
root.AddRow().Key("Path Info").Value(request.PathInfo);
root.AddRow().Key("Physical Application Path").Value(request.PhysicalApplicationPath);
root.AddRow().Key("Physical Path").Value(request.PhysicalPath);
root.AddRow().Key("Raw Url").Value(request.RawUrl);
root.AddRow().Key("User Agent").Value(request.UserAgent);
root.AddRow().Key("User Host Address").Value(request.UserHostAddress);
root.AddRow().Key("User Host Name").Value(request.UserHostName);
return(root.Build());
}
/// <inheritdic cref="TabBase.GetData(ITabContext)" />
public override object GetData(ITabContext context)
{
var connectionLifetimes = context.GetMessages <ConnectionLifetimeTimelineMessage>().ToArray();
var transactionLifetimes = context.GetMessages <TransactionLifetimeTimelineMessage>().ToArray();
var transactionEvents = context.GetMessages <TransactionEventTimelineMessage>().ToArray();
var commands = context.GetMessages <CommandTimelineMessage>().ToArray();
var statisticsSection = new TabSection("Database", "Queries", "Total Transaction Duration");
var eventSection = new TabSection("Database", "Events", "Queries", "IsCommited", "Total Duration");
// Statistics
foreach (var transactionLifetime in transactionLifetimes.OrderBy(x => x.Offset).ToArray())
{
statisticsSection.AddRow()
.Column(connectionLifetimes.First(x => x.ConnectionId == transactionLifetime.ConnectionId).Database)
.Column(commands.Count(x => x.TransactionId.HasValue && x.TransactionId.Value == transactionLifetime.TransactionId))
.Column(transactionLifetime.Duration);
}
// Events
foreach (var transactionLifetime in transactionLifetimes.OrderBy(x => x.Offset).ToArray())
{
var queries = commands
.Where(x => x.TransactionId.HasValue && x.TransactionId.Value == transactionLifetime.TransactionId)
.ToArray();
var events = transactionEvents
.Where(x => x.TransactionId == transactionLifetime.TransactionId)
.Select(x => new
{
EventType = "Transaction",
EventName = x.TransactionEvent.ToString(),
Duration = x.Duration,
Offset = x.Offset
})
.Concat(queries
.Select(x => new
{
EventType = "Command",
EventName = x.CommandText,
Duration = x.Duration,
Offset = x.Offset
})
)
.OrderBy(x => x.Offset)
.ToArray();
var eventDetailSection = new TabSection("EventType", "EventName", "Duration", "Offset");
var duplicatedKeys = new HashSet <string>();
foreach (var @event in events)
{
var row = eventDetailSection.AddRow()
.Column(@event.EventType)
.Column(@event.EventName)
.Column(@event.Duration)
.Column(@event.Offset);
if (@event.EventType == "Command")
{
row.WarnIf(!duplicatedKeys.Add(@event.EventName));
}
}
eventSection.AddRow()
.Column(transactionLifetime.Database)
.Column(eventDetailSection)
.Column(commands.Length)
.Column(transactionLifetime.IsCommited)
.Column(transactionLifetime.Duration);
}
var root = new TabObject();
root.AddRow().Key("Transaction Statistics").Value(statisticsSection);
root.AddRow().Key("Transaction Events").Value(eventSection);
return(root.Build());
}
/// <inheritdic cref="TabBase.GetData(ITabContext)" />
public override object GetData(ITabContext context)
{
var commands = context.GetMessages <CommandTimelineMessage>().ToArray();
if (!commands.Any())
{
return(null);
}
var ordinal = 1;
var duplicationKeys = new HashSet <string>();
var duplicationCount = 0;
var queries = new TabSection("Ordinal", "Database", "Command", "Parameters", "CommandType", "With Transaction", "Records", "IsError", "Duration", "Offset");
foreach (var command in commands)
{
var parameters = new TabSection("Name", "Value", "DbType", "Direction");
foreach (var parameter in command.Parameters)
{
parameters.AddRow()
.Column(parameter.ParameterName)
.Column(parameter.Value)
.Column(parameter.DbType.ToString())
.Column(parameter.Direction.ToString());
}
var row = queries.AddRow()
.Column(ordinal)
.Column(command.Database)
.Column(command.CommandText)
.Column(command.Parameters.Any() ? parameters : null)
.Column(command.CommandType.ToString())
.Column(command.WithTransaction)
.Column(command.Records ?? 0)
.Column(command.IsError)
.Column(command.Duration)
.Column(command.Offset);
var isDuplicated = !duplicationKeys.Add(command.CommandText);
if (isDuplicated)
{
row.WarnIf(true);
duplicationCount++;
}
ordinal++;
}
var sqlStatistics = new TabSection("Queries", "Duplication", "Total Query Duration");
sqlStatistics.AddRow()
.Column(commands.Length)
.Column(duplicationCount)
.Column(commands.Select(x => x.Duration).Aggregate((x, y) => x.Add(y)));
var root = new TabObject();
root.AddRow().Key("SQL Statistics").Value(sqlStatistics);
root.AddRow().Key("Queries").Value(queries);
return(root.Build());
}