proc to calculate DM_OS_PERFORMANCE_COUNTERS over time interval

  • jheim

    Say Hey Kid

    Points: 709

    Comments posted to this topic are about the item proc to calculate DM_OS_PERFORMANCE_COUNTERS over time interval

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

  • jheim

    Say Hey Kid

    Points: 709

    A couple of more thoughts:

    I originally made this a table-function but had to replace the waitfor with a clunky loop checking getdate(). The function was nice because you could select from it like the original dmv...if you want that version, let me know.

    also, I mention in the description that its based on sql2012 but it should work ok for earlier and may very well be fine for 2014,2016...just that new counters/bases might need to be matched if their "forms" don't fit the matching rules I spec'ed in the proc.

    Finally, what do I use this for...it seemed like everytime I wanted perfmon/os info, I found myself trying to find that page again that described counter types and rewriting the script to calculate...sure I saved the script but often couldn't find it again...I was driving myself crazy...so now I roll this proc out with some of my other DBA stuff to instances like the hallagren jobs and logins script proc.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    jheim (12/7/2015)


    A couple of more thoughts:

    I originally made this a table-function but had to replace the waitfor with a clunky loop checking getdate(). The function was nice because you could select from it like the original dmv...if you want that version, let me know.

    also, I mention in the description that its based on sql2012 but it should work ok for earlier and may very well be fine for 2014,2016...just that new counters/bases might need to be matched if their "forms" don't fit the matching rules I spec'ed in the proc.

    Finally, what do I use this for...it seemed like everytime I wanted perfmon/os info, I found myself trying to find that page again that described counter types and rewriting the script to calculate...sure I saved the script but often couldn't find it again...I was driving myself crazy...so now I roll this proc out with some of my other DBA stuff to instances like the hallagren jobs and logins script proc.

    Thanks for the extra thoughts.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply