Post reply

proc to calculate DM_OS_PERFORMANCE_COUNTERS over time interval

  • November 18, 2015 at 9:48 am

    #399345

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

  • December 7, 2015 at 7:17 am

    #1844367

    Thanks for the script.

  • December 7, 2015 at 8:55 am

    #1844414

    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.

  • April 25, 2016 at 4:48 pm

    #1874411

    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 3 (of 3 total)

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