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()); } }