proc to calculate DM_OS_PERFORMANCE_COUNTERS over time interval

• jheim

  Say Hey Kid

  Points: 709

  More actions

  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

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  December 7, 2015 at 7:17 am

  #1844367

  Thanks for the script.

• jheim

  Say Hey Kid

  Points: 709

  More actions

  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.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  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.