public List <MachineMetrics> GetAllMachineMetrics()
{
List <MachineMetrics> list = new List <MachineMetrics>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT MONTH(date_time) as month, YEAR(date_time) as year, " +
"equipment_id, count(*) as times_used, gym_equipment.name " +
"From gym_equipment_usage " +
"INNER JOIN gym_equipment on gym_equipment.id = gym_equipment_usage.equipment_id " +
"GROUP BY MONTH(date_time), YEAR(date_time), equipment_id, gym_equipment.name " +
"ORDER BY times_used DESC", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
MachineMetrics metric = new MachineMetrics();
metric = MapRowToMachineMetrics(reader);
list.Add(metric);
}
return(list);
}
}
catch (SqlException ex)
{
throw;
}
}
public void Can_load_CLR_metrics()
{
Metrics.Clear();
MachineMetrics.InstallCLRLocksAndThreads();
IDictionary <MetricName, IMetric> allMetrics = Metrics.All;
Assert.IsTrue(allMetrics.Count > 0);
}
public void Can_load_all_metrics()
{
Metrics.Clear();
MachineMetrics.InstallAll();
Assert.IsTrue(Metrics.All.Count > 0);
}
public void Can_load_all_metrics()
{
var metrics = new Metrics();
metrics.Clear();
var machineMetrics = new MachineMetrics(metrics);
machineMetrics.InstallAll();
Assert.IsTrue(metrics.All.Count > 0);
}
public void Can_load_all_metrics()
{
var metrics = new Metrics();
metrics.Clear();
var machineMetrics = new MachineMetrics();
machineMetrics.InstallAll();
Assert.IsTrue(metrics.All.Count > 0);
}
public void Can_load_all_metrics()
{
var metrics = new Metrics();
metrics.Clear();
var machineMetrics = new MachineMetrics(metrics);
machineMetrics.Install();
#if !COREFX
Assert.IsTrue(metrics.All.Count > 0);
#endif
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
RegisterGlobalFilters(GlobalFilters.Filters);
RegisterRoutes(RouteTable.Routes);
MachineMetrics.InstallPhysicalDisk();
MachineMetrics.InstallLogicalDisk();
MachineMetrics.InstallCLRLocksAndThreads();
Metrics.Gauge(typeof(MvcApplication), "hey_you_guys", () =>
{
return(12);
});
}
public InstrumentedServiceBase()
{
MachineMetrics.InstallAll();
_listener = new MetricsListener();
}
