Generate Logs for AGDiag to Analyze - microsoft/agdiag GitHub Wiki

AGDiag can analyze logs coming from several sources including PSSDiag, SQLLogScout and SQL Base TSS. The following instructions are for SQL Base TSS, but would apply to these other source tool logs as well.

In order to diagnose an availability group RESOLVING or failover event, use TSS to collect logs on the SQL Server instance that was in the primary role at the time of the event.

To create the TSS logs on the SQL Server, download TSS from the following URL to the SQL Server instance that hosted the availability group primary replica at the time of the health issue:

https://aka.ms/getTSS

/images/1_DownloadTSS.png

Click Save As to save the zipped binaries to a folder

/images/2_DownloadTSS.png

From elevated command line, change directory to TSS folder where files were saved/extracted and run 'TSS SDP:SQLBase' and respond to the prompts:

/images/3_RunTSSToCollectLogsOnSQLServer.png