Total rows for SQL table different from Row Totals (rows) count in Monitor.

Question

When I open our meter table in SQL Server I get a record count of 13,711.  When I view in Monitor Row Totals (row) under Monitoring, Components, Dataset, Component Name the count is 27,422.  Why the different row count.

In our Sewer Structure feature class, SQL Server query reports 33,691 rows in table.  Monitor reports 168,455 rows using Row Totals (rows).

What total am I seeing in Monitor?

Derek Law · Answer

Hi @MarkChambers1,

For database/geodatabase components based on SQL Server, ArcGIS Monitor queries the "sys.dm_db_partition_stats" view to get information on space usage and row count information.

This inconsistency suggests that perhaps you may need to update statistics and/or indexes on the tables.

Hope this helps,

MarkChambers1 · Answer

I should have mentioned this the geodatabase is branched versioned.

RPGIS · Answer

Hi @MarkChambers1,

I personally have never used Monitor before but I did some simple calculations and the only thing that I can think of is that Monitor may be looking at the different view states whereas your sql table might be the base table. Try comparing the total number of records the sql table but look under views and see if those record totals match what Monitor is looking at.

We look at the view table rather than the base table to see how many active records exist before the base table is updated.