15

Some administrators would find it very useful to obtain the SQL report "Disk usage by top Tables", in order to troubleshoot various SQL performance related issues, however it's not possible to do this in UAT or PROD as there is no RDP access.


An alternative is to export the DB from UAT or PROD and import it into a tier 1 dev machine, however this is a time and resource consuming process for an action that could be done in a few clicks.


Open the SQL Server Management Studio (SSMS).

Right-click AXDB.

Navigate to Reports > Standard Reports.

Click Disk Usage by Top Table

The requested data will be generated in a table.


I would suggest implementing a self-service option to obtain this report in PROD and UAT, maybe in LCS monitoring or in the app itself

STATUS DETAILS
New