SQL Perfmon计数器-优先值 [英] Sql Perfmon counter - perferred value

问题描述

提到转发记录/秒应为<每100个批处理请求中每秒钟10个，但是当我检查计数器时，发现两个计数器(转发记录/秒和批处理请求/秒)不相关
以下是在某些情况下两个代理的值

访问方法\转发记录/秒:27.82655124,139.7820692，288.8344024
SQL Statistics \批处理请求/秒7.39541227,3.661808194,67.26424444

It is mentioned that Forwarded Records/sec should be < 10 per 100 Batch Requests/Sec, but when I checked the counter I found that the two counters(Forwarded Records/sec & Batch Requests/Sec) are not related
Below are the values for both coounters at some instances respectively

Access Methods\Forwarded Records/sec :27.82655124,139.7820692, 288.8344024
SQL Statistics\Batch Requests/sec 7.39541227,3.661808194,67.26424444

Please can anyone tell why is this variation?

推荐答案

不确定您指定的数字，而是说您拥有
-27个间隔转发的记录
-在相同的时间间隔内有7个批处理请求

这意味着您每个批次有几条转发记录.建议的比例应小于10％.

如果您想知道百分比如何大于100％，请记住每个批次可以更新多个记录.

Not sure about the numbers that you have specified but let''s say that you have
- 27 forwarded records on an inteval
- 7 batch requests on the same interval

this would mean that you have several forwarded records per batch. The recommendation is to have less than 10%.

If you''re wondering how the percentage can be greater that 100%, remember that each batch can update multiple records.

这篇关于SQL Perfmon计数器-优先值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！