Skip to content

Common CSS PSSDiag Packages
Compare
Choose a tag to compare
@troymoen1 troymoen1 released this 22 Jul 22:28
· 545 commits to master since this release
V1_7_22_20
20e6019
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.

Packages

These are pre-configured PSSDiag packages that CSS commonly uses to troubleshoot performance issues for SQL Server. They are broken in to 3 basic templates across SQL Server 2012, 2014, 2016, 2017, and 2019.

  • Light - The least intrusive capture with no XEvent tracing. It will capture Perfmon, Perfstats, and other basic collectors.
  • General - The standard capture template. Captures everything the "Light" captures along with standard XEvents(RPC, Batch, Errors, etc..)
  • Detailed - A verbose collector that will capture everything the "General" captures along with execution plans and statement-level events in the XEvent collector.

How to Use:

  1. Download the package that corresponds to your SQL Server version and level of tracing required
  2. Extract the package on a drive with sufficient space.
  3. Open the pssdiag.xml file and change "MyMachineName" to match your server name or if a cluster your virtual server name. Change "MyInstanceName" to your instance name(for a default instance use MSSQLSERVER).
  4. Save the file.
  5. Open an administrative command prompt and navigate to the extraction directory.
  6. Type PSSDIAG and press Enter to start collection.
  7. Press Control+C to end the collection. The output will be in the "output" folder.
Assets 17