Problems
Start from the problem
For blocking, upgrade failure, restore uncertainty, monitoring gaps, and the other situations where the symptom is clear but the next step is not.
MKsql server
SQL Server
guides and help.
Start here when you need to work out whether this is a live SQL Server problem, a planned change, or a broader review that needs outside help.
This page groups the SQL Server work into three usable paths: problem pages for obvious symptoms, guide hubs for deeper technical reading, and service pages for review, triage, or rollout support.
Families
Read by technical area
For operational health, performance, planned change, and recovery work when you already know the technical lane and want the deeper pages grouped together.
Services
Get outside help
Use these service pages for health audits, performance review, recovery readiness, and upgrade support when the team needs practical help rather than more reading.
Problems
Problem pages
These pages help when the problem is obvious but the root cause is not. Each one is built to shorten the first read, the first checks, and the jump to the right deeper guide.
Incident and stabilization
SQL Server blocking problems
Use this when waiting chains, lock pressure, or head blockers are already hurting production and the team needs a faster diagnosis path.
Incident and stabilization
SQL Server slow performance
Use this when the system is just slow enough to hurt work, but the root cause is still fuzzy and every quick guess points somewhere else.
Incident and stabilization
SQL Server deadlock problems
Use this when victims keep showing up, transactions overlap badly, and the team needs a cleaner path than killing sessions and hoping.
Project and planned change
SQL Server failed upgrade
Use this when a version change already went wrong, the rollout confidence is damaged, or the next attempt needs much tighter control.
Incident and stabilization
SQL Server restore not tested
Use this when backups exist, but nobody can say with confidence how recovery would go in practice.
Audit and health review
SQL Server tempdb growth problems
Use this when tempdb growth, spills, version store, or inherited setup choices are starting to leak into wider instability.
Project and planned change
SQL Server patching risk
Use this when the version is aging, the support picture is messy, or patching has started to feel like change work nobody really owns.
Audit and health review
SQL Server backup uncertainty
Use this when backup jobs exist, but retention, proof, and recovery confidence are weak enough that the team should not treat the issue as solved.
Project and planned change
SQL Server migration readiness
Use this when the estate is moving and the real question is whether the plan, rollback, and dependency picture are strong enough yet.
Audit and health review
SQL Server monitoring gaps
Use this when incidents or slowdowns keep happening, but the team still does not have enough visibility to prove the pattern cleanly.
Families
Guides by technical area
These hubs keep related SQL topics together, so you can stay inside one lane instead of bouncing across a flat list of older guide pages.
Operational resilience
Operational resilience and health
Health reviews, tempdb sanity, monitoring gaps, and the operating basics that make a SQL estate easier to trust.
Performance
Performance, blocking, and concurrency
Blocking, deadlocks, waits, indexing, and the deeper reading behind real production performance work.
Planned change
Planned change
Upgrades, migrations, patching risk, and the production change work that needs rehearsal instead of optimism.
Recovery and DR
Recovery, backup, and DR
Backup design, restore proof, failover discipline, and the recovery work behind operational trust.
Services
Service pages
These are the right pages when the issue is already live, the change window is close, or the team wants an external review before making the wrong move.
Audit and health review
SQL Server health audit
Practical review for inherited estates, weak operational ownership, and environments that need a real fix order.
Incident and stabilization
SQL Server performance review
Performance and concurrency review for blocking, deadlocks, broad slowness, and unstable workload behavior.
Incident and stabilization
SQL Server recovery readiness
Backup, restore, and DR review for teams that do not want recovery confidence to stay theoretical.
Project and planned change
SQL Server upgrade support
Upgrade and rollout support for version changes that need readiness review, rollback thinking, and calmer execution.
Older guides
Older guides still worth using
These older SQL guides are still live and still useful. This page just groups them more cleanly so you can reach them by problem or technical area without digging through the whole hub.
operational resilience health
SQL Server health check guide
Environment review, operational drift, restore confidence, and the wider estate questions behind a proper SQL review.
operational resilience health
SQL Server tempdb guide
Tempdb setup, growth behavior, version-store pressure, and the workload clues that usually sit behind tempdb pain.
operational resilience health
SQL Server monitoring guide
Baselines, waits, alerting, backup visibility, and the missing signals that make incidents harder to prove.
operational resilience health
SQL Server sizing guide
Workload profiling, hardware fit, capacity pressure, and the platform questions that sit behind recurring SQL stress.
performance blocking concurrency
SQL Server blocking guide
Blocking chains, head blockers, transaction scope, and the production-safe path to diagnosing recurring contention.
performance blocking concurrency
SQL Server deadlocks guide
Deadlock capture, transaction overlap, indexing causes, and the concurrency patterns behind repeated deadlock victims.
performance blocking concurrency
SQL Server indexing guide
Access-path review, write tradeoffs, and workload-based indexing decisions instead of tuning folklore.
planned change
SQL Server update guide
CU vs GDR, build-number interpretation, and how to separate a patch decision from a real upgrade decision.
planned change
SQL Server latest updates
Live SQL Server supported-build and version-history reference built from Microsoft's update source.
planned change
SQL Server upgrade guide
Version-lifecycle planning, rollout risk, rollback thinking, and the production checks around major SQL changes.
planned change
SQL Server migration guide
Inventory, dependency mapping, rehearsals, rollback design, and cutover planning for real production moves.
recovery backup dr
SQL Server backup guide
Backup strategy, retention, restore proof, and the gaps that only become visible when recovery work becomes real.
recovery backup dr
SQL Server recovery guide
Restore readiness, recovery timing, dependency traps, and the runbook discipline that shortens incidents.
recovery backup dr
SQL Server failover guide
Failover testing, HA tradeoffs, and the operational load that still exists after redundancy is in place.