sqlinsight-pro/tests/SQLInsight.Rules.Tests
Søren Eggert Lundsteen Olsen 0dc7866808 Separate "check by hand" from "not relevant" for version-gated rules
A rule whose topic applies but whose way of measuring needs a newer
version or patch now gives the new outcome ManualCheck with concrete
Danish guidance, instead of NotApplicable. It is marked explicitly per
rule (IRule.ManualCheck) and only used when every missing capability is
a measurement capability (InstanceCapabilities.IsMeasurement): CHECKDB
status (SQLI-DB-009), VLFs (SQLI-DB-011), spills and memory grants
(SQLI-PLAN-004/005) and deadlocks on 2005 (SQLI-DLK-001). Query Store,
AG and Azure-managed topics stay "not relevant".

Shown in a visible "Skal tjekkes manuelt" section on the instance page,
a KPI on the overview, a "Tjek manuelt" column in the management
report's controls, manualChecks in /api/v1/instances and manualCheck in
rule-states; not counted as not measurable.

Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
2026-10-02 09:59:50 +02:00
..
AnomalyRuleTests.cs Fase 2: baselines and anomaly detection 2026-09-29 08:01:11 +00:00
AvailabilityRuleTests.cs Fase 2: Always On availability groups and SQL Agent jobs 2026-09-29 07:53:49 +00: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
IndexRuleTests.cs Fase 2: index and statistics analysis 2026-09-29 07:47:53 +00: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
RuleCatalogTests.cs Long operations, full-text rules and statement activity 2026-10-02 09:07:29 +02:00
RuleEngineTests.cs Rules the version does not support are "not applicable", not "not measurable" 2026-10-01 16:05:39 +02:00
SQLInsight.Rules.Tests.csproj Fase 0: solution structure, capability model, rule engine, least-privilege script 2026-09-29 05:40:49 +00:00
SupportLifecycleRuleTests.cs Fase 2: Azure SQL Managed Instance, docs and rule catalog test 2026-09-29 08:23:40 +00:00
TestInstances.cs Fase 1: collectors and rule pack (41 rules) 2026-09-29 06:17:08 +00:00