Universal PSSDIAG:

Universal PSSDIAG:   Run PSSDIAG on any version of SQL server: #Magic PSSDIAG!!

PSSDIAG is a tool used by Microsoft to diagnose a production problem.The collection of data depends on the scripts used and the scripts can be customized.There are many more tools available to DBA but more often we see PSSDIAG in action.

Today I will show you how we can use a PSSDIAG for almost all versions of SQL server.

(Note: I am again saying for almost all versions because this can modify the SQL sever details but the scripts used to collect the data with the PSSDIAG will be the main cause of limit. )

I am not describing the PSSDIAG I assume that you have a base knowledge of using it and its consequences.

If you don’t know and have a crave to learn more about it  check out the amazing documentation by Microsoft itself.

All about PSSDIAG:

so here we start:

when you have all the PSSDIAG package. Follow  below steps:

Step 1: Open the PSSDIAG folder provide by Microsoft. Extract all the files.

Step 2: Locate the file “pssdiag” in XML format. Refer snapshot below.

Step 3: Open the file in notepad and locate the machine name in the code Refer below snapshot.

Step 4: In place of server mention the server name on which Pssdiag to be executed.

Step 5: Next is to modify the instance name and version number.

·         > Instance name will be the name of instance (Default / Named).

·         > Version number will be the SQL server version E.g.: SQL 2016 has version as ‘13’

Refer below snapshot.

 Save the above modifications run the pssdiag this will create a custom Pssdiag for any version of SQL server.

Note: Do not change the file name or place it in any other folder other than pssdiag itself.

Author: 

References:

> Microsoft & working experience.