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.

more ▼

asked May 18, 2011 at 04:11 PM in Default

avatar image

274 10 11 16

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered May 18, 2011 at 05:16 PM

avatar image

Grant Fritchey ♦♦
137k 20 44 81

Hi Grant. It is always an honor to get your response. I am confused on how to interpret the values as the cntr_value is incrementing while the cntr_time is changing every ten mins. The table has 2 columns:- the cntr_time and cntr_value cntr_time cntr_value 2011-05-18 09:20:00.203 207446617 2011-05-18 09:30:00.750 207488732 2011-05-18 09:40:01.407 207531059 2011-05-18 09:50:00.383 207572979 Could you please expalain a little bit as the min and max value will be the first entry and the last entry. Is this the expected behavior?

May 19, 2011 at 04:31 AM SqlAdv

Despite the definition that the value is supposed to be a counter of per second batches, it seems to be a cumulative value. It might not be helpful for you unless you then did the math to determine the differences between the times you sample.

May 19, 2011 at 05:13 AM Grant Fritchey ♦♦

Thank you Sir.

May 19, 2011 at 05:30 AM SqlAdv
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 18, 2011 at 04:11 PM

Seen: 1662 times

Last Updated: May 18, 2011 at 04:11 PM

Copyright 2017 Redgate Software. Privacy Policy