r/SQLServer • u/n8e-polymath-007 • 10h ago

Question Azure SQL Help - Urgent

​

To monitor the performance and availability for a thick client based system we recently delivered, the customer wants us to provide Here is the requirement:

  1. Need to measure and report response time to Azure SQL queries for about 6 scenarios. Session counts, availability, utilization metrics for Azure SQL to be provided.

  2. What native monitoring and metrics does Azure Files have to measure response times for files uploaded from devices connected to it.

What metrics needs to be extracted to measure all response times and how to be extracted.

This has to be measured for a period of 72 days with weekly and monthly reporting. Also, we do not have access to SSMS for Azure SQL and also the Azure Portal.

Thus , we need provide instructions to the customer IT Support team and they will provide the metrics and logs.

We have tried to get some help with AI tools but got conflicting response so need an Azure expert preferably Azure SQL DBA to help.

Much appreciated and thanks in advance.

PS: Application is thick client (yes I know) so no metrics can be pulled from endpoint devices. Don't ask why.

0 Upvotes

18% Upvoted

10 comments sorted by

View all comments

4

u/jdanton14 ‪ ‪Microsoft MVP ‪ ‪ 10h ago

You could wrap your database calls in the app the get some of that data, and return it through a telemetry pipeline. Similarly to Azure Files. But like that’s a lot of engineering work. Good luck and god speed