Choose the collection depth
Use the detailed collector for a Phase-1 architectural assessment or the minimal collector for a faster, lighter evidence share.
← All products
Collect current-state evidence
SQL Server Assessment Collector
Use the open-source SQL Server Assessment Collector to gather repeatable evidence before an architecture, modernization, migration, or remediation engagement. Choose a detailed assessment or a faster limited run, then use the SQL Server and PostgreSQL DBA handbooks to turn findings into practical follow-up work.
- Detailed and minimal collectors
- HTML and Excel output
- Health score and prioritized findings
What it helps you do
A practical path from signal to action
Cover the production estate
Collect architecture, configuration, schema, storage, indexes, performance, security, HA/DR, capacity, and maintenance evidence.
Act on the result
Generate an executive HTML report, an Excel workbook, or both, then continue into the linked SQL Server or PostgreSQL DBA handbook for operational guidance and working scripts.
From the repository
Product facts
- Supported server
- SQL Server 2016+ recommended
- Runtime
- Windows PowerShell 5.1 or PowerShell 7+
- Output
- HTML, Excel, or both; audit log always generated
- Scope
- All user databases or a validated database list
Verified scope
Support and project status
- Project status
- Project
- Engine coverage
- SQL Server: Supported
- Last reviewed
- 2026-09-30
- Evidence
- Repository documentation ↗
Project evidence
Trust and maintenance links
How it works
Typical workflow
Select the collector
Choose the detailed script for architectural evidence or the minimal script for a shorter run.
Run against the SQL endpoint
Provide a SQL credential and optionally select one or more user databases.
Review the evidence
Start with the health score and findings, then inspect the category-based HTML or Excel evidence sections.
Run it yourself
Requirements and quick start
Requirements
- Windows PowerShell 5.1 or PowerShell 7+
- dbatools module
- ImportExcel module for Excel or combined output
- SQL access including VIEW SERVER STATE, database access, and msdb backup history for complete results
Quick start
Install modules
Install-Module dbatools -Scope CurrentUser
Install-Module ImportExcel -Scope CurrentUserRun the detailed HTML assessment
.\Invoke-SqlInitialAssessment.ps1 -ServerIP '192.168.1.100' -Credential $sqlCredential -OpenReportSource: repository README.md ↗. Check the repository for the latest security notes, configuration options, and release status.
Explore another sqloptima product or go straight to the source.