protected void Page_Load(object sender, EventArgs e)
{
var state = Session[DataTableSessionConstants.UptimeState] as UptimeReportViewModel;
var model = state ?? new UptimeReportViewModel();
Initialize(model);
var scores = _uptime.GetOverallScores();
QoSNavButton.HRef = QosNavigationUrl;
QuarterlyScore.Attributes["class"] = _indicatorService.GetCssClassForScore(scores.QuarterlyUptimeScore, true);
QuarterlyScore.InnerText = _indicatorService.GetIndicatorForScore(scores.QuarterlyUptimeScore) != QualityIndicator.None ?
scores.QuarterlyUptimeScore.ToString() :
"N/A";
QuarterlyScore.Attributes["href"] = QosNavigationUrl;
DateFormatString.Value = DateFormat;
TimeFormatString.Value = TimeFormat;
var timezoneOffset = RequestService.GetTimezoneOffset(this.Request);
startDate.Value = model.GridConditions.StartDate.HasValue
? model.GridConditions.StartDate.Value.AddMinutes(timezoneOffset).ToShortDateString()
: GlassInfo.MinSampleDate.GetValueOrDefault(DateTime.UtcNow).AddMinutes(timezoneOffset).ToShortDateString();
endDate.Value = model.GridConditions.EndDate.HasValue
? model.GridConditions.EndDate.Value.AddMinutes(timezoneOffset).ToShortDateString()
: DateTime.UtcNow.AddMinutes(timezoneOffset).ToShortDateString();
}
private FilterResult FilterData(SystemLoadService svc, SystemLoadWaitsViewModel viewModel, bool isDownload, IQualityIndicatorService qualityIndicatorService)
{
var grid = svc.Waits(viewModel.GridConditions, viewModel.FilterConditions, viewModel.FilterOperands);
var sysInfo = svc.ReadSystemInformation().ToList();
var aaData = grid.Data.Select(d => new string[] {
$"{d.SummaryDayHour.ToShortDateString()} {d.SummaryDayHour.ToString("t")}",
$"{d.Server} ({d.ServerId})",
isDownload
? d.OverallScore.ToString()
:$"<span class='{qualityIndicatorService.GetCssClassForScore(d.OverallScore, false)}'>{d.OverallScore}</span>",
$"{d.SignalWaitsRatio}%",
d.PercentOfCPUThreshold.ToString("f2"),
isDownload
? d.WaitType
: $"<div style='display:inline-block;' title='{d.WaitDescription}'>{d.WaitType}</div>",
d.SignalWaitTime.ToString(),
d.TotalWaitTime.ToString(),
d.DifferentialWaitingTasksCount.ToString(),
d.IsPoisonWait ? "Yes" : "No",
d.IsActiveWeeklySample ? "Yes" : "No"
}).ToArray();
return(new kCura.PDD.Web.Controllers.FilterResult()
{
Data = aaData, TotalRecordCount = grid.Count
});
}
private FilterResult FilterData(UserExperienceService svc, UserExperienceServerViewModel viewModel, bool isDownload, IQualityIndicatorService qualityIndicatorService)
{
var grid = svc.ServerWorkspaces(viewModel.GridConditions, viewModel.FilterConditions, viewModel.FilterOperands);
var aaData = grid.Data.Select(d => new string[] {
$"{d.SummaryDayHour.ToShortDateString()} {d.SummaryDayHour:t}",
isDownload ?
$"{d.Server} ({d.ServerId})"
: string.Format(HoursLinkFormat, d.ServerId, string.Empty, $"{d.Server} ({d.ServerId})"),
isDownload
? d.Score.ToString()
:$"<span class='{qualityIndicatorService.GetCssClassForScore(d.Score, false)}'>{d.Score}</span>",
isDownload ?
$"{d.Workspace} ({d.WorkspaceId})"
: string.Format(HoursLinkFormat, d.ServerId, $"&Workspace={d.WorkspaceId}", $"{d.Workspace} ({d.WorkspaceId})"),
d.TotalLongRunning.ToString(),
d.TotalUsers.ToString(),
d.TotalSearchAudits.ToString(),
d.TotalNonSearchAudits.ToString(),
d.TotalAudits.ToString(),
d.TotalExecutionTime.ToString(),
d.IsActiveWeeklySample ? "Yes" : "No"
}).ToArray();
return(new FilterResult()
{
Data = aaData, TotalRecordCount = grid.Count
});
}
private FilterResult FilterData(BackupDbccService svc, RecoverabilityIntegrityViewModel viewModel, bool isDownload, IQualityIndicatorService qualityIndicatorService)
{
var grid = svc.RecoverabilityIntegritySummary(viewModel.GridConditions, viewModel.FilterConditions, viewModel.FilterOperands);
var aaData = grid.Data.Select(d => new string[] {
d.FriendlySummaryDayHour,
isDownload ?
d.RecoverabilityIntegrityScore.ToString()
: $"<span class='{qualityIndicatorService.GetCssClassForScore(d.RecoverabilityIntegrityScore, false)}'>{d.RecoverabilityIntegrityScore}</span>",
isDownload ?
d.BackupFrequencyScore.ToString()
: $"<span class='{qualityIndicatorService.GetCssClassForScore(d.BackupFrequencyScore, false)}'>{d.BackupFrequencyScore}</span>",
isDownload ?
d.BackupCoverageScore.ToString()
: $"<span class='{qualityIndicatorService.GetCssClassForScore(d.BackupCoverageScore, false)}'>{d.BackupCoverageScore}</span>",
isDownload ?
d.DbccFrequencyScore.ToString()
: $"<span class='{qualityIndicatorService.GetCssClassForScore(d.DbccFrequencyScore, false)}'>{d.DbccFrequencyScore}</span>",
isDownload ?
d.DbccCoverageScore.ToString()
: $"<span class='{qualityIndicatorService.GetCssClassForScore(d.DbccCoverageScore, false)}'>{d.DbccCoverageScore}</span>",
isDownload ?
d.RPOScore.ToString()
: $"<span class='{qualityIndicatorService.GetCssClassForScore(d.RPOScore, false)}' title='{(d.RPOScore < 100 ? d.PotentialDataLossMinutes + " minute(s) of potential data loss on "+ d.WorstRPODatabase : String.Empty)}'>{d.RPOScore}</span>",
isDownload ?
d.RTOScore.ToString()
: $"<span class='{qualityIndicatorService.GetCssClassForScore(d.RTOScore, false)}' title='{(d.RTOScore < 100 ? "Estimated " + d.EstimatedTimeToRecoverHours + " hours(s) to restore "+ d.WorstRTODatabase : String.Empty)}'>{d.RTOScore}</span>"
}).ToArray();
return(new kCura.PDD.Web.Controllers.FilterResult()
{
Data = aaData, TotalRecordCount = grid.Count
});
}
private FilterResult FilterData(SystemLoadService svc, SystemLoadServerViewModel viewModel, bool IsDownload, IQualityIndicatorService qualityIndicatorService)
{
var grid = svc.ServerHours(viewModel.GridConditions, viewModel.FilterConditions, viewModel.FilterOperands);
var sysInfo = svc.ReadSystemInformation().ToList();
var aaData = grid.Data.Select(d => new string[] {
IsDownload
? $"{d.SummaryDayHour.ToShortDateString()} {d.SummaryDayHour.ToString("t")}"
: $"<a href='{GetPageUrl(Names.Tab.ServerHealth, "ServerHealth", $"startDate={d.SummaryDayHour.ToShortDateString()}&endDate={d.SummaryDayHour.ToShortDateString()}")}' target='_parent'>{ d.SummaryDayHour.ToShortDateString()} {d.SummaryDayHour.ToString("t")} </a>",
IsDownload
? string.Format("{0} ({1})", d.Server, d.ServerId)
: string.Format(@"<div style=""display:inline-block"" title=""{0}"" data-placement=""right"">{1}</div>",
(sysInfo.FirstOrDefault(i => i.ServerArtifactId == d.ServerId) ?? new SystemInformation()).SummaryHtml,
string.Format("{0} ({1})", d.Server, d.ServerId)
),
d.ServerType,
IsDownload ?
d.OverallScore.ToString()
: $"<span class='{qualityIndicatorService.GetCssClassForScore(d.OverallScore, false)}'>{d.OverallScore}</span>",
IsDownload ?
d.CPUScore.ToString()
: $"<a href='{GetPageUrl(Names.Tab.ServerHealth, "ServerHealth", $"startDate={d.SummaryDayHour.ToShortDateString()}&endDate={d.SummaryDayHour.ToShortDateString()}&measureType={(int)MeasureTypes.Processor}")}' target='_parent'>" +
$"<span class='{qualityIndicatorService.GetCssClassForScore(d.CPUScore, false)}'>{d.CPUScore}</span>" +
$"</a>",
IsDownload ?
d.RAMScore.ToString()
: $"<a href='{GetPageUrl(Names.Tab.ServerHealth, "ServerHealth", $"startDate={d.SummaryDayHour.ToShortDateString()}&endDate={d.SummaryDayHour.ToShortDateString()}&measureType={(int)MeasureTypes.Ram}")}' target='_parent'>" +
$"<span class='{qualityIndicatorService.GetCssClassForScore(d.RAMScore, false)}'>{d.RAMScore}</span>" +
$"</a>",
IsDownload || d.ServerType != "SQL"
? d.FriendlyMemorySignalStateScore
: $"<div style='display:inline-block' title='{d.MemorySignalStateRatio}% occurence of low memory<br/>{d.Pageouts} pageout(s)' data-placement='right'>" +
$"<span class='{qualityIndicatorService.GetCssClassForScore(d.MemorySignalStateScore, false)}'>{d.MemorySignalStateScore}</span>" +
$"</div>",
IsDownload || d.ServerType != "SQL"
? d.FriendlyWaitsScore
: $"<a href='{GetPageUrl(d.ServerId, "Waits", $"Server={d.ServerId}&Hour={d.SummaryDayHour.ToString("s")}")}' target='_self'>" +
$"<b class='{qualityIndicatorService.GetCssClassForScore(d.WaitsScore, false)}'>{d.FriendlyWaitsScore}</b>" +
$"</a>",
IsDownload || d.ServerType != "SQL"
? d.FriendlyVirtualLogFilesScore
:$"<div style='display:inline-block' title='{(d.MaxVirtualLogFiles > 0 ? d.MaxVirtualLogFiles + "virtual log file(s)" : string.Empty)}' data-placement='right'>" +
$"<b class='{qualityIndicatorService.GetCssClassForScore(d.VirtualLogFilesScore, false)}'>{d.FriendlyVirtualLogFilesScore}</b>" +
$"</div>",
IsDownload || d.ServerType != "SQL"
? d.FriendlyLatencyScore
: $"<div style='display:inline-block' " +
$"title='{(!string.IsNullOrEmpty(d.HighestLatencyDatabase) ? string.Format("{0} ({1} File)<br/>Read Latency: {2} ms<br/>Write Latency: {3} ms", d.HighestLatencyDatabase, d.DatabaseFileType, d.ReadLatencyMs, d.WriteLatencyMs) : string.Empty)} ' data-placement='right'>" +
$"<b class='{qualityIndicatorService.GetCssClassForScore(d.LatencyScore, false)}'>{d.FriendlyLatencyScore}</b>" +
$"</div>",
d.IsActiveWeeklySample ? "Yes" : "No"
}).ToArray();
return(new kCura.PDD.Web.Controllers.FilterResult()
{
Data = aaData, TotalRecordCount = grid.Count
});
}
private FilterResult FilterData(BackupDbccService svc, RecoveryObjectivesViewModel viewModel, bool isDownload, IQualityIndicatorService qualityIndicatorService)
{
var grid = svc.RecoveryObjectivesSummary(viewModel.GridConditions, viewModel.FilterConditions, viewModel.FilterOperands);
var aaData = grid.Data.Select(d => new string[] {
$"{d.ServerName} ({d.ServerId})",
d.DatabaseName,
isDownload ?
d.RPOScore.ToString()
: $"<span class='{qualityIndicatorService.GetCssClassForScore(d.RPOScore, false)}'>{d.RPOScore}</span>",
isDownload ?
d.RTOScore.ToString()
:$"<span class='{qualityIndicatorService.GetCssClassForScore(d.RTOScore, false)}'>{d.RTOScore}</span>",
d.PotentialDataLossMinutes.ToString(),
d.EstimatedTimeToRecoverHours.ToString()
}).ToArray();
return(new kCura.PDD.Web.Controllers.FilterResult()
{
Data = aaData, TotalRecordCount = grid.Count
});
}
protected void Page_Load(object sender, EventArgs e)
{
var state = Session[DataTableSessionConstants.SystemLoadServerState] as SystemLoadServerViewModel;
var serverParam = Request.Params["Server"] ?? string.Empty;
//If any query string parameters differ from previous model state filters, build a new model
if (state != null && state.FilterConditions.Server != serverParam)
{
state = null;
}
var model = state ?? new SystemLoadServerViewModel();
Initialize(model, serverParam);
var scores = _systemLoad.GetOverallScores();
QoSNavButton.HRef = QosNavigationUrl;
BtnWaits.HRef = GetPageUrl(Names.Tab.QualityOfService, "Waits");
BtnFileLatency.HRef = GetPageUrl(Names.Tab.QualityOfService, "FileLatencyReport");
QuarterlyScore.Attributes["class"] = _indicatorService.GetCssClassForScore(scores.QuarterlySystemLoadScore, true);
QuarterlyScore.InnerText = _indicatorService.GetIndicatorForScore(scores.QuarterlySystemLoadScore) != PDB.Core.Enumerations.QualityIndicator.None ?
scores.QuarterlySystemLoadScore.ToString() : "N/A";
QuarterlyScore.Attributes["href"] = QosNavigationUrl;
var servers = _systemLoad.ListAllServers().Where(x => x.ArtifactId > 0).ToList();
pageServerSelect.DataValueField = "ArtifactId";
pageServerSelect.DataTextField = "Name";
pageServerSelect.DataSource = servers;
pageServerSelect.DataBind();
if (!string.IsNullOrEmpty(model.FilterConditions.Server))
{
var selectedServer = pageServerSelect.Items.FindByValue(model.FilterConditions.Server);
if (selectedServer != null)
{
selectedServer.Selected = true;
}
}
DateFormatString.Value = DateFormat;
TimeFormatString.Value = TimeFormat;
var timezoneOffset = RequestService.GetTimezoneOffset(this.Request);
startDate.Value = model.GridConditions.StartDate.HasValue
? model.GridConditions.StartDate.Value.AddMinutes(timezoneOffset).ToShortDateString()
: GlassInfo.MinSampleDate.GetValueOrDefault(DateTime.UtcNow).AddMinutes(timezoneOffset).ToShortDateString();
endDate.Value = model.GridConditions.EndDate.HasValue
? model.GridConditions.EndDate.Value.AddMinutes(timezoneOffset).ToShortDateString()
: DateTime.UtcNow.AddMinutes(timezoneOffset).ToShortDateString();
}
protected void Page_Load(object sender, EventArgs e)
{
var state = Session[DataTableSessionConstants.UserExperienceHoursState] as UserExperienceHoursViewModel;
var serverParam = Request.Params["Server"] ?? string.Empty;
var workspaceParam = Request.Params["Workspace"] ?? string.Empty;
//If any query string parameters differ from previous model state filters, build a new model
if (state != null && (state.FilterConditions.Server.ToString() != serverParam || state.FilterConditions.Workspace != workspaceParam))
{
state = null;
}
var model = state ?? new UserExperienceHoursViewModel();
Initialize(model, serverParam, workspaceParam);
var server = _userExperience.ListDatabaseServers().FirstOrDefault(x => x.ArtifactId == model.FilterConditions.Server);
var serverName = server != null
? server.Name
: model.FilterConditions.Server.ToString();
var scores = _userExperience.GetOverallScores();
QoSNavButton.HRef = QosNavigationUrl;
QuarterlyScore.Attributes["class"] = _indicatorService.GetCssClassForScore(scores.QuarterlyUserExperienceScore, true);
QuarterlyScore.InnerText = _indicatorService.GetIndicatorForScore(scores.QuarterlyUserExperienceScore) != PDB.Core.Enumerations.QualityIndicator.None ?
scores.QuarterlyUserExperienceScore.ToString() : "N/A";
QuarterlyScore.Attributes["href"] = QosNavigationUrl;
ReportHeader.InnerHtml = $"Hours View Report<br/>Server: {serverName} ({model.FilterConditions.Server})";
DateFormatString.Value = DateFormat;
TimeFormatString.Value = TimeFormat;
var timezoneOffset = RequestService.GetTimezoneOffset(this.Request);
startDate.Value = model.GridConditions.StartDate.HasValue
? model.GridConditions.StartDate.Value.AddMinutes(timezoneOffset).ToShortDateString()
: GlassInfo.MinSampleDate.GetValueOrDefault(DateTime.UtcNow).AddMinutes(timezoneOffset).ToShortDateString();
endDate.Value = model.GridConditions.EndDate.HasValue
? model.GridConditions.EndDate.Value.AddMinutes(timezoneOffset).ToShortDateString()
: DateTime.UtcNow.AddMinutes(timezoneOffset).ToShortDateString();
}
private FilterResult FilterData(UptimeService svc, UptimeReportViewModel viewModel, bool isDownload, IQualityIndicatorService qualityIndicatorService)
{
var grid = svc.UptimeHours(viewModel.GridConditions, viewModel.FilterConditions, viewModel.FilterOperands);
var aaData = grid.Data.Select(d => new string[]
{
$"{d.SummaryDayHour.ToShortDateString()} {d.SummaryDayHour.ToString("t")}",
isDownload
? $"{d.Score} {(d.AffectedByMaintenanceWindow ? "(Affected By Maintenance Window)" : string.Empty)}"
: $"<span class='{qualityIndicatorService.GetCssClassForScore(d.Score, false)}'>{d.Score} {(d.AffectedByMaintenanceWindow ? "(Affected By Maintenance Window)" : string.Empty)}</span>",
d.Status.ToString(),
d.Uptime.ToString("N2")
}).ToArray();
return(new FilterResult()
{
Data = aaData, TotalRecordCount = grid.Count
});
}