# Metricbeat MSSQL module has a really high batch req/sec number **URL:** \ **Category:** Metrics\ **Created:** [February 22, 2022, 8:21am UTC](https://discuss.elastic.co/t/metricbeat-mssql-module-has-a-really-high-batch-req-sec-number/297859 "2022-02-22T08:21:06Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ohs](https://avatars.discourse-cdn.com/v4/letter/o/e8c25b/32.png) [@ohs](https://discuss.elastic.co/u/ohs)\ **Post date:** [February 22, 2022, 8:21am UTC](https://discuss.elastic.co/t/metricbeat-mssql-module-has-a-really-high-batch-req-sec-number/297859/1 "2022-02-22T08:21:06Z")
I have a question about metricbeat mssql module. The server I use it on has an on average batch req/sec like 5 and max about 60, but the value I receive in elastic and see in Kibana is over 19 millions. I can't figure out what kind of number this is. Example below. I default installation. I changed metricbeat.yml to change index names. In mssql.yml I only set correct servername, username and password. ```auto { "_index" : "metricbeat-2022-02-22", "_type" : "_doc", "_id" : "5ENxIH8BCYRw90fICTz0", "_score" : null, "fields" : { "mssql.performance.batch_requests_per_sec" : [ 19131402 ], "@timestamp" : [ "2022-02-22T07:59:12.383Z" ] }, "sort" : [ 1645516752383 ] }, { "_index" : "metricbeat-2022-02-22", "_type" : "_doc", "_id" : "2HZnIH8BAsOAxw_IL_yX", "_score" : null, "fields" : { "mssql.performance.batch_requests_per_sec" : [ 19129762 ], "@timestamp" : [ "2022-02-22T07:48:26.665Z" ] }, "sort" : [ 1645516106665 ] } ``` ---
**Author:** ![TiagoQueiroz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tiagoqueiroz/32/107061_2.png) [@TiagoQueiroz](https://discuss.elastic.co/u/TiagoQueiroz)\ **Post date:** [February 24, 2022, 2:38pm UTC](https://discuss.elastic.co/t/metricbeat-mssql-module-has-a-really-high-batch-req-sec-number/297859/2 "2022-02-24T14:38:02Z")
@Manoj_S_Shetty this seems to be an integration issue, could you take a look at it? ---
**Author:** ![Manoj\_S\_Shetty](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/manoj_s_shetty/32/101950_2.png) [@Manoj\_S\_Shetty](https://discuss.elastic.co/u/Manoj_S_Shetty)\ **Post date:** [March 17, 2022, 9:07am UTC](https://discuss.elastic.co/t/metricbeat-mssql-module-has-a-really-high-batch-req-sec-number/297859/3 "2022-03-17T09:07:06Z")
Hi Tiago, Apology for the Delay in response. Yes I will try to analyze this and get some inputs. Thank you ---
**Author:** ![Manoj\_S\_Shetty](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/manoj_s_shetty/32/101950_2.png) [@Manoj\_S\_Shetty](https://discuss.elastic.co/u/Manoj_S_Shetty)\ **Post date:** [March 17, 2022, 12:24pm UTC](https://discuss.elastic.co/t/metricbeat-mssql-module-has-a-really-high-batch-req-sec-number/297859/4 "2022-03-17T12:24:11Z")
Hello @ohs 🙂 Can you paste the below select statement result snapshot, It might help me in some way. ```auto SELECT object_name, counter_name, instance_name, cntr_value, cntr_type FROM sys.dm_os_performance_counters WHERE counter_name = 'Batch Requests/sec' ``` Thank you Manoj ---
**Author:** ![ohs](https://avatars.discourse-cdn.com/v4/letter/o/e8c25b/32.png) [@ohs](https://discuss.elastic.co/u/ohs)\ **Post date:** [March 17, 2022, 1:33pm UTC](https://discuss.elastic.co/t/metricbeat-mssql-module-has-a-really-high-batch-req-sec-number/297859/5 "2022-03-17T13:33:18Z")
> [@Manoj\_S\_Shetty](#): > > ```auto > SELECT object_name, > counter_name, > instance_name, > cntr_value, > cntr_type > FROM sys.dm_os_performance_counters > WHERE counter_name = 'Batch Requests/sec' > > ``` Hi. Here is the result: | object\_name | counter\_name | instance\_name | cntr\_value | cntr\_type | | --- | --- | --- | --- | --- | | MSSQL$B102655:SQL Statistics | Batch Requests/sec | | 1680140 | 272696576 | ---
**Author:** ![Manoj\_S\_Shetty](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/manoj_s_shetty/32/101950_2.png) [@Manoj\_S\_Shetty](https://discuss.elastic.co/u/Manoj_S_Shetty)\ **Post date:** [March 21, 2022, 1:44pm UTC](https://discuss.elastic.co/t/metricbeat-mssql-module-has-a-really-high-batch-req-sec-number/297859/6 "2022-03-21T13:44:52Z")
Hi @ohs Can you please tell me the version of MSSQL you are using and what is the Query you are running and you are seeing this ` "mssql.performance.batch_requests_per_sec" : [19131402]` ---
**Author:** ![ohs](https://avatars.discourse-cdn.com/v4/letter/o/e8c25b/32.png) [@ohs](https://discuss.elastic.co/u/ohs)\ **Post date:** [March 22, 2022, 6:41am UTC](https://discuss.elastic.co/t/metricbeat-mssql-module-has-a-really-high-batch-req-sec-number/297859/7 "2022-03-22T06:41:03Z")
Hi. MS Sql Server Version Microsoft SQL Server 2016 (SP3) (KB5003279) - 13.0.6300.2 (X64) Aug 7 2021 01:20:37 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor) The query when I get the result is from the mssql module in metricbeat (mssql.yml) so it's not a query I execute. ---
**Author:** ![Manoj\_S\_Shetty](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/manoj_s_shetty/32/101950_2.png) [@Manoj\_S\_Shetty](https://discuss.elastic.co/u/Manoj_S_Shetty)\ **Post date:** [March 23, 2022, 1:50pm UTC](https://discuss.elastic.co/t/metricbeat-mssql-module-has-a-really-high-batch-req-sec-number/297859/8 "2022-03-23T13:50:05Z")
Hi, Tried setting up a MSSQL and exported the MSSQL metrics to Kibana , I Can see below in response: ```auto "_index" : ".ds-metricbeat-8.1.1-2022.03.23-000001", "_id" : "V1oBt38BMkADdcE3q403", "_score" : 1.0, "_source" : { "@timestamp" : "2022-03-23T13:40:13.255Z", "metricset" : { "name" : "performance", "period" : 10000 }, "service" : { "address" : "sqlserver://localhost:1799", "type" : "mssql" }, "mssql" : { "performance" : { "batch_requests_per_sec" : 3766, "page_splits_per_sec" : 78, "lock_waits_per_sec" : 3, "buffer" : { "cache_hit" : { }, "page_life_expectancy" : { } }, "user_connections" : 12, "recompilations_per_sec" : 44, "compilations_per_sec" : 682 } }, ``` Looks for me a normal numbers in batch request/sec metrics. Will you be able to tell me which version of metricbeat you are using? also can you paste the below in Dev Tools and verify the numbers in the response section ```auto GET /_search { "query": { "match_all": {} } } ``` ---
**Author:** ![ohs](https://avatars.discourse-cdn.com/v4/letter/o/e8c25b/32.png) [@ohs](https://discuss.elastic.co/u/ohs)\ **Post date:** [March 23, 2022, 3:01pm UTC](https://discuss.elastic.co/t/metricbeat-mssql-module-has-a-really-high-batch-req-sec-number/297859/9 "2022-03-23T15:01:59Z")
Hi. I'm grateful for the help so far, but we had to implement another solution so we won't be using metricbeat. Thanks. Øistein ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 20, 2022, 3:02pm UTC](https://discuss.elastic.co/t/metricbeat-mssql-module-has-a-really-high-batch-req-sec-number/297859/10 "2022-04-20T15:02:16Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.