Foglight show incorrect (far lower) row count for large partitioned tables
説明
The SQL Server agent shows an incorrect (far lower) row count for large partitioned tables
In the SQL Server Databases panel the Tables & Indexes | Rows column shows a correct value similar to the raw output from a query executed in monitored database,
select t.name, si.rowcnt from sys.tables t (nolock) left outer join sys.indexes i (nolock) on i.object_id=t.object_id left outer join sys.sysindexes si (nolock) on si.id=t.object_id and si.indid=i.index_id
原因
The DBSS_Database_Tables_List collection script use sysindexes.rows to gather table total rows, when table is large and partitioned sysindexes.rows doesn't show correct row count.
対策
WORKAROUND None
STATUS This issue was logged as defect FOG-4222 and is fixed in the 6.2.1.10 and higher releases of the SQL Server cartridge.