Start here
Health audit
Use this when ownership, monitoring, restore confidence, change risk, and general environment uncertainty are all starting to overlap.
sql 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 an environment that should really start with a health audit.
Start with the health audit if the environment needs a proper review. Use the problem pages when the symptom is obvious, the family hubs when you want to read first, and the service pages when the team already needs hands-on help.
Search SQL content
Search guides, problem pages, checklists, and update references without leaving the SQL section.
sql
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.
Families
Read by technical area
For operational health, performance, planned change, and recovery work when you already know the technical area and want the deeper pages grouped together.
Checklists
Practical checklists
Open this when you want practical SQL Server checklists for health review, recovery, migration, upgrades, and repeat operational checks.
Reference
Error codes
Search SQL Server Database Engine error numbers, severity, event logging, message text, and Microsoft source links when a log only gives you the code.
Services
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.
Live issue
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.
Live issue
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.
Live issue
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.
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.
Live issue
SQL Server restore not tested
Use this when backups exist, but nobody can say with confidence how recovery would go in practice.
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.
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.
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.
Planned change
SQL Server migration readiness
Use this when the environment is moving and the real question is whether the plan, rollback, and dependency picture are strong enough yet.
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
Browse by area
Use these when you want to stay in one part of SQL Server work: resilience, performance, planned change, or recovery.
Operational resilience
Operational resilience and health
Health reviews, tempdb sanity, monitoring gaps, and the operating basics that make a SQL environment 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.
Health review
SQL Server health audit
Practical review for inherited environments, weak operational ownership, and environments that need a real fix order.
Live issue
SQL Server performance review
Performance and concurrency review for blocking, deadlocks, broad slowness, and unstable workload behavior.
Live issue
SQL Server recovery readiness
Backup, restore, and DR review for teams that do not want recovery confidence to stay theoretical.
Planned change
SQL Server upgrade support
Upgrade and rollout support for version changes that need readiness review, rollback thinking, and calmer execution.
More guides
More SQL Server guides
If you want more SQL Server reading, the guides below are still here and still useful.
operational resilience health
SQL Server health check guide
Environment review, operational drift, restore confidence, and the wider environment 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.