internal override void SavePerformanceMetrics()
{
using (var dataContext = new PDDModelDataContext())
{
Logger.LogVerbose("SavePerformanceMetrics Called for RAM", GetType().Name);
try
{
if (ServerList.Count > 0)
{
dataContext.ServerDWs.InsertAllOnSubmit(ServerList.OfType <ServerDW>().ToList());
dataContext.SubmitChanges();
}
Logger.LogVerbose(string.Format("SavePerformanceMetrics Called for RAM - Success. Server Count: {0}", ServerList.Count),
GetType().Name);
}
catch (Exception ex)
{
Logger.LogError(string.Format("SavePerformanceMetrics Called for RAM - Failure. Details: {0}", ex.Message),
GetType().Name);
throw ex;
}
}
}
internal override void SavePerformanceMetrics()
{
using (var dataContext = new PDDModelDataContext())
{
Logger.LogVerbose("SavePerformanceMetrics Called for CPU", this.GetType().Name);
try
{
if (ServerList.Count > 0)
{
dataContext.ServerProcessorDWs.InsertAllOnSubmit(ServerList.OfType <ServerProcessorDW>().ToList());
dataContext.SubmitChanges();
}
Logger.LogVerbose($"SavePerformanceMetrics Called for CPU - Success. Server Count: {ServerList.Count}",
this.GetType().Name);
}
catch (Exception ex)
{
var message = ex.GetExceptionDetails();
Logger.LogError($"SavePerformanceMetrics Called for CPU - Failure. Details: {message}",
GetType().Name);
throw ex;
}
}
}
/// <summary>
/// Get field list for filter display column
/// </summary>
/// <param name="measureType">The measure type</param>
/// <returns>List of key value pairs</returns>
public IList <KeyValue> GetColumnsList(MeasureTypes measureType)
{
using (var context = new PDDModelDataContext())
{
return((from m in context.Measures
where m.MeasureTypeId == (int)measureType && m.IsDeleted != true
select new KeyValueDesc()
{
Key = m.MeasureID,
Value = m.MeasureCd,
Description = m.MeasureDesc
}).OfType <KeyValue>().ToList());
}
}
/// <summary>
/// Get sql server data list
/// </summary>
/// <param name="startDate">The start date</param>
/// <param name="endDate">The end date</param>
/// <param name="timeZoneOffset">The timezone offset</param>
/// <returns>A list of health tasks</returns>
private IList <HealthBase> GetSQLServerData(DateTime?startDate, DateTime?endDate, int timeZoneOffset)
{
using (var context = new PDDModelDataContext())
{
return((from item in context.GetSQLServerSummaryData(startDate, endDate, timeZoneOffset)
select new SqlServerHealth()
{
Id = item.ServerID,
Server = item.ServerName,
ServerType = item.ServerTypeName,
PageLifeExpectancy = item.SQLPageLifeExpectancy,
MeasureDate = item.MeasureDate.Value
}).OfType <HealthBase>().ToList());
}
}
/// <summary>
/// Get processor data list
/// </summary>
/// <param name="startDate">The start date</param>
/// <param name="endDate">The end date</param>
/// <param name="timeZoneOffset">The timezone offset</param>
/// <returns>A list of health tasks</returns>
private IList <HealthBase> GetProcessorData(DateTime?startDate, DateTime?endDate, int timeZoneOffset)
{
using (var context = new PDDModelDataContext())
{
return((from item in context.GetServerProcessorSummaryData(startDate, endDate, timeZoneOffset)
select new ProcesserHealth()
{
Id = Convert.ToInt32(item.ServerCoreId),
Server = item.ServerName,
ServerType = item.ServerTypeName,
ServerCore = item.ServerName,
CPUProcessorTime = item.CPUProcessorTimePct,
ProcesserTime = item.CPUProcessorTimePct,
MeasureDate = Convert.ToDateTime(item.MeasureDate)
}).OfType <HealthBase>().ToList());
}
}
/// <summary>
/// Get ram heath data list
/// </summary>
/// <param name="startDate">The start date</param>
/// <param name="endDate">The end date</param>
/// <param name="timeZoneOffset">The timezone offset</param>
/// <returns>A list of health tasks</returns>
private IList <HealthBase> GetRamHealthData(DateTime?startDate, DateTime?endDate, int timeZoneOffset)
{
using (var context = new PDDModelDataContext())
{
return((from item in context.GetRAMHealthData(startDate, endDate, timeZoneOffset)
select new RamHealth()
{
Id = item.ServerID,
Server = item.ServerName,
ServerType = item.ServerTypeName,
MeasureDate = item.MeasureDate.Value,
PagesPerSec = item.RAMPagesPerSec,
PageFaultsPerSec = item.RAMPageFaultsPerSec,
Percentage = item.RAMPct
}).OfType <HealthBase>().ToList());
}
}
/// <summary>
/// Get the application health data
/// </summary>
/// <param name="startDate">The start date</param>
/// <param name="endDate">The end date</param>
/// <param name="timeZoneOffset">The timezone offset</param>
/// <returns>A list of health tasks</returns>
private IList <HealthBase> GetApplicationHealthData(DateTime?startDate, DateTime?endDate, int timeZoneOffset)
{
using (var context = new PDDModelDataContext())
{
return((from item in context.GetApplicationHealthData(startDate, endDate, timeZoneOffset)
select new ApplicationHealth()
{
Id = Convert.ToInt32(item.Id),
CaseArtifactId = item.CaseArtifactID,
ErrorCount = item.ErrorCount,
LRQCount = item.LRQCount,
UserCount = item.UserCount,
WorkspaceName = item.WorkspaceName,
DatabaseLocation = item.DatabaseLocation,
MeasureDate = item.MeasureDate.Value,
}).OfType <HealthBase>().ToList());
}
}
/// <summary>
/// Get disk data list
/// </summary>
/// <param name="startDate">The start date</param>
/// <param name="endDate">The end date</param>
/// <param name="timeZoneOffset">The timezone offset</param>
/// <returns>A list of health tasks</returns>
private IList <HealthBase> GetHardDiskData(DateTime?startDate, DateTime?endDate, int timeZoneOffset)
{
using (var context = new PDDModelDataContext())
{
return((from item in context.GetServerDiskSummaryData(startDate, endDate, timeZoneOffset)
select new HardDiskHealth()
{
Id = Convert.ToInt32(item.ServerDiskId),
Server = item.ServerName,
ServerType = item.ServerTypeName,
ServerDisk = item.ServerName + "-" + item.DiskNumber.ToString(),
DiskRead = item.DiskAvgSecPerRead,
DiskWrite = item.DiskAvgSecPerWrite,
DiskNumber = item.DiskNumber,
DriveLetter = item.DriveLetter,
MeasureDate = item.MeasureDate.Value
}).OfType <HealthBase>().ToList());
}
}
