Where do you find the RDL size in SSRS

Kevin Dagostine 0 Reputation points
2023-05-26T17:41:16.64+00:00

I am comparing RDL files between SSRS servers for load balancing purposes and want to make sure that the RDLs are the same in each server.

I can do a RDL name comparison but I need to compare the KB size.
I can see the size column in the Management UI but need to know where this field "Size" is located in the SSRS database to incorporate in my TSQL script.

SSRS version is: 14.0.600.451 (SQL Server 2017 Reporting Services.

Any direct would help.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,860 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Vahid Ghafarpour 20,480 Reputation points
    2023-05-27T16:58:51.3866667+00:00

    In SQL Server Reporting Services (SSRS), the size information of RDL files is stored in the "Catalog" table of the report server database. The "Size" column in the "Catalog" table represents the file size of the RDLs.

    USE YourReportServerDatabaseName;
    
    SELECT Name, Size
    FROM Catalog
    WHERE Type = 2; -- Filter by Type 2 to get only RDL files
    
    
    0 comments No comments

  2. AniyaTang-MSFT 12,416 Reputation points Microsoft Vendor
    2023-05-29T01:27:35.72+00:00

    Hi @Kevin Dagostine

    As Vahid says, report-related information is stored in Catalog tables. My test version is SSRS 2022, but the storage location is similar.

    1

    Best regards,

    Aniya