Limit of number of metric dimension values

[jegron]

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)

In Data Explorer there is only 76 "dimensions"

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 🙂

[AntonPineiro]

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

[jegron]

Thanks @AntonPineiro . Sadly adding splitby fields does not change the number of dimension in my case.

[AntonPineiro]

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

[nicolas_nguyen]

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)))

[dannemca]

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