Return
-
Title
SQL Server Database File Size over 2TB displayed wrong -
Description
SQL Server databases that are over 2TB (Terabyte) will not report correctly in graphs or growth reports out of Foglight or in WMI queries. Databases File sizes under 2TB are displayed properly. -
Cause
The WMI Win32 Class property is unable to report over 2TB due to an expected limitation in the OS.
Example Class: Win32_PerfRawData_MSSQLSERVER_MSSQLSERVERDatabases
Example Property: DataFilesSizeKB -
Resolution
- Stop the agent(s) that has/could have the issue (feel free to change on others that may reach this size level)
- Open the agent properties ("Edit Properties") and scroll down to "Collection Details"
- Set "SQL Performance Counters collecting method" to "JDBC"
- Save the changes and click on "Back to Agent Status"
- Activate the agent and then check for the correct values being displayed