Enhancement request to add DB Size in MSSQL Extension

Products

• DX SaaS

Issue/Introduction

It's been noticed that MSSQL Extension is not having an important metric of DB size. That is available in Oracle Extension. 

Please raise an ER for the same. Possible queries below:

 

exec sp_spaceused

or 

EXEC sp_helpdb @dbname= 'DB_NAME'

or

SELECT
    DB_NAME() AS [database_name],
    CAST(SUM(
        CAST( (size * 8.0/1024) AS DECIMAL(15,0) )
    ) AS VARCHAR(20)) AS [database_size(MB)]
FROM sys.database_files;

Resolution

 Created a customer ER defect for further triage and prioritization:

DE604291: - Enhancement request to add DB Size in MSSQL Extension

Additional Information

SQL Server 14-18 is supported for these metrics but not SQL Server 13.

SQL Server Storage Metrics