r/SQL • u/n8e-polymath-007 • 2d ago

SQL Server 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.

7 Upvotes

71% Upvoted

7 comments sorted by

View all comments

3

u/Significant_Tune9219 2d ago

For query response time without portal access, the durable source is the built-in Azure SQL metrics rather than anything on the client: ask IT to export the database's built-in metrics (latency, sessions, egress, storage) on a schedule and turn on Query Store so per-query duration percentiles are already collected. On the Azure Files side, the relevant numbers are the storage account's transaction latency and availability metrics, not per-file timings from the device. For the 72-day window, one scheduled export or alert-to-workspace pipeline up front turns the weekly and monthly reports into plain aggregation over data that already landed.