SQL Server Administration Available

Basic Administration Manual: Blocking, Performance, and Basic Configuration in SQL Server

Ready-to-run DMV scripts to review blocking, waits, and validate MAXDOP, max server memory, and tempdb configuration.

SQL Server 2016+
Language
Spanish
Last updated
2026-07-28
Level
Intermediate
USD 13

100% digital delivery. The manual and files are sent by email after payment is confirmed.

Summary

Problem it solves

Have a set of proven scripts on hand for the daily check of blocking, performance, and configuration in SQL Server, without having to rebuild them every time.

Who it is for

DBAs or system administrators who operate SQL Server in production and need a repeatable technical checklist.

Who it is not for

Anyone who needs a forensic diagnosis of a specific deadlock that has already occurred (see the dedicated blocking and deadlocks guide in the catalog).

What's included

  1. Reviewing blocking: sys.dm_exec_requests and blocking chains
  2. Identifying the head blocker
  3. Capturing recent deadlocks from system_health
  4. Reviewing performance: sys.dm_os_wait_stats
  5. Top queries by CPU and logical reads
  6. Buffer pool and memory status
  7. Missing indexes suggested by the engine
  8. Basic configuration: max server memory
  9. MAXDOP and Cost Threshold for Parallelism
  10. TempDB, recovery model, and autogrowth
  11. Consolidated daily health-check script

Technical information

Engines
SQL Server 2016+
Operating systems
To be defined
Tools
To be defined
Level
Intermediate
Estimated duration
30-45 minutos
Prerequisites
VIEW SERVER STATE permission for diagnostic queries, sysadmin or serveradmin for configuration changes

Included files

  • PDF manual with the diagnostic scripts included in the text

Lab evidence

Lab evidence: in preparation

This guide has no public evidence yet. Once published, it will include anonymized screenshots of the real execution, with no hostnames, private IPs, usernames or client data.

Licenses

Version history

  • 1.0 — 2026-07-28: First published edition.

Other guides for SQL Server

READY FOR THIS GUIDE?

Basic Administration Manual: Blocking, Performance, and Basic Configuration in SQL Server

USD 13