Forum Discussion
Solved
Expensive Query execution need for Customer report
Hello - We are using Azure sql and cloud services. I have the use case where customer should extract the report where yearly data will be included. This is to be dealt with a couple of sql tables whe...
- Hello
if you don't want to have an impact on users. Have you consider creating a SSRS subscription to create the report at night when less or no users are hitting the Azure SQL DB ?
Another possibility is to use Data Virtualization in Azure SQL DB (which is currently in Private Preview https://www.youtube.com/watch?v=oYXCknUvdLA ) with this you can export your table/query to ADSL2 in csv or parquet format
Data Virtualization is Available in SQL Server 2022 and Azure SQL Managed Instance
Regards
Javier
It holds millions of data without partition.
Bremanand , I have a table with 1.5 billion records and no performance issues; SQL Server can handle large data amount without any problem.
The rest of your post is to broad and to vague to give an answer on, please specify and provide more informations.
Assume, there is a sql query that fetches more volume of data. This query will be called through a backend API services to allow customers to download the data in form of json or csv, etc. My question here - how is this report extraction possible without impacting other regular users who uses application? This sort of cost query operation will utilize more server resources which may slowdown the application for other users. Does this answer your question?
