public static void GetMachineStats() { DataSet servers = GetSQLInstances.GetPhysicalMachines(); foreach (DataTable table in servers.Tables) { foreach (DataRow row in table.Rows) { double cpu = GetMachineCPU(row["physicalServerName"].ToString()); double ram = GetMachineRAM(row["physicalServerName"].ToString()); double diskIO = GetDiskReads(row["physicalServerName"].ToString()); SQLMonitorUpdateDB.UpdateServerStats(row["physicalServerName"].ToString(), cpu, ram, diskIO); } } }