When you want to execute the Batch requests/sec via sys.dm_os_performance_counters every couple of minutes, how do you get the max and min value (meaningful values) by manipulating cntr_value. Any idea? Please help. Thanks.
asked May 18, 2011 at 04:11 PM in Default
To make those values have meaning beyond the immediate use, you would have to capture them somewhere over time. Then you can simply capture a min and max value from the table/file/whatever where you've captured the data.
answered May 18, 2011 at 05:16 PM
Grant Fritchey ♦♦