Karthik's ConfigMgr & Intune Blogsite

This post describes the procedure to troubleshoot the SMS reporting site link performance issues.

 firstly, let's observer what will be impacted if there are performance issues with SMS reporting site link, you will not be able provide ready access to additional data.

·         For example, you might link a report that lists all site codes to another report that lists all recent error messages for a given site code. The source report passes a specific site code to the target report based on the line item in the source report that the user chooses to obtain more information. SMS reports are created in the SMS Administrator Console. They are assigned security and are available for use by anyone with the URL and a Web browser.  The reporting site is the ASP code running SQL queries against views in the SQL database, providing fast performance and no client-side software.  In addition, if charting is desired, Office Web Components can be added to the reporting server, allowing the reports to include charts and graphs of the SMS data.

 The reporting site home page provides a hierarchy of reports, and only the reports that a user has been granted rights to are shown.  The reports can be simple (select, click display, and view), or can have prompted values (select, enter values, click display, view).  The simple (no prompted values) reports can be gathered together into dashboards, which is a single page with multiple reports displayed.

 When the SMS report URL is unresponsive or slow, perform the following procedure: Recycle WMI. If that does not help, recycle the SMS services. This should resolve the issue. If the issue is not resolved even then, verify if IIS is up and running. Also, verify whether SQL database is accessible or not. Even in case the issue still persists, don't worry we have another step - reset the value of AspBufferingLimit in the file located at C:\winnt\system32 \inetsrv\metabase.xml. After performing the above steps Users should be able to view the Reports.