SqlServer.AdministrativeViews
1.0.233
See the version list below for details.
dotnet add package SqlServer.AdministrativeViews --version 1.0.233
NuGet\Install-Package SqlServer.AdministrativeViews -Version 1.0.233
<PackageReference Include="SqlServer.AdministrativeViews" Version="1.0.233" />
<PackageVersion Include="SqlServer.AdministrativeViews" Version="1.0.233" />
<PackageReference Include="SqlServer.AdministrativeViews" />
paket add SqlServer.AdministrativeViews --version 1.0.233
#r "nuget: SqlServer.AdministrativeViews, 1.0.233"
#:package SqlServer.AdministrativeViews@1.0.233
#addin nuget:?package=SqlServer.AdministrativeViews&version=1.0.233
#tool nuget:?package=SqlServer.AdministrativeViews&version=1.0.233
SQL Server Administrative Veiws
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
- metrics sorting,
- database filter,
- columns chooser,
- execution plan button,
- and sql syntax highlighter.
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
or
dotnet tool update --global SqlServer.AdministrativeViews
Example
SqlServer.AdministrativeViews -o "%SYSTEM_ARTIFACTSDIRECTORY%\\Reports\\{InstanceName}" -all -av
Options
-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
--all-local-servers<br/>Include all local sql servers and all Local DB instances. Sql Server Browser service is not required. All instances are discovered by registry and SQLLocalDB.exe info API.
-s "(local)\SQLEXPRESS"<br/>Include local SQLEXPRESS instance.
-cs "TrustServerCertificate=True;Data Source=127.0.0.1,1433;User ID=sa;Password=p@assw0rd!"<br/>Include local SQL Server on linux.
Parameters -s, -cs may be included multiple times.
If multiple SQL Servers are passed an instance name can be inlined into file name as {InstanceName} placeholder.
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.