search

BrentOzarULTD / SQL-Server-First-Responder-Kit

sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
http://FirstResponderKit.org
Other
3.34k stars 992 forks source link

sp_BlitzAnalysis - Perfmon stats pivotted resultset #3073

Closed Adedba closed 2 years ago

Adedba commented 2 years ago

Is your feature request related to a problem? Please describe. Currently sp_BlitzAnalysis displays perfmon data in table form per counter per checkdate, this returns a lot of rows to the grid and can make it tricky to spot changes between checkdates for a given counter value.

Describe the solution you'd like We could pivot the resultset for the perfmon data, have it show use 1 row per counter with columns for each check date to allow easier detection of changes between date ranges.

Describe alternatives you've considered Cannot think of any alternatives

Are you ready to build the code for the feature? You bet!

Adedba commented 2 years ago

Example of the Pivoted resultset:

image

Need to be careful of any additonal memory grant as a result of this change as I have noticed that the view 'BlitzFirst_PerfmonStats_Actuals' can get some high memory grants on my SQL instance

BrentOzar commented 2 years ago

Howdy sir. I'm going to go ahead and close this for now to keep the repo tidy, but if you want to come back and work on it later, just open it when you're ready to start doing the pull request. Thanks!