MS SQL uptime metric key configuration

[Gramblicka-DXC]

Hi,

i work with several database technologies and i wanted to ask about the uptime metric key. Oracle, postgresql, mariadb, mysql and ms sql. All of them have their metric keys setup with unit seconds except of ms sql. Its unit is set to unspecified. Why is it so.

[t_pawlak]

Hi,
This behavior is caused by differences in how the database extensions are implemented, not by the metric itself.
MariaDB/MySQL/PostgreSQL/Oracle -uptime is explicitly defined as time in seconds since startup, so the unit is correctly set to second.
MS SQL (sql-server.uptime) - the metric comes from a different source (DMVs / performance counters), and in this extension the unit was simply not defined, which is why it appears as unspecified.
The value is still in seconds (semantically correct). This is only a metadata issue, not a data issue.
If you want, you can create Custom metric event and set it as seconds, or raise a ticket to Dynatrace