Skip to content

PSSDiag Release (Linux) October 2024 (Signed)

Latest
Latest
Compare
Choose a tag to compare
@rl-msft rl-msft released this 08 Oct 08:43
20241001
8b81eb6
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

How to Use:

  1. Expand Assests section and download pssdiag_linux20241001.tar
  2. Follow the instructions Run PSSDiag for SQL Server on Linux

Verify downloaded files

Verify the files by computing the hash using sha512sum and compare to the below values.

sha512sum pssdiag_linux20241001.tar

e5cf9be8e85564154cde2ca2b4b137bc8ccc04817cd60a0e4bc2dbef829da7daca71583cbf43476ea70d810a825e49047c58089681f2e977864c66170f25ea35

sha512sum pssdiag_linux20241001.tar.sig

cd2dadd7339a7e585ca99436428ec37fea66357a0e7d502bf7745d1b4312a493edff001870fd28f0929c215efd1a3ed81efcfae78bf579956716e27a5230d222

Verify the Archive by signature using Microsoft PGP key

#Import Microsoft PGP key
curl -sSL https://packages.microsoft.com/keys/microsoft.asc | gpg --import -

#Verify PSSDiag with Microsoft PGP key
gpg --verify pssdiag_linux20241001.tar.sig pssdiag_linux20241001.tar

Fix List

behaviour:

Most SQL on Linux deployment has 1 instance either host or container, PSSDiag by default will discover all SQL instances and tries to collect from every instance on machine, this behavior can be changed using scn files

New Collectors:

. Docker collectors, including the discovery of podman containers
. SQL AD Collector
. OS AD Collector
. Discovering the logs configured in krb5.conf to collect them.
. OS HA Collector
. PAL DMVs Collector
. PAL logs collector
. cGroup top consumer
. SQL process collector for process configuration and status, memory maps, collect only for child process

Enhancement

. SQL log collector now detects the location of the logs before collecting them. In case of non-default locations.
. Improve discovery process for container instance for host with multiple containers.
. Adding example for mycustom collector
. scn defaults changed to control the level of data collected for each scn.
. Adjusting output files to indicate the instance type for each file
. Add support for PSSDiag to run from within container, to support k8s deployments

Authentication

. Support Kerberos
. New option (NONE) to allow user to choose during runtime which Auth to use, in case of multi instance on single host

Run Scenarios

. Added the following new scenarios

	sql_perf_detailed_kube.scn
	sql_perf_general_kube.scn
	sql_perf_light_kube.scn
	sql_perf_minimal_kube.scn
	sql_perf_minimal.scn

Bugs

. Fixing different bugs and code optimization.
. Adjusting Static collectors with all new Collectors
. Correct zombie sqlcmds processes when running inside container
. Make sure that we can invoke sqlcmd regardless of the client tool version, supports mssql-tools and mssql-tools18

Removed features

. Remove Dump collector, will use Static instead

Logging

. Include all collection activities in the PSSDiag log.

Assets 4
Loading