使用MiniProfiler小结

//profiler和MiniProfiler.Current是相等的
var profiler = MiniProfiler.StartNew("My Pofiler Name");

using (profiler.Step("CallDataBase")){ ... }

DbConnection cnn = new SqlConnection(@"...");
cnn = new ProfiledDbConnection(cnn, profiler);
DbCommand dbCommand = new SqlCommand("SELECT name FROM [ActionType_lkp]");
dbCommand = new ProfiledDbCommand(dbCommand, cnn, profiler);

using (var wc = new WebClient())
using (profiler.CustomTiming("https", "GET https://www.baidu.com"))
{
  wc.DownloadString("https://www.baidu.com");
}

using (profiler.Step("outer"))
{
  System.Threading.Tasks.Parallel.For(0, 5, i =>
  {
    doWork();
    using (profiler.Step("step " + i))
    {
      doWork();
      using (profiler.Step("sub-step" + i))
      {
        doWork();
      }
    }
  });
}

profiler.Stop();

Console.WriteLine(profiler.RenderPlainText());

protected void Application_Start()
{
  ...
  //NO.1
  GlobalFilters.Filters.Add(new ProfilingActionFilter());
  //NO.2
  var copy = ViewEngines.Engines.ToList();
  ViewEngines.Engines.Clear();
  foreach (var item in copy)
  {
    ViewEngines.Engines.Add(new ProfilingViewEngine(item));
  }
  //NO.3
  MiniProfiler.Configure(new MiniProfilerOptions
  {
    // Different RDBMS have different ways of declaring sql parameters - SQLite can understand inline sql parameters just fine.
    // By default, sql parameters will be displayed.
    //SqlFormatter = new StackExchange.Profiling.SqlFormatters.InlineFormatter(),
    // These settings are optional and all have defaults, any matching setting specified in .RenderIncludes() will
    // override the application-wide defaults specified here, for example if you had both:
    //    PopupRenderPosition = RenderPosition.Right;
    //    and in the page:
    //    @MiniProfiler.Current.RenderIncludes(position: RenderPosition.Left)
    // ...then the position would be on the left on that page, and on the right (the application default) for anywhere that doesn't
    // specified position in the .RenderIncludes() call.
    PopupRenderPosition = RenderPosition.Right,  // defaults to left
    PopupMaxTracesToShow = 10,                   // defaults to 15
    // ResultsAuthorize (optional - open to all by default):
    // because profiler results can contain sensitive data (e.g. sql queries with parameter values displayed), we
    // can define a function that will authorize clients to see the JSON or full page results.
    // we use it on http://stackoverflow.com to check that the request cookies belong to a valid developer.
    ResultsAuthorize = request => request.IsLocal,
    // ResultsListAuthorize (optional - open to all by default)
    // the list of all sessions in the store is restricted by default, you must return true to allow it
    ResultsListAuthorize = request =>
    {
      // you may implement this if you need to restrict visibility of profiling lists on a per request basis
      return true; // all requests are legit in this example
    },
    // Stack trace settings
    StackMaxLength = 256, // default is 120 characters
    // (Optional) You can disable "Connection Open()", "Connection Close()" (and async variant) tracking.
    // (defaults to true, and connection opening/closing is tracked)
    TrackConnectionOpenClose = true
  });
}

protected void Application_BeginRequest()
{
  //NO.4
  // You can decide whether to profile here, or it can be done in ActionFilters, etc.
  // We're doing it here so profiling happens ASAP to account for as much time as possible.
  if (Request.IsLocal) // Example of conditional profiling, you could just call MiniProfiler.StartNew();
  {
    MiniProfiler.StartNew();
  }
}

protected void Application_EndRequest()
{
  //NO.5
  MiniProfiler.Current?.Stop(); // Be sure to stop the profiler!
}

<system.webServer>
    ...
    <handlers>
      <!--NO.6-->
      <add name="MiniProfiler" path="mini-profiler-resources/*" verb="*"
           type="System.Web.Routing.UrlRoutingModule" resourceType="Unspecified"
           preCondition="integratedMode" />
    </handlers>
</system.webServer>

@StackExchange.Profiling.MiniProfiler.Current.RenderIncludes();