private static void UpdateDatabaseWithSnapShot(Data.ApplicationDataSet.InstanceInfoRow dataRow, string snapShotError)
{
try
{
dataRow.SnapShotDate = DateTime.Now;
dataRow.SnapShotError = snapShotError;
Common.ApplicationDataSet.InstanceInfoTA.Update(Common.ApplicationDataSet.InstanceInfo);
}
catch (Exception ex)
{
string errorMessage = string.Format("InstanceInfoRow.ID:{0} - ex:{1} ex.Inner:{2}", dataRow.ID, ex, ex.InnerException);
VNC.AppLog.Error(errorMessage, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 7);
}
}
public static void UpdateDataSet(this MSMO.Server server, Data.ApplicationDataSet.InstanceInfoRow dataRow)
{
try
{
dataRow.PhysicalMemory = server.PhysicalMemory;
//instanceRow.Platform = server.Platform;
dataRow.Processors = server.Processors;
}
catch (Exception ex)
{
// TODO(crhodes):
// Wrap anything above that throws an exception that we want to ignore,
// e.g. property not available because of SQL Edition.
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 0);
}
}
public static void UpdateDataSet(this MSMO.Server server, Data.ApplicationDataSet.InstanceInfoRow instanceRow)
{
try
{
instanceRow.PhysicalMemory = server.PhysicalMemory;
//instanceRow.Platform = server.Platform;
instanceRow.Processors = server.Processors;
}
catch (Exception ex)
{
// TODO(crhodes): Need to wrap anything above that throws an exception
// that we want to ignore, e.g. property not available because of
// SQL Edition.
PLLog.Error(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2);
throw ex;
}
}
public static void TakeInstanceSnapShot(SQLInformation.Data.ApplicationDataSet.InstancesRow instanceRow)
{
#if TRACE
long startTicks = VNC.AppLog.Trace4("Start", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 0);
#endif
Data.ApplicationDataSet.InstanceInfoRow instanceInfoRow = null;
try
{
instanceInfoRow = Common.ApplicationDataSet.InstanceInfo.NewInstanceInfoRow();
instanceInfoRow.SnapShotDate = instanceRow.SnapShotDate;
instanceInfoRow.SnapShotDuration = instanceRow.SnapShotDuration;
instanceInfoRow.SnapShotError = instanceRow.SnapShotError;
instanceInfoRow.Instance_ID = instanceRow.ID;
instanceInfoRow.Name_Instance = instanceRow.Name_Instance;
instanceInfoRow.ADDomain = instanceRow.ADDomain;
instanceInfoRow.Environment = instanceRow.Environment;
instanceInfoRow.SecurityZone = instanceRow.SecurityZone;
instanceInfoRow.PhysicalMemory = instanceRow.PhysicalMemory;
instanceInfoRow.Processors = instanceRow.Processors;
instanceInfoRow.Total_DataSpaceUsage = instanceRow.Total_DataSpaceUsage;
instanceInfoRow.Total_IndexSpaceUsage = instanceRow.Total_IndexSpaceUsage;
instanceInfoRow.Total_Size = instanceRow.Total_Size;
instanceInfoRow.Total_SpaceAvailable = instanceRow.Total_SpaceAvailable;
Common.ApplicationDataSet.InstanceInfo.AddInstanceInfoRow(instanceInfoRow);
Common.ApplicationDataSet.InstanceInfoTA.Update(Common.ApplicationDataSet.InstanceInfo);
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2);
instanceInfoRow.SnapShotDate = DateTime.Now;
instanceInfoRow.SnapShotError = ex.ToString().Substring(0, 256);
Common.ApplicationDataSet.InstanceInfoTA.Update(Common.ApplicationDataSet.InstanceInfo);
}
#if TRACE
VNC.AppLog.Trace4("End", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3, startTicks);
#endif
}
