PSSDiag Release (Linux) September 2022 (Signed)
How to Use:
- Download pssdiag_linux092022.tar
- Follow Configuring and Starting PSSDiag instructions sections in the README page.
- SQL Linux https://github.com/microsoft/DiagManager/tree/master/LinuxDiag#linux-and-docker-container-usage
- BDC https://github.com/microsoft/DiagManager/tree/master/LinuxDiag#sql-big-data-cluster-2019-usage
- Azure Arc-enabled SQL Managed Instance https://github.com/microsoft/DiagManager/tree/master/LinuxDiag#azure-arc-enabled-sql-managed-instance-usage
Verify downloaded files
Verify the files by computing the hash using sha512sum and compare to the below values.
sha512sum pssdiag_linux092022.tar
16d1a20354b057e62dab94923ad6fd3f5f4802b4b33297aeecd45ca6f7495b9c49cea56580274785f8bb3e287499759f2b1fe149665d9757134d5fec8dfce656
sha512sum pssdiag_linux092022.tar.sig
bce18ffdc7dcb98fa8c2baf4a87168e393e21c5b862faec4a0f3c7226683f2d13c9b8a8d60b864b03f8c8e5b2da0009f900bd849350664d67ad6dc14b75cb117
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_linux092022.tar.sig pssdiag_linux092022.tarFix List
• Fixed container registry URI references
Addition List
• Merged all version of SQL Linux editions (Linux, BDC and Azure Arc SQL MI) into single this collector
• Collect --sys.databases_ex-- view
• Collect "Database Configuration" and "Server Configuration" to allow SQL Nexus include the information in Nexus relevant reports.
• Support for Integrated (kerberos) authentication, To use integrated authentication, change the scn file and modify SQL_CONNECT_AUTH_MODE to either AD to assume integrated authentication or SELECT to interactively select between user/pass or integrated authentication. If using AD you must authenticate before executing pssdiag by executing: sudo kinit
• PSSdiag log
• Reading errorlog folder location from configuration file