SQL SERVER AUS DER PRAXIS

SQL Server Ops,
Performance &
Troubleshooting

Practical articles, field notes, and technical analysis around SQL Server, Azure SQL, high availability, migrations, and DBA automation.

blocking-check.sql— Wer blockiert gerade wen?SELECT session_id, blocking_session_id, wait_type, wait_timeFROM sys.dm_exec_requestsWHERE blocking_session_id <> 0;▸ session 54 ← blockiert von 51 · LCK_M_X · 1.8s
plan-check.sql— Welcher Plan hat sich geändert?SELECT qs.query_id, p.plan_id, qs.avg_durationFROM sys.query_store_plan pJOIN sys.query_store_runtime_stats qs;▸ Regression erkannt · Plan 7 → 9 · +480ms
index-maint.sql— Fragmentierung prüfenSELECT OBJECT_NAME(object_id) AS tbl, avg_fragmentation_in_percentFROM sys.dm_db_index_physical_stats( DB_ID(), NULL, NULL, NULL, ‘LIMITED’);▸ 12 Indizes > 30% · Rebuild empfohlen

15+

Jahre DBA-Praxis

7

Themenbereiche

∞

Tickets gelöst

Recommended Posts

Featured SQL Server Articles

Selected posts about SQL Server operations, Azure SQL, high availability, performance, and troubleshooting from real-world work.

PRACTICE, EXPERIENCE AND CONTEXT

A personal technical blog — not a glossy handbook

SQL aus Hamburg is about experience from real projects, technical analysis, common pitfalls and practical approaches that have proven useful in day-to-day work. The articles are written for database administrators, system administrators, consultants and everyone who does not just install SQL Server environments, but wants to operate and support them reliably over the long term.

Practical help with SQL Server problems

Articles, analysis and experience around operations, performance, high availability and troubleshooting – based on real projects and typical DBA situations.