Healthie.NET.SqlServer 4.1.2

Prefix Reserved
There is a newer version of this package available.
See the version list below for details.
dotnet add package Healthie.NET.SqlServer --version 4.1.2
                    
NuGet\Install-Package Healthie.NET.SqlServer -Version 4.1.2
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Healthie.NET.SqlServer" Version="4.1.2" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Healthie.NET.SqlServer" Version="4.1.2" />
                    
Directory.Packages.props
<PackageReference Include="Healthie.NET.SqlServer" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Healthie.NET.SqlServer --version 4.1.2
                    
#r "nuget: Healthie.NET.SqlServer, 4.1.2"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package Healthie.NET.SqlServer@4.1.2
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Healthie.NET.SqlServer&version=4.1.2
                    
Install as a Cake Addin
#tool nuget:?package=Healthie.NET.SqlServer&version=4.1.2
                    
Install as a Cake Tool

Healthie.NET - Trust your uptime

Healthie.NET.SqlServer

NuGet

▶ Live demo — board.healthie-dotnet.dev — a read-only Healthie.NET dashboard watching real status pages (Anthropic, OpenAI, GitHub, Cloudflare, and more), built from these packages. Full documentation at healthie-dotnet.dev.

SQL Server IStateProvider implementation for Healthie.NET. Persists pulse checker state to SQL Server or Azure SQL for durable storage across application restarts and across the replicas of a scaled-out deployment.

Installation

dotnet add package Healthie.NET.SqlServer

Usage

using Healthie.StateProviding.SqlServer;

builder.Services
    .AddHealthie(typeof(Program).Assembly)
    .AddHealthieSqlServer(builder.Configuration.GetConnectionString("Healthie")!);

The table is created on startup if it does not exist. The database is not, so create it yourself or point at an existing one. Pass a second argument to store state somewhere other than healthie_pulse_state:

.AddHealthieSqlServer(connectionString, "monitoring.pulse_state");

Writes update first and insert only if nothing was updated, under UPDLOCK, SERIALIZABLE. Those hints are what make concurrent writers safe rather than occasionally colliding on the primary key.

The checker name is the primary key, so it is capped at 450 characters — the longest a SQL Server key column may be. A checker name defaults to its type's full name and does not come close.

Other engines

This is a thin wrapper over Healthie.NET.Relational, which works against any database with an ADO.NET driver.

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
4.1.4 101 9/30/2026
4.1.3 96 9/29/2026
4.1.2 116 9/12/2026
4.1.1 130 8/14/2026
4.1.0 125 7/30/2026
4.0.0 126 7/30/2026

### Fixed

- The dashboard event-log and about dialogs now move focus inside, keep keyboard focus contained,
 close with Escape, and restore focus to the control that opened them.
- Dashboard checker rows now expose selection as a real button alongside their action buttons,
 removing nested interactive controls while preserving whole-row pointer selection.
- A dashboard state-provider failure now shows a recoverable unavailable state with a retry action
 instead of looking like an empty installation with no registered checkers.
- The Blazor sample now keeps the dashboard stylesheet in its static host head, preventing an
 unstyled flash while the interactive head reconnects on a slow network.
- HTTP checker display names and result messages now omit URI user information, query strings, and
 fragments, server-controlled reason phrases, and transport exception details, preventing embedded
 credentials and tokens from reaching stored history, alerts, logs, or the dashboard while requests
 still use the complete configured URI.
- Alert-history persistence now loads durable history before its first post-restart write and
 coalesces changes raised during a slow state-provider write into one latest-state follow-up. This
 preserves earlier alerts without duplicating the new one and avoids an unbounded queue of tasks
 and redundant full-history writes during alert bursts.
- The Web API sample maps its unauthenticated management API and mutation-enabled MCP endpoint only
 in Development, so deploying the sample with a production environment no longer exposes those
 local demonstration surfaces. Liveness and readiness probes remain available.
- History clearing and startup trimming now use optimistic concurrency, so they no longer overwrite
 a check result or setting changed by another replica between the read and write.
- Leader election now serializes schedule changes with leadership transitions and reconciles every
 registered checker's persisted active state and schedule through a bulk read on lease renewal. A
 pause or cadence change made through another replica now reaches the leader, a fresh leader
 removes inactive durable jobs left by the previous process, and reconciliation runs with bounded
 concurrency while an independent lease heartbeat prevents slow scheduler calls from expiring an
 otherwise healthy leader. Partial and cancelled transitions remain tracked until cleanup succeeds,
 and shutdown does not release the lease over work it could not stop.
- CosmosDB multi-state reads now use `ReadManyItemsAsync`, avoiding one sequential network round
 trip per checker during dashboard loads and leader renewal.
- The in-memory lease provider now returns exactly one winner when replicas contend concurrently.
- Coravel, Hangfire, Temporal, and the leader-election decorator now validate schedules before they
 are persisted. Cronos expressions requiring an absent jitter seed are reported as validation
 failures instead of escaping as server errors. The built-in timer also rejects periods outside
 `PeriodicTimer`'s supported range before replacing a working schedule.
- Temporal now preserves Healthie.NET's six-field, leading-seconds cron meaning by translating it
 to Temporal's seven-field seconds form. It rejects Cronos-only relative-day and descending-range
 expressions whose Temporal meaning differs, and fixed periods outside Temporal's supported range,
 before an existing schedule is removed.
- Uptime recording now starts a new observation segment on the first fresh result after a process
 restart, even when its health matches persisted state. Time while no process was observing the
 checker remains unknown, and a transition that finds the bounded queue full is retried by the next
 fresh result.

Full changelog: https://github.com/ivanvyd/Healthie.NET/blob/v4.1.2/CHANGELOG.md