public void Calculate_Table_Metrics() { if (_telemetry == null) { return; } string scope = "Database"; Dictionary <string, string> parameters = new Dictionary <string, string>(); using (DatabaseProvider provider = DatabaseProvider.Create("CountStats.sql", Program.Context.ConnectionString)) { var reader = provider.ExecuteReader(); parameters.Add("Database", provider.Database); while (reader.Read()) { for (int col = 1; col < reader.FieldCount; col++) //the first field is table name { parameters["Table"] = reader.GetString(0); parameters["Metric"] = reader.GetName(col); TrackMetric(scope, reader.GetString(0), reader.GetName(col), reader.GetInt64(col), parameters); } } } }
private void GetStatsInDatabase(string connectionString) { if (_telemetry == null) { return; } Dictionary <string, string> parameters = new Dictionary <string, string>(); string scope = "Database"; using (DatabaseProvider provider = DatabaseProvider.Create("CountFileStats.sql", connectionString)) { var reader = provider.ExecuteReader(); parameters.Add("Database", provider.Database); while (reader.Read()) { for (int col = 1; col < reader.FieldCount; col++) //the first field is table name { parameters["Database"] = reader.GetString(0); parameters["Metric"] = reader.GetName(col); TrackMetric(scope, reader.GetString(0), reader.GetName(col), reader.GetInt32(col), parameters); } } } }
public void Count_Active_Test_Plans() { if (_telemetry == null) { return; } string scope = "Database"; Dictionary <string, string> parameters = new Dictionary <string, string>(); using (DatabaseProvider provider = DatabaseProvider.Create("CountActiveTestPlans.sql", Program.Context.ConnectionString)) { int activeTestPlans = (int)provider.ExecuteScalar(); parameters.Add("Database", provider.Database); TrackMetric(scope, FormatMetricName(scope, "Active_Test_Plans"), activeTestPlans, parameters); } }