sqlinsight-pro/tests/SQLInsight.Rules.Tests
Søren Eggert Lundsteen Olsen 13f22c7541 Review 1.4: AX batch rules: one finding per job, stuck jobs only once, no crash without a start
- Axapta 3.0/4.0 keep a BATCH row per recurrence, so a failed run and the
  next waiting run share a job key and gave two SQLI-AX-001 findings with the
  same subject (the repository kept the last, the hub the first). The batch
  rules now keep one finding per subject, the most severe.
- SQLI-AX-004 treated a single earlier 10-hour run as "normally that long"
  and stayed silent; it now needs BatchHistoryMinimumRuns runs, like
  SQLI-AX-002. A stuck job is SQLI-AX-004's finding only, not also -002's.
- Running(now)!.Value threw for an executing job with neither a start time
  nor a first-seen time (and a negative duration meant clock skew); such jobs
  are skipped.
- SQLI-AX-010 no longer calls every session in an AX database "from Dynamics
  AX", and shows the raw CONTEXT_INFO as sensitive evidence.

Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
2026-10-02 14:29:35 +02:00
..
ActivityRuleTests.cs Long and large transactions and long-running statements (8b, 8d) 2026-10-02 10:36:41 +02:00
AnomalyRuleTests.cs Fase 2: baselines and anomaly detection 2026-09-29 08:01:11 +00:00
AvailabilityRuleTests.cs Availability groups: cluster node or witness down (D) 2026-10-02 10:56:43 +02:00
ConfigurationRuleTests.cs Configuration page with change log 2026-10-02 08:12:26 +02:00
CustomRuleTests.cs Rules the version does not support are "not applicable", not "not measurable" 2026-10-01 16:05:39 +02:00
DatabaseRuleTests.cs Separate "check by hand" from "not relevant" for version-gated rules 2026-10-02 09:59:50 +02:00
DynamicsAxRuleTests.cs Review 1.4: AX batch rules: one finding per job, stuck jobs only once, no crash without a start 2026-10-02 14:29:35 +02:00
ErrorLogRuleTests.cs Review 1.2: say correctly what each error log source shows 2026-10-02 11:31:53 +02:00
IndexRuleTests.cs Index usage over time and never-updated statistics (8g, F) 2026-10-02 10:55:22 +02:00
ManagedInstanceTests.cs Rules the version does not support are "not applicable", not "not measurable" 2026-10-01 16:05:39 +02:00
OperationRuleTests.cs Long operations, full-text rules and statement activity 2026-10-02 09:07:29 +02:00
PatchLevelRuleTests.cs Fase 2: Azure SQL Managed Instance, docs and rule catalog test 2026-09-29 08:23:40 +00:00
PerformanceRuleTests.cs Disk speed per drive: IOPS, MB/s and latency 2026-10-02 08:03:11 +02:00
PlanRuleTests.cs Separate "check by hand" from "not relevant" for version-gated rules 2026-10-02 09:59:50 +02:00
PrivilegeRuleTests.cs Privilege audit: sysadmin and server roles with AD unfolding 2026-10-02 08:39:56 +02:00
QueryStoreRuleTests.cs Rules the version does not support are "not applicable", not "not measurable" 2026-10-01 16:05:39 +02:00
ReplicationRuleTests.cs Replication from the distributor (8f) 2026-10-02 10:48:46 +02:00
RuleCatalogTests.cs Dynamics AX rules SQLI-AX-001..010 and their SQL Scripts 2026-10-02 13:54:23 +02:00
RuleEngineTests.cs Rules the version does not support are "not applicable", not "not measurable" 2026-10-01 16:05:39 +02:00
ServiceRuleTests.cs Stopped automatic SQL Server services (8e) 2026-10-02 10:43:26 +02:00
SQLInsight.Rules.Tests.csproj Dynamics AX rules SQLI-AX-001..010 and their SQL Scripts 2026-10-02 13:54:23 +02:00
SupportLifecycleRuleTests.cs Fase 2: Azure SQL Managed Instance, docs and rule catalog test 2026-09-29 08:23:40 +00:00
TempdbRuleTests.cs tempdb and version store (8c) 2026-10-02 10:42:38 +02:00
TestInstances.cs Fase 1: collectors and rule pack (41 rules) 2026-09-29 06:17:08 +00:00