How to find under utilized sql server with dynatrace extension metrics

[kiru]

Pain Journey:
need to check the unused servers or less used servers.

Benefit:
after this servers can be decommisioned

Solution Journey:

[AntonPineiro]

Hi,

What is used vs unused for you?

Best regards

[kiru]

yes,server used and server unused,so that customer can merge some servers together and some can be decmmisioned

regards

Kiru

[AntonPineiro]

Hi,

I cannot follow you. Maybe you are you talking about CPU %?

Best regards

[kiru]

hi

customer is asking to identify ( help report on SQL version, performance, finding under utlized servers)

here sql version and cpu,mem performance done

how to find under utlized sql servers by using sql extension metrics

Hope you understand my question

Regards

kiru

[AntonPineiro]

Hi,

If I understand right, this product idea is to adding some metric to know if a SQL Server is not being used.

Best regards

[kiru]

Hi 

yes ,need to add  some metric to know if a SQL Server is not being used.