SqlServer.AdministrativeViews 1.0.270

There is a newer version of this package available.
See the version list below for details.
The owner has unlisted this package. This could mean that the package is deprecated, has security vulnerabilities or shouldn't be used anymore. 
dotnet add package SqlServer.AdministrativeViews --version 1.0.270
                    


                    

                
NuGet\Install-Package SqlServer.AdministrativeViews -Version 1.0.270
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="SqlServer.AdministrativeViews" Version="1.0.270" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="SqlServer.AdministrativeViews" Version="1.0.270" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="SqlServer.AdministrativeViews" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add SqlServer.AdministrativeViews --version 1.0.270
                    


                    

                
#r "nuget: SqlServer.AdministrativeViews, 1.0.270"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package SqlServer.AdministrativeViews@1.0.270
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=SqlServer.AdministrativeViews&version=1.0.270
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=SqlServer.AdministrativeViews&version=1.0.270
                    


                            Install as a Cake Tool

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 including Local DB.

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 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 SDK.

Standalone cli tool is also available without .NET SDK: 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.

There are no supported framework assets in this package.

Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.0.294 0 3/7/2026
1.0.282 13,702 11/28/2025
1.0.276 1,997 11/21/2025
Loading failed