appinsights sql check

appinsights-sql-check.cs

using Microsoft.ApplicationInsights;
using Microsoft.ApplicationInsights.DependencyCollector;
using Microsoft.ApplicationInsights.Extensibility;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
            var config = TelemetryConfiguration.Active;
            config.InstrumentationKey = "nope";
            var client = new TelemetryClient();
            var module = new DependencyTrackingTelemetryModule();
            module.Initialize(config);

            using (var conn = new SqlConnection("server=server;initial catalog=master;trusted_connection=true"))
            {
                conn.Open();

                for (var i = 0; i < 600; i += 10)
                {
                    var ts = new TimeSpan(0, 0, i);
                    using (var cmd = new SqlCommand($"waitfor delay '00:{ts.Minutes:00}:{ts.Seconds:00}'", conn))
                    {
                        cmd.CommandTimeout = Int32.MaxValue;
                        client.TrackTrace($"Running SQL query for {ts.TotalSeconds} seconds");
                        cmd.ExecuteNonQuery();
                    }
                }
            }

            client.Flush();
        }
    }
}