Share via

I use sql server database to generate real time reports and want minimum impact to the database, what are the best practices?

georgesun78 0 Reputation points
2023-06-16T12:31:26.88+00:00

I use sql server database to generate real time reports and want minimum impact to the database, what are the best practices?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PercyTang-MSFT 12,506 Reputation points Microsoft Vendor
    2023-06-19T07:39:19.0433333+00:00

    Hi @georgesun78

    What kind of real-time reports do you need to generate? In general, we use SSRS for reporting functions.

    https://learn.microsoft.com/en-us/sql/reporting-services/create-deploy-and-manage-mobile-and-paginated-reports?view=sql-server-ver16

    Best regards,

    Percy Tang

    If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.