Forum Discussion

jayaleck's avatar
jayaleck
New Contributor III
2 months ago
Solved

Systems Diagnostics - Database Sizes math?

Does anyone know how Used (GB) and Unused is derived? Maybe I'm wrong, going to assume it's looking at total_size, total_used, reserved_pages, ect.. Trying to figure out the math, and questioning if ...
System
  • JJones's avatar
    JJones
    2 months ago

    OneStream System Diagnostics is pulling the values from the System database or is running a stored procedure depending on if this is Standard SQL Server or SaaS and then divides the values by 1024 to get each value.

    It pulls from Sys.ResourceStats for SAAS and runs a stored procedure EXEC sp_spaceused @oneresultset = 1 for Standard SQL which returns the values in KB and then does the math to convert to GB

JJones's avatar
JJones
Icon for OneStream Employee rankOneStream Employee
2 months ago

OneStream System Diagnostics is pulling the values from the System database or is running a stored procedure depending on if this is Standard SQL Server or SaaS and then divides the values by 1024 to get each value.

It pulls from Sys.ResourceStats for SAAS and runs a stored procedure EXEC sp_spaceused @oneresultset = 1 for Standard SQL which returns the values in KB and then does the math to convert to GB