# BrentOzarULTD/SQL-Server-First-Responder-Kit

sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.

Repository: https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit
Canonical: https://ross.abutalabs.com/products/sql-server-first-responder-kit
Homepage: http://FirstResponderKit.org
Language: TSQL
License: NOASSERTION
License Family: other
Topics: sql-server, sp-blitz, sp-blitzcache, sp-blitzindex, sp-blitzfirst, health-checks, ms-sql-server, microsoft-sql-server, first-responder-kit
Last push: 2026-08-23T13:45:40+00:00

## Health v2 (maintenance only)
Score: 93/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 99, release rhythm 80, longevity 100
- inputs: {"age_days": 4475, "days_push": 10, "days_rel": 56, "gap_med": 70.0, "n_releases_24m": 11}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3890, forks 1107 (observed 2026-08-28T04:08:28.337422+00:00)

## What it is
A collection of T-SQL stored procedures (sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and more) for Microsoft SQL Server health checks and performance tuning. It helps DBAs and developers diagnose server issues, find resource-intensive queries, analyze indexes and deadlocks, and manage backups and restores.

## Use cases
- run a sql server health check
- find the most resource-intensive queries on sql server
- analyze missing or unused indexes
- diagnose why sql server is slow right now
- analyze deadlocks in sql server
- automate multi-file database restores
- run a command against every database on a server

## When to choose
- you administer Microsoft SQL Server and need quick diagnostics
- you want free, community-proven performance tuning scripts
- you need real-time advice on a slow server or deadlock analysis

## When to avoid
- you use a database other than Microsoft SQL Server
- you need a GUI monitoring dashboard rather than T-SQL scripts
- you require commercial support or licensing guarantees

## Facets
- artifact type: library
- maturity: active
- function: database, monitoring, benchmarking, developer-tools
- domain: databases, performance, developer-tools
- platform: windows, cli
- tags: sql-server, tsql, stored-procedures, health-checks, performance-tuning, dba-tools, sp-blitz, devops

## Member repositories
- BrentOzarULTD/SQL-Server-First-Responder-Kit (main) score 93

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:28.337422+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:25:37.272602+00:00, confidence not recorded.
  - readme: https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit (fetched 2026-08-28T04:08:28.337422+00:00, sha f6ff4e2f3418)
  - homepage: http://FirstResponderKit.org (fetched 2026-08-29T09:19:27.619047+00:00, sha 004dd7bdee44)
- Data as of 2026-08-30T08:39:29.467469+00:00.