sqlinsight-pro

seo/sqlinsight-pro

Fork 0

Commit graph

29c0fb439d Version 1.5.2 main v1.5.2 Søren Eggert Lundsteen Olsen 2026-10-03 09:43:05 +02:00
8db226d2b6 Dynamics AX 3.0: batch STATUS checked against customer data Søren Eggert Lundsteen Olsen 2026-10-03 09:36:56 +02:00
b878fd3ab6 Version 1.5.1: Windows-only tests pass in the Linux CI build v1.5.1 Søren Eggert Lundsteen Olsen 2026-10-02 16:49:05 +02:00
a3af1334e7 Version 1.5.0 v1.5.0 Søren Eggert Lundsteen Olsen 2026-10-02 16:06:36 +02:00
b29ebb424d Review 1.5: docs and appsettings for the reviewed behaviour: timeouts and backoff, new keys, API paging, dedup and redaction Søren Eggert Lundsteen Olsen 2026-10-02 16:06:22 +02:00
b010f37dcf Review 1.5: synthetic checks: "Kør nu" joins the running check, errors are stored once, paused checks are left alone Søren Eggert Lundsteen Olsen 2026-10-02 15:58:06 +02:00
6d8a5d9ad7 Review 1.5: a Windows server that hangs no longer holds up the agent; reads are bounded and backed off Søren Eggert Lundsteen Olsen 2026-10-02 15:57:46 +02:00
f980bd3a4a Review 1.5: synthetic check runner: network surprises are results, AX process never outlives the agent Søren Eggert Lundsteen Olsen 2026-10-02 15:56:17 +02:00
37d3d4b5ec Review 1.5: a check sent back from API v1 with [udeladt] login or URL query is refused, not saved Søren Eggert Lundsteen Olsen 2026-10-02 15:54:38 +02:00
18cd879dbb Review 1.5: server and check pages: one overview query, paused checks are not run, bad numbers refused, seconds kept Søren Eggert Lundsteen Olsen 2026-10-02 15:52:46 +02:00
20829890e9 Review 1.5: API v1 redacts the agent's account, logins, user names and URL queries; history, event log metadata, paging Søren Eggert Lundsteen Olsen 2026-10-02 15:52:45 +02:00
1c9d24a6a2 Review 1.5: repository: reuse waiting agent requests, active findings only on monitored servers and checks, cleanup on removal Søren Eggert Lundsteen Olsen 2026-10-02 15:52:45 +02:00
53ffc008f0 Review 1.5: SQL Scripts describe the reviewed Windows server and check rules Søren Eggert Lundsteen Olsen 2026-10-02 15:44:16 +02:00
7e66dc94c4 Review 1.5: server and check rules never pass unmeasured, cap and stabilize findings, keep sensitive text out of titles Søren Eggert Lundsteen Olsen 2026-10-02 15:44:16 +02:00
2345b199fa Review 1.5: disk forecasts, 24-hour event counts, performance gaps and per-user tasks in Core Søren Eggert Lundsteen Olsen 2026-10-02 15:44:16 +02:00
f27a060e4f Review 1.5: docs: what Windows servers and synthetic checks store, the stricter SQL check, no hub or PDF yet Søren Eggert Lundsteen Olsen 2026-10-02 15:33:04 +02:00
697d243658 Review 1.5: grant-windows-server.ps1 backs up, removes exactly what it gave, and never more than read Søren Eggert Lundsteen Olsen 2026-10-02 15:31:49 +02:00
cb99778a3f Review 1.5: SQL Scripts for Windows servers and synthetic checks follow main's structure and registry Søren Eggert Lundsteen Olsen 2026-10-02 15:18:24 +02:00
8d092b6a35 Review 1.5: the read-only check of typed queries can no longer be bypassed Søren Eggert Lundsteen Olsen 2026-10-02 15:08:34 +02:00
3edc69b48f Servers tests: give the local CIM test room when the whole suite runs at once Søren Eggert Lundsteen Olsen 2026-10-02 14:02:10 +02:00
4c2d5252ad Docs: Windows-servere og syntetiske tjek (1.5) Søren Eggert Lundsteen Olsen 2026-10-02 13:47:37 +02:00
063243532d Web: style the field groups of the synthetic check form Søren Eggert Lundsteen Olsen 2026-10-02 13:43:59 +02:00
1c18bcfab8 Web: Windows-servere and Syntetiske tjek pages, and the same in API v1 (scope config:write) Søren Eggert Lundsteen Olsen 2026-10-02 13:43:42 +02:00
842286d57d SQL Scripts for the Windows server and synthetic check rules (SQLI-WIN-001..013, SQLI-SYN-001..003) Søren Eggert Lundsteen Olsen 2026-10-02 13:32:29 +02:00
6eae719e95 Agent: monitor Windows servers and run synthetic checks; server tests and check runs on request Søren Eggert Lundsteen Olsen 2026-10-02 13:32:29 +02:00
7082b278e3 Collection: Windows servers over CIM (WS-Man, DCOM fallback) and synthetic check runners Søren Eggert Lundsteen Olsen 2026-10-02 13:16:23 +02:00
25ecdbc3e7 Repository: Windows servers, samples, events, synthetic checks and their findings (0018) Søren Eggert Lundsteen Olsen 2026-10-02 13:04:06 +02:00
ba7c751b5c Rules: Windows servers (SQLI-WIN-001..013) and synthetic checks (SQLI-SYN-001..003) Søren Eggert Lundsteen Olsen 2026-10-02 12:55:19 +02:00
ae20954a91 Windows servers and synthetic checks core: data, disk forecast, event dedup, grant script Søren Eggert Lundsteen Olsen 2026-10-02 12:49:07 +02:00
90d37be8a5 Version 1.4.0 v1.4.0 Søren Eggert Lundsteen Olsen 2026-10-02 14:45:31 +02:00
31fa89b385 Review 1.4: AX detection survives passing errors; revoke only what the grant gave; smaller fixes Søren Eggert Lundsteen Olsen 2026-10-02 14:45:31 +02:00
13f22c7541 Review 1.4: AX batch rules: one finding per job, stuck jobs only once, no crash without a start Søren Eggert Lundsteen Olsen 2026-10-02 14:29:35 +02:00
8365ba5357 Review 1.4: AX pages and API leave out removed instances; bounded, complete reads Søren Eggert Lundsteen Olsen 2026-10-02 14:29:34 +02:00
f4d2603181 Review 1.4: AX texts in API v1 and the hub without logins or host names; API has what the pages show Søren Eggert Lundsteen Olsen 2026-10-02 14:29:34 +02:00
66ed4e11b3 Review 1.4: AX 3.0/4.0 local times in the AX time zone, with its DST rules Søren Eggert Lundsteen Olsen 2026-10-02 14:19:17 +02:00
fdaa7e76bf Review 1.4: the AX batch history watermark no longer gets stuck Søren Eggert Lundsteen Olsen 2026-10-02 14:15:49 +02:00
be039a6f73 Review 1.4: AX reads put the agent's session settings back Søren Eggert Lundsteen Olsen 2026-10-02 14:14:24 +02:00
3a0bbe22f1 Review 1.4: SQL Scripts for Dynamics AX in the 1.3 structure Søren Eggert Lundsteen Olsen 2026-10-02 14:11:45 +02:00
08cd741b52 Dynamics AX: notice a GRANT within minutes, one AX lookup per custom-rule run Søren Eggert Lundsteen Olsen 2026-10-02 13:51:37 +02:00
cd72f14883 Docs: Dynamics AX (1.4) Søren Eggert Lundsteen Olsen 2026-10-02 13:37:22 +02:00
d574057114 Integration tests: fake Axapta 3.0 (bmssa) and AX 2012 R2 databases Søren Eggert Lundsteen Olsen 2026-10-02 13:35:16 +02:00
e2284657ae Web and API v1: Dynamics AX pages and endpoints Søren Eggert Lundsteen Olsen 2026-10-02 13:35:16 +02:00
3e1cc74f0e Dynamics AX rules SQLI-AX-001..010 and their SQL Scripts Søren Eggert Lundsteen Olsen 2026-10-02 13:18:02 +02:00
36ad4c0656 Repository and agent: Dynamics AX history (migration 0017), seeding, hub opt-in Søren Eggert Lundsteen Olsen 2026-10-02 13:05:45 +02:00
6b945295d0 Dynamics AX collectors: shared detector, batch jobs, number sequences and RecId Søren Eggert Lundsteen Olsen 2026-10-02 13:00:31 +02:00
4ebae4efe6 Dynamics AX core: central detector, per-version schema adapters, read-access GRANT Søren Eggert Lundsteen Olsen 2026-10-02 12:53:22 +02:00
66aa47ecb3 Deadlocks: read system_health files without a temp table Søren Eggert Lundsteen Olsen 2026-10-02 13:47:31 +02:00
631edc2adc Review 1.3: SQL Scripts for database discovery and the permission check v1.3.0 Søren Eggert Lundsteen Olsen 2026-10-02 13:26:16 +02:00
473dccafff Version 1.3.0 Søren Eggert Lundsteen Olsen 2026-10-02 13:09:15 +02:00
12cf5a1e94 Review 1.3: a request that fails in an unexpected way is completed as failed, not left Running Søren Eggert Lundsteen Olsen 2026-10-02 13:09:02 +02:00
a6a72661e7 Review 1.3: a routine discovery that could not be stored is not retried every 2 seconds Søren Eggert Lundsteen Olsen 2026-10-02 13:08:18 +02:00
f0c5d01294 Review 1.3: the overview works before the agent has migrated to 0016 Søren Eggert Lundsteen Olsen 2026-10-02 13:07:32 +02:00
a66e3f2b3b Review 1.3: upgrade note on AX findings to the hub (now opt-in per database) Søren Eggert Lundsteen Olsen 2026-10-02 13:04:55 +02:00
f5ff42ca83 Review 1.3: an unreadable agent key file is kept, not overwritten Søren Eggert Lundsteen Olsen 2026-10-02 13:03:44 +02:00
356e102126 Review 1.3: redact logins and user names in the configuration API Søren Eggert Lundsteen Olsen 2026-10-02 13:02:35 +02:00
cade91aa4a Review 1.3: a request still waiting for the agent is reused, not queued again Søren Eggert Lundsteen Olsen 2026-10-02 13:02:35 +02:00
2adeef4597 Review 1.3: local Administrators may change the configuration until AdminGroups is set; MSI property ADMIN_GROUPS Søren Eggert Lundsteen Olsen 2026-10-02 12:57:19 +02:00
8e1b877fda Review 1.3: overview leaves out removed instances and marks paused ones Søren Eggert Lundsteen Olsen 2026-10-02 12:54:14 +02:00
4c65248727 Review 1.3: an instance removed from the configuration file is marked removed, not deleted Søren Eggert Lundsteen Olsen 2026-10-02 12:40:03 +02:00
01c04ac95a Review 1.3: database choice and discovery take turns (sp_getapplock) Søren Eggert Lundsteen Olsen 2026-10-02 12:39:28 +02:00
29e1909e98 Review 1.3: one implementation of a service account's SQL login Søren Eggert Lundsteen Olsen 2026-10-02 12:39:07 +02:00
5ad9355130 Docs: Servere og databaser (1.3) Søren Eggert Lundsteen Olsen 2026-10-02 12:11:35 +02:00
f3ef0cbec7 Web: Servere og databaser, and the same in API v1 (scope config:write) Søren Eggert Lundsteen Olsen 2026-10-02 12:08:38 +02:00
81b8376026 Agent: instances from the repository, request queue, sealed passwords, AX hub opt-in Søren Eggert Lundsteen Olsen 2026-10-02 11:52:30 +02:00
b2fa78411f Collectors: monitor only chosen databases; database discovery and permission check Søren Eggert Lundsteen Olsen 2026-10-02 11:44:21 +02:00
1199b1aa86 Repository: configured instances, discovered databases, agent request queue (0016) Søren Eggert Lundsteen Olsen 2026-10-02 11:39:06 +02:00
8776faefb3 Instance configuration core: database selection, sealed credentials, agent request contracts Søren Eggert Lundsteen Olsen 2026-10-02 11:33:43 +02:00
2284e7f082 SQL Scripts: one reviewable script per rule Søren Eggert Lundsteen Olsen 2026-10-02 13:20:06 +02:00
28bd148691 Version 1.2.0 v1.2.0 Søren Eggert Lundsteen Olsen 2026-10-02 11:47:20 +02:00
d9e3b4ee6d Review 1.2: read only the default trace's current file between rollovers Søren Eggert Lundsteen Olsen 2026-10-02 11:38:34 +02:00
8e551bcaa6 Review 1.2: document the new collection limits Søren Eggert Lundsteen Olsen 2026-10-02 11:35:54 +02:00
3f2e959f18 Review 1.2: list the new API v1 endpoints in the integration docs Søren Eggert Lundsteen Olsen 2026-10-02 11:35:41 +02:00
d070cd872b Review 1.2: scan the version store for its generators at most hourly Søren Eggert Lundsteen Olsen 2026-10-02 11:35:00 +02:00
4ceb64f2d5 Review 1.2: index usage after a counter reset without a restart Søren Eggert Lundsteen Olsen 2026-10-02 11:34:17 +02:00
a01ec374a4 Review 1.2: keep SQL Server's error message out of the replication reason Søren Eggert Lundsteen Olsen 2026-10-02 11:33:25 +02:00
fcf2466738 Review 1.2: bound the activity collector and avoid duplicate rows Søren Eggert Lundsteen Olsen 2026-10-02 11:32:40 +02:00
a256e4c8cc Review 1.2: say correctly what each error log source shows Søren Eggert Lundsteen Olsen 2026-10-02 11:31:53 +02:00
70934e7562 Review 1.2: error log entries are no longer counted again Søren Eggert Lundsteen Olsen 2026-10-02 11:31:00 +02:00
1bbe5eb8eb Plan analysis test: start from an empty plan cache Søren Eggert Lundsteen Olsen 2026-10-02 11:14:54 +02:00
d27323a1a4 Availability groups: cluster node or witness down (D) Søren Eggert Lundsteen Olsen 2026-10-02 10:56:43 +02:00
6cc65e3c75 Index usage over time and never-updated statistics (8g, F) Søren Eggert Lundsteen Olsen 2026-10-02 10:55:22 +02:00
473a7d0be3 Replication from the distributor (8f) Søren Eggert Lundsteen Olsen 2026-10-02 10:48:46 +02:00
66129d99fc Stopped automatic SQL Server services (8e) Søren Eggert Lundsteen Olsen 2026-10-02 10:43:26 +02:00
4d18d20ab0 tempdb and version store (8c) Søren Eggert Lundsteen Olsen 2026-10-02 10:42:38 +02:00
6f7839d011 Long and large transactions and long-running statements (8b, 8d) Søren Eggert Lundsteen Olsen 2026-10-02 10:36:41 +02:00
e6840e40d7 SQL Server error log without elevated rights (8a) Søren Eggert Lundsteen Olsen 2026-10-02 10:30:41 +02:00
cb2f8fcbce Version 1.1.0: disk, configuration, privilege audit, wait types, explanations, API v1, foldable menu v1.1.0 Søren Eggert Lundsteen Olsen 2026-10-02 10:00:33 +02:00
55fd389d10 Dynamics AX 3.0 reference schema (from a customer's AX 3.0 database) Søren Eggert Lundsteen Olsen 2026-10-02 10:00:33 +02:00
0dc7866808 Separate "check by hand" from "not relevant" for version-gated rules Søren Eggert Lundsteen Olsen 2026-10-02 09:59:50 +02:00
f3551b1bf0 Support cases through the API: create, read and close Søren Eggert Lundsteen Olsen 2026-10-02 09:47:58 +02:00
30d89acbd7 API v1: findings, rules, reports and page data as JSON, with OpenAPI Søren Eggert Lundsteen Olsen 2026-10-02 09:27:10 +02:00
cc71fb12c6 Menu in foldable groups Søren Eggert Lundsteen Olsen 2026-10-02 09:17:43 +02:00
384e1f154f Long operations, full-text rules and statement activity Søren Eggert Lundsteen Olsen 2026-10-02 09:07:29 +02:00
7a908cc28b Explain and assess measurements for the customer Søren Eggert Lundsteen Olsen 2026-10-02 08:57:10 +02:00
20671bfb06 Wait type drill-down with active session sampling Søren Eggert Lundsteen Olsen 2026-10-02 08:50:31 +02:00
4ba7e5195e Privilege audit: sysadmin and server roles with AD unfolding Søren Eggert Lundsteen Olsen 2026-10-02 08:39:56 +02:00
ab8cfcad97 Configuration page with change log Søren Eggert Lundsteen Olsen 2026-10-02 08:12:26 +02:00
ac13e3d826 Disk speed per drive: IOPS, MB/s and latency Søren Eggert Lundsteen Olsen 2026-10-02 08:03:11 +02:00
c2cdb58a27 Version 1.0.4: own deadlocks fixed, AX rules find bmssa tables v1.0.4 Søren Eggert Lundsteen Olsen 2026-10-02 07:40:20 +02:00
f362862b33 AX rules: find the AX system tables in any schema (AX 3.0 uses bmssa) Søren Eggert Lundsteen Olsen 2026-10-02 07:40:19 +02:00