SqlServer.AdministrativeViews 1.0.243

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.243
                    
NuGet\Install-Package SqlServer.AdministrativeViews -Version 1.0.243
                    
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.243" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="SqlServer.AdministrativeViews" Version="1.0.243" />
                    
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.243
                    
#r "nuget: SqlServer.AdministrativeViews, 1.0.243"
                    
#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.243
                    
#: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.243
                    
Install as a Cake Addin
#tool nuget:?package=SqlServer.AdministrativeViews&version=1.0.243
                    
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.

UI includes: • execution plan link to SSMS per query, • sql syntax highlighter, • light and dark theme support, • metrics sorting, • database filter, • columns chooser.

It supports SQL Server 2005...2025. This dotnet tool is built for .NET 6.0, 8.0, and 10.0 runtime.

To install and configure SQL Server on Azure DevOps pipeline, Github Actions, etc please take a look at powershell module SqlServer-Version-Management, https://www.powershellgallery.com/packages/SqlServer-Version-Management

Installation

dotnet tool install --global SqlServer.AdministrativeViews.CLI

or

dotnet tool update --global SqlServer.AdministrativeViews.CLI

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
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 158 3/7/2026
1.0.282 13,702 11/28/2025
1.0.276 1,998 11/21/2025
Loading failed