Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Visual Studio 2015 & .NET 4.6
  4. ETW - tracing ADO.NET events doesn't seem to work

ETW - tracing ADO.NET events doesn't seem to work

Scheduled Pinned Locked Moved Visual Studio 2015 & .NET 4.6
csharpphpdatabasecomwindows-admin
5 Posts 2 Posters 40 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • G Offline
    G Offline
    Gaston Verelst
    wrote on last edited by
    #1

    I'm trying to work out a procedure for logging applications that use ADO.NET and / or Entity Framework (5). So ETW looks very promising, especially after reading this article: [^] But unfortunately I don't get ETW working on either of my 2 dev machines. Here is the configuration I did: * I created the correct entries in the registry (.../BidInterface/Loader :Path=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\AdoNetDiag.dll) * I did "mofcomp all.mof", registering all the ADO.NET components for WMI. * logman query providers lists all the required providers * I created a file ctrl.guid.adonet referring to: {7ACDCAC8-8947-F88A-E51A-24018F5129EF} 0xFFFFFFFF 5 ADONETDIAG.ETW {914ABDE2-171E-C600-3348-C514171DE148} 0xFFFFFFFF 5 System.Data.1 {A68D8BB7-4F92-9A7A-D50B-CEC0F44C4808} 0xFFFFFFFF 5 System.Data.Entity.1 {C9996FA5-C06F-F20C-8A20-69B3BA392315} 0xFFFFFFFF 5 System.Data.SNI.1 {DCD90923-4953-20C2-8708-01976FB15287} 0x00000000 0 System.Data.OracleClient.1 Then I start logging, run my simple test app and stop logging: logman start adonettrace -pf .\ctrl.guid.adonet -o adonettrace.etl -ets C:\Data\Projects\TestETW\TestETW\bin\Debug\TestETW.exe logman stop adonettrace -ets Looking at the adonettrace.etl file: 8KB (which is the equivalent of an empty log file). I'm running in W8, VS2012. Any suggestions would be highly appreciated! Thanks, Gaston

    Richard DeemingR 1 Reply Last reply
    0
    • G Gaston Verelst

      I'm trying to work out a procedure for logging applications that use ADO.NET and / or Entity Framework (5). So ETW looks very promising, especially after reading this article: [^] But unfortunately I don't get ETW working on either of my 2 dev machines. Here is the configuration I did: * I created the correct entries in the registry (.../BidInterface/Loader :Path=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\AdoNetDiag.dll) * I did "mofcomp all.mof", registering all the ADO.NET components for WMI. * logman query providers lists all the required providers * I created a file ctrl.guid.adonet referring to: {7ACDCAC8-8947-F88A-E51A-24018F5129EF} 0xFFFFFFFF 5 ADONETDIAG.ETW {914ABDE2-171E-C600-3348-C514171DE148} 0xFFFFFFFF 5 System.Data.1 {A68D8BB7-4F92-9A7A-D50B-CEC0F44C4808} 0xFFFFFFFF 5 System.Data.Entity.1 {C9996FA5-C06F-F20C-8A20-69B3BA392315} 0xFFFFFFFF 5 System.Data.SNI.1 {DCD90923-4953-20C2-8708-01976FB15287} 0x00000000 0 System.Data.OracleClient.1 Then I start logging, run my simple test app and stop logging: logman start adonettrace -pf .\ctrl.guid.adonet -o adonettrace.etl -ets C:\Data\Projects\TestETW\TestETW\bin\Debug\TestETW.exe logman stop adonettrace -ets Looking at the adonettrace.etl file: 8KB (which is the equivalent of an empty log file). I'm running in W8, VS2012. Any suggestions would be highly appreciated! Thanks, Gaston

      Richard DeemingR Offline
      Richard DeemingR Offline
      Richard Deeming
      wrote on last edited by
      #2

      What's the CPU setting for your TestETW project?


      "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

      "These people looked deep within my soul and assigned me a number based on the order in which I joined" - Homer

      G 1 Reply Last reply
      0
      • Richard DeemingR Richard Deeming

        What's the CPU setting for your TestETW project?


        "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

        G Offline
        G Offline
        Gaston Verelst
        wrote on last edited by
        #3

        AnyCPU, so running in 64 bits. I have created both entries in the registry (for 32-bit apps and 64-bit apps)

        Richard DeemingR 1 Reply Last reply
        0
        • G Gaston Verelst

          AnyCPU, so running in 64 bits. I have created both entries in the registry (for 32-bit apps and 64-bit apps)

          Richard DeemingR Offline
          Richard DeemingR Offline
          Richard Deeming
          wrote on last edited by
          #4

          GastonV wrote:

          AnyCPU, so running in 64 bits.

          If you've got the "prefer 32-bit" option[^] checked, it will still be running as 32-bit. Did you run the mofcomp adonetdiag.mof command from the 32-bit framework directory as well?


          "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

          "These people looked deep within my soul and assigned me a number based on the order in which I joined" - Homer

          G 1 Reply Last reply
          0
          • Richard DeemingR Richard Deeming

            GastonV wrote:

            AnyCPU, so running in 64 bits.

            If you've got the "prefer 32-bit" option[^] checked, it will still be running as 32-bit. Did you run the mofcomp adonetdiag.mof command from the 32-bit framework directory as well?


            "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

            G Offline
            G Offline
            Gaston Verelst
            wrote on last edited by
            #5

            Hi Richard, The solution was indeed compiling the 32-bit version of the MOF files, so you solved my problem! Thanks for your support, Gaston

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups