Is there a way to get Metrics?

5 posts, 1 answers
  1. Steve
    Steve avatar
    1851 posts
    Member since:
    Dec 2008

    Posted 07 Oct 2010 Link to this post

    Open\Undisposed scopes, queries against the db, queries that haven't gone to the db due to cache etc etc? (connections?)
  2. Answer
    TSE
    TSE avatar
    381 posts
    Member since:
    Sep 2008

    Posted 08 Oct 2010 Link to this post

    Hi Steve,

    Did you try using the built-in performance counters / metrics. See this article in the help.

    I especially used the L2 cache metrics a lot.

    Regards

    Henrik

  3. DevCraft banner
  4. Steve
    Steve avatar
    1851 posts
    Member since:
    Dec 2008

    Posted 08 Oct 2010 Link to this post

    That's exactly what I need, thanks!
  5. Steve
    Steve avatar
    1851 posts
    Member since:
    Dec 2008

    Posted 08 Oct 2010 Link to this post

    Where is this logging to?  Can I not programatically extract the data to display on a webpage? :)
  6. TSE
    TSE avatar
    381 posts
    Member since:
    Sep 2008

    Posted 08 Oct 2010 Link to this post

    Hi Steve,

    There's a difference in performance counter and logging.

    If you are referring to the performance counters they can be accessed either from the Server Explorer in VS or programatically using the performance counter API (standard .NET API).

    Logging logs data to a file.

    Regards

    Henrik
Back to Top
DevCraft banner