Discuss performance work
Microservices SQL Server Performance

SQL and queue remediation under production load

Anonymized e-commerce adjacent platform: green dashboards, angry customers, and duplicate charges when retries met non-idempotent consumers.

Anonymized case study. Client name and identifying metrics are withheld. Patterns reflect representative senior .NET programs.

Performance review of a .NET API and database

Executive summary

A high-volume order and payment pipeline on .NET microservices showed intermittent timeouts during peak events. Engineers traced SQL blocking, non-idempotent consumers, and broker settings misaligned with database capacity.

StablePeak-week throughput after tuning
BoundedPoison / DLQ rate with replay
↓ MTTRIncidents with trace-linked runbooks

The challenge

Generous retry policies collided with handlers that were not idempotent. SQL showed periodic blocking on hot tables. Load tests never replayed production cardinality.

Technical approach

Execution plan review and index fixes, idempotency keys on payment messages, outbox for critical publishes, consumer concurrency aligned to broker limits, and OpenTelemetry runbooks for on-call.

Outcomes

Peak events completed without prior SLA breaches. Duplicate charge rate dropped to finance-approved levels. On-call used shared dashboards instead of tribal knowledge.

.NET 8SQL ServerAzure Service BusOutbox

Discuss a program like this

Share your constraints and stack—we will outline fit and what proof we can share on a discovery call.