# Limit of number of metric dimension values

**URL:** <https://community.dynatrace.com/t/limit-of-number-of-metric-dimension-values/40548>\
**Category:** Alerting\
**Tags:** dynatrace-managed, problems-classic\
**Created:** [July 6, 2023, 10:30am UTC](https://community.dynatrace.com/t/limit-of-number-of-metric-dimension-values/40548 "2023-07-06T10:30:58Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![jegron](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/jegron/32/12797_2.png) [@jegron](https://community.dynatrace.com/u/jegron)\
**Post date:** [July 6, 2023, 10:30am UTC](https://community.dynatrace.com/t/limit-of-number-of-metric-dimension-values/40548/1 "2023-07-06T10:30:58Z")

</div>

Hi,

I am working with metrics event and metric selector.

I don’t understand why there is so much dimensions with this simple request :

- _sql-server.host.cpus:splitBy(“dt.entity.sql:sql\_server\_host”):max:rollup(avg,5m)_

 ![jegron_0-1688638617091.png](https://global.discourse-cdn.com/dynatrace/original/2X/8/8f43af6558573094ac8e3d6fffd9990441527dc9.png)

In Data Explorer there is only 76 “dimensions”

 ![jegron_1-1688639001923.png](https://global.discourse-cdn.com/dynatrace/original/3X/b/8/b843a281821e7a0dfa6c2b69aa221d56af178a02.png)

Also the documentation is unclear about the behavior once the limit has been reached :

- THROTTLED: The configuration reached the query limits of the metric selector.

Does the alert stop working for the next 24 hours?

Thanks for your help 🙂

---

<div class="post-metadata">

**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Post date:** [July 6, 2023, 11:09am UTC](https://community.dynatrace.com/t/limit-of-number-of-metric-dimension-values/40548/2 "2023-07-06T11:09:42Z")

</div>

Hi,

I would split it per host groups or hosts, if that is possible. It means, creating more than one and filtering entities.

Best regards

---

<div class="post-metadata">

**Author:** ![jegron](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/jegron/32/12797_2.png) [@jegron](https://community.dynatrace.com/u/jegron)\
**Post date:** [August 7, 2023, 8:43am UTC](https://community.dynatrace.com/t/limit-of-number-of-metric-dimension-values/40548/3 "2023-08-07T08:43:16Z")

</div>

Thanks [@AntonPineiro](https://community.dynatrace.com/user/58682)&nbsp;. Sadly adding splitby fields does not change the number of dimension in my case.

---

<div class="post-metadata">

**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Post date:** [August 8, 2023, 7:46am UTC](https://community.dynatrace.com/t/limit-of-number-of-metric-dimension-values/40548/4 "2023-08-08T07:46:00Z")

</div>

Hi,

I do not see another option than reduce scope. Maybe, you can ask Dynatrace ONE or raising some product idea. It is design limitation.

Best regards

---

<div class="post-metadata">

**Author:** ![nicolas\_nguyen](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/nicolas_nguyen/32/28450_2.png) [@nicolas\_nguyen](https://community.dynatrace.com/u/nicolas_nguyen)\
**Post date:** [August 2, 2024, 3:25pm UTC](https://community.dynatrace.com/t/limit-of-number-of-metric-dimension-values/40548/5 "2024-08-02T15:25:05Z")

</div>

Hi,  
We have the exact same problem here , and we also have the same questions unanswered

sql-server.databases.state:splitBy(“dt.entity.sql:sql\_server\_database”,instance,server,database,“database.state”,“database.recovery\_model”):filter(in(“dt.entity.sql:sql\_server\_database”, entitySelector(“type(sql:sql\_server\_database),tag(INOP-Plateforme-Bd:SB)”)),and(ne(“database.state”,RESTORING)))

---

<div class="post-metadata">

**Author:** ![dannemca](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/dannemca/32/7215_2.png) [@dannemca](https://community.dynatrace.com/u/dannemca)\
**Post date:** [August 2, 2024, 8:58pm UTC](https://community.dynatrace.com/t/limit-of-number-of-metric-dimension-values/40548/6 "2024-08-02T20:58:24Z")

</div>

I am also facing the same… in my case, I am testing the Davis Anomaly Detection app, with good results.