High row count change

If a production database is having a table with more than 1 million rows and an increase in the number of rows of more than 20 %, this alert is raised.

To query the Performance Store database for tables with high row count changes, use:

select t.*
from dbo.v_table_size_changes t
inner join dbo.v_cms c on c.server_name = t.server_name
where t.post_time >=
(
    select top 1 dateadd(hour, -3, xs.sample_time)
    from dbo.v_execution_info xs
    where xs.batch_executing = 0
    order by xs.sample_time desc
)
and c.is_production = 1
and t.row_count > 1000000
and t.row_count_change_pct > 20

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.