database.benchmarks.yml

# Examples:
# --config plaintext.benchmarks.yml --scenario plaintext --profile aspnet-physical
# --config benchmarks.compose.yml --scenario fortunes --profile aspnet-physical

imports:
  - https://raw.githubusercontent.com/dotnet/crank/master/src/Microsoft.Crank.Jobs.Wrk/wrk.yml

jobs:
  aspnetbenchmarks:
    source:
      repository: https://github.com/aspnet/benchmarks.git
      branchOrCommit: master
      project: src/Benchmarks/Benchmarks.csproj
    readyStateText: Application started.
    variables:
      server: Kestrel
      transport: Sockets
      serverScheme: http
    arguments: "--nonInteractive true --scenarios {{scenario}} --urls {{serverScheme}}://{{serverAddress}}:{{serverPort}} --server {{server}} --kestrelTransport {{transport}} --protocol {{protocol}}"
    environmentVariables:
      database: PostgresQL
      connectionString: Server={{databaseServer}};Database=hello_world;User Id=benchmarkdbuser;Password=benchmarkdbpass;Maximum Pool Size=256;NoResetOnClose=true;Enlist=false;Max Auto Prepare=4

  postgresql:
    source:
      repository: https://github.com/TechEmpower/FrameworkBenchmarks.git
      branchOrCommit: master
      dockerFile: toolset/databases/postgres/postgres.dockerfile
      dockerImageName: postgres_te
      dockerContextDirectory: toolset/databases/postgres
    readyStateText: ready to accept connections
    noClean: true

scenarios:
  fortunes:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbFortunesRaw
    load:
      job: wrk
      variables:
        presetHeaders: html
        path: /fortunes/raw

  fortunes_ef:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbFortunesEf
    load:
      job: wrk
      variables:
        presetHeaders: html
        path: /fortunes/ef

  fortunes_ef_mvc_https:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: MvcDbFortunesEf
        protocol: https
        serverScheme: https        
    load:
      job: wrk
      variables:
        presetHeaders: html
        path: /mvc/fortunes/ef
        serverScheme: https

  fortunes_dapper:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbFortunesDapper
    load:
      job: wrk
      variables:
        presetHeaders: html
        path: /fortunes/dapper

  single_query:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbSingleQueryRaw
    load:
      job: wrk
      variables:
        presetHeaders: json
        path: /db/raw

  single_query_ef:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbSingleQueryRaw
    load:
      job: wrk
      variables:
        presetHeaders: json
        path: /db/ef  

  single_query_dapper:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbSingleQueryDapper
    load:
      job: wrk
      variables:
        presetHeaders: json
        path: /db/dapper 

  multiple_queries:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbMultiQueryRaw
    load:
      job: wrk
      variables:
        presetHeaders: json
        path: /queries/raw?queries=20

  multiple_queries_ef:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbMultiQueryEf
    load:
      job: wrk
      variables:
        presetHeaders: json
        path: /queries/ef?queries=20

  multiple_queries_dapper:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbMultiQueryDapper
    load:
      job: wrk
      variables:
        presetHeaders: json
        path: /queries/dapper?queries=20

  updates:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbMultiUpdateRaw
    load:
      job: wrk
      variables:
        presetHeaders: json
        path: /updates/raw?queries=20

  updates_ef:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbMultiUpdateEf
    load:
      job: wrk
      variables:
        presetHeaders: json
        path: /updates/ef?queries=20

  updates_dapper:
    db:
      job: postgresql
    application:
      job: aspnetbenchmarks
      variables:
        scenario: DbMultiUpdateDapper
    load:
      job: wrk
      variables:
        presetHeaders: json
        path: /updates/dapper?queries=20

profiles:
  local:
    variables:
      serverPort: 5000
      serverAddress: localhost
    jobs: 
      db:
        endpoints: 
          - http://localhost:5010
      application:
        endpoints: 
          - http://localhost:5010
        variables:
          databaseServer: localhost
      load:
        endpoints: 
          - http://localhost:5010

  aspnet-citrine-lin:
    variables:
      serverPort: 5000
      serverAddress: 10.0.0.102
      cores: 28
    jobs: 
      db:
        endpoints: 
          - http://asp-citrine-db:5001
      application:
        endpoints: 
          - http://asp-citrine-lin:5001
        variables:
          databaseServer: 10.0.0.103
      load:
        endpoints: 
          - http://asp-citrine-load:5001

  aspnet-citrine-win:
    variables:
      serverPort: 5000
      serverAddress: 10.0.0.104
      cores: 28
    jobs: 
      db:
        endpoints: 
          - http://asp-citrine-load:5001
      application:
        endpoints: 
          - http://asp-citrine-win:5001
        variables:
          databaseServer: 10.0.0.105
      load:
        endpoints: 
          - http://asp-citrine-db:5001
  
  aspnet-citrine-arm:
    variables:
      serverPort: 5000
      serverAddress: 10.0.0.107
      cores: 32
    jobs: 
      db:
        endpoints: 
          - http://asp-citrine-db:5001
      application:
        endpoints: 
          - http://asp-citrine-arm:5001
        variables:
          databaseServer: 10.0.0.103
      load:
        endpoints: 
          - http://asp-citrine-load:5001
  
  aspnet-citrine-amd:
    variables:
      serverPort: 5000
      serverAddress: 10.0.0.106
      cores: 48
    jobs: 
      db:
        endpoints: 
          - http://asp-citrine-load:5001
      application:
        endpoints: 
          - http://asp-citrine-amd:5001
        variables:
          databaseServer: 10.0.0.105
      load:
        endpoints: 
          - http://asp-citrine-db:5001
  
  aspnet-perf-lin:
    variables:
      serverPort: 5000
      serverAddress: 10.0.0.102
      cores: 12
    jobs: 
      db:
        endpoints: 
          - http://asp-perf-db:5001
      application:
        endpoints: 
          - http://asp-perf-lin:5001
        variables:
          databaseServer: 10.0.0.103
      load:
        endpoints: 
          - http://asp-perf-load:5001

  aspnet-perf-win:
    variables:
      serverPort: 5000
      serverAddress: 10.0.0.110
      cores: 12
    jobs: 
      db:
        endpoints: 
          - http://asp-perf-load:5001
      application:
        endpoints: 
          - http://asp-perf-win:5001
        variables:
          databaseServer: 10.0.0.104
      load:
        endpoints: 
          - http://asp-perf-db:5001