ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
SQLServer probe reports incorrect values for free space metrics
Article ID: 34336
Updated On:
Products
DX Unified Infrastructure Management (Nimsoft / UIM)
NIMSOFT PROBES
Issue/Introduction
SQLServer probe is returning incorrect space calculations for the following metrics:
- database_size
- free_Size
- fg_free_size
- table_size
The space calculations may be inaccurate, empty or display negative values.
Cause
This is due to the sp_spaceused system stored procedure returning incorrect data. This is most common when the database has had Data Definition Language (DDL) modifications, such as CREATE, ALTER, or DROP statements.
Environment
SQLServer 2008 - 2014.
Resolution
Run the following command to recreate the statistics for the database. Note this can take some time to run on large tables or databases.
DBCC UPDATEUSAGE (DatabaseName)Example:
DBCC UPDATEUSAGE (CA_UIM)Additional Information
Feedback
Yes
No
Powered by
