SqlServer.AdministrativeViews
1.0.255
See the version list below for details.
dotnet add package SqlServer.AdministrativeViews --version 1.0.255
NuGet\Install-Package SqlServer.AdministrativeViews -Version 1.0.255
<PackageReference Include="SqlServer.AdministrativeViews" Version="1.0.255" />
<PackageVersion Include="SqlServer.AdministrativeViews" Version="1.0.255" />
<PackageReference Include="SqlServer.AdministrativeViews" />
paket add SqlServer.AdministrativeViews --version 1.0.255
#r "nuget: SqlServer.AdministrativeViews, 1.0.255"
#:package SqlServer.AdministrativeViews@1.0.255
#addin nuget:?package=SqlServer.AdministrativeViews&version=1.0.255
#tool nuget:?package=SqlServer.AdministrativeViews&version=1.0.255
SQL Server Administrative Veiws CLI
The intended use of the CLI tool is to provide metrics and execution plans for SQL Server queries for Continuous Integration (CI) scenarios as offline interactive report.
It supports SQL Server 2005...2025.
UI Highlights
- Execution plan link to SSMS per query,
- Sql syntax highlighter,
- Light and dark theme support,
- Metrics sorting,
- Database filter,
- Columns chooser.
Installation
dotnet tool install --global SqlServer.AdministrativeViews
or
dotnet tool update --global SqlServer.AdministrativeViews
Example
SqlServer.AdministrativeViews -o "%SYSTEM_ARTIFACTSDIRECTORY%\Reports\{InstanceName}" -all -av
Options
-o "Reports\{InstanceName}" ⇢ Write a report to a file named as sql server or local db instance in the relative folder Report. {InstanceName} placeholder is useful if multiple SQL Servers are passed. Full path is also allowed. Missing folders will be created.
--append-version ⇢ Append the instance version to the above file(s) name.
--all-local-servers ⇢ Include all local sql servers and all Local DB instances. Sql Server Browser service is not required. All instances are discovered by registry and SQL Local DB management API.
-s "(local)\SQLEXPRESS" ⇢ Include local SQLEXPRESS instance.
-cs "TrustServerCertificate=True;Data Source=127.0.0.1,1433;User ID=sa;Password=p@assw0rd!" ⇢ Include local SQL Server on Linux, on a network, or in the cloud.
Parameters -s (server instance), -cs (connection string) may be included multiple times.
-o, --output=VALUE Optional 'Reports\SQL Server' file name
-av, --append-version Append SQL Server version to the above file name
-s, --server=VALUE Specify local or remote SQL Server instance, allow multiple
-cs, --ConnectionString=VALUE Specify connection string, allow multiple
-all, --all-local-servers Include all local SQL Servers and all Local DB instances
-h, -?, --help
See also
This dotnet tool is built for .NET 6.0, 8.0, and 10.0 runtime.
Standalone cli tool is also available: github releases
To install and configure SQL Server on Azure DevOps pipeline, Github Actions, etc please take a look at powershell SqlServer-Version-Management module.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET Framework | net35 is compatible. net40 is compatible. net403 was computed. net45 is compatible. net451 was computed. net452 was computed. net46 is compatible. net461 was computed. net462 is compatible. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 is compatible. net481 was computed. |
-
.NETFramework 3.5
- Theraot.Core (>= 3.2.11)
- Universe.CpuUsage (>= 2.2.778.893)
- Universe.SqlServer.AdministrativeViews (>= 1.0.255)
- Universe.SqlServerJam (>= 2.1.877)
-
.NETFramework 4.0
- Theraot.Core (>= 3.2.11)
- Universe.CpuUsage (>= 2.2.778.893)
- Universe.SqlServer.AdministrativeViews (>= 1.0.255)
- Universe.SqlServerJam (>= 2.1.877)
-
.NETFramework 4.5
- Universe.CpuUsage (>= 2.2.778.893)
- Universe.SqlServer.AdministrativeViews (>= 1.0.255)
- Universe.SqlServerJam (>= 2.1.877)
-
.NETFramework 4.6
- Universe.CpuUsage (>= 2.2.778.893)
- Universe.SqlServer.AdministrativeViews (>= 1.0.255)
- Universe.SqlServerJam (>= 2.1.877)
-
.NETFramework 4.6.2
- Universe.CpuUsage (>= 2.2.778.893)
- Universe.SqlServer.AdministrativeViews (>= 1.0.255)
- Universe.SqlServerJam (>= 2.1.877)
-
.NETFramework 4.8
- Universe.CpuUsage (>= 2.2.778.893)
- Universe.SqlServer.AdministrativeViews (>= 1.0.255)
- Universe.SqlServerJam (>= 2.1.877)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.