x

sys.dm_os_performance_counters

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 '11 at 04:11 PM in Default

SqlAdv gravatar image

SqlAdv
274 9 11 13

(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 '11 at 05:16 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
91k 19 21 74

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 '11 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 '11 at 05:13 AM Grant Fritchey ♦♦
Thank you Sir.
May 19 '11 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x21

asked: May 18 '11 at 04:11 PM

Seen: 1297 times

Last Updated: May 18 '11 at 04:11 PM