behaviour of older versions of MSSQL

[Gramblicka-DXC]

Hi community,

does anyone posses experience with monitoring older versions of MSSQL (managed) that are out of support like 2012, 2014 for example. Are there any observed issues. Documentation for the extension only states that dynatrace supports as long as the vendor extended support is there. Also AGs version descriptions dont mention usually end of support for apps, its mostly OS/security related. Any info would be appreciated.

[sujit_k_singh]

Hi @Gramblicka-DXC 

You're right that the documentation is sparse on this.

Dynatrace's stance is straightforward:

"This extension supports any version of SQL Server with active extended support by Microsoft."

https://www.dynatrace.com/hub/detail/microsoft-sql-server-2

SQL Server 2012 (EOL: July 2022) and 2014 (EOL: July 2024) are both outside that boundary, so officially unsupported. That said, "unsupported" doesn't always mean "broken" it means no guaranteed compatibility and no SLA on troubleshooting from Dynatrace Support.
For 2012/2014, the Remote (ActiveGate) extension tends to be the safer bet in practice, since it relies on T-SQL queries against system DMVs that have been stable across versions.

Thanks,

Sujit