topic Re: Microsoft SQL (MSSQL) - Update on DB Insights feature in Open Q&A

Microsoft SQL (MSSQL) - Update on DB Insights feature

ct_27 — Tue, 05 Apr 2022 07:21:21 GMT

In conversation today with DBA team, they brought up asking the status of MS SQL DB Insights and the ability to monitor all SQL Statements that the DB handles. Even if the supported Applications are not in Full Stack.

Does anyone know where DT is with?

Re: Microsoft SQL (MSSQL) - Update on DB Insights feature

ChadTurner — Wed, 11 Jan 2023 15:24:17 GMT

@ct_27 Have you gotten any insight into this? Hopefully you get your question answered with perform being right around the corner. If you do happen to get a timeline or such please share it with the community 🙂

Re: Microsoft SQL (MSSQL) - Update on DB Insights feature

ct_27 — Tue, 25 Apr 2023 13:27:12 GMT

Dynatrace, any response to this? I did not have time to ask this at Perform2023 but our DBAs are still looking for this capability. They had it with the old Oracle Insight and found it useful. They need it for MS SQL.

Also, does the new MS SQL Server monitors inform you of slowest running query for ALL queries, not just those coming through the application layer.

Re: Microsoft SQL (MSSQL) - Update on DB Insights feature

dglugla — Tue, 25 Apr 2023 13:53:53 GMT

Query level visibility is planned to be added to ALL the DB extensions (obviously - depending on the technical possibility).

We already added the simplified version to the Oracle extension (in v1.0.9), MS SQL is next in line, but there's no ETA yet.

Now we're working on the design and release plan for the DB monitoring application leveraging Grail and AppEngine.

Regarding the second question - similarly to the Oracle solution, the DB monitoring extensions will track ALL the queries executed on the server. We're also investigating whether it will be possible to trace the query and its execution performance from client- to the server-layer.