大网数据广告活动
启动与系统组件

Collect data to analyze and troubleshoot SQL cluster (AG/FCI) scenario

· 52CE 我爱测

Learn how to gather information by using TSS for SQL cluster (AG/FCI) related issues.

This article introduces how to gather information by using the TroubleShootingScript (TSS) toolset for SQL cluster (AG/FCI) related issues.

Before contacting Microsoft support, you can gather information about your issue.

Prerequisites

Refer to Introduction to TroubleShootingScript toolset (TSS) for prerequisites for the toolset to run properly.

Scenario: Virtualization and Hyper-V

TSS cmdlet

.\TSS.ps1 -SDP SQLbase

TSS cmdlet description

  1. Download TSS and extract it in the C:\tss folder.

  2. Open the C:\tss folder from an elevated PowerShell command prompt.

    [!NOTE] Don't use the Windows PowerShell Integrated Scripting Environment (ISE).

  3. Run the following cmdlets:

    Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass
    
    .\TSS.ps1 -SDP SQLbase
    
  4. Enter A for "Yes to All" for the execution policy change.

Note:

  • The time to collect this script on a given system may vary. It depends on system speed, system size, the number of virtual machines, the amount of data in logs, and so on. Depending on these factors, the average collection time is between 30 and 90 minutes, or even longer, especially if no skip commands are used.
  • The collection is stored in a compressed file in the C:\MS_DATA folder. After a support case is created, this file can be uploaded to the secure workspace for analysis.

Optional parameters

Some parameters are optional to perform a quicker and more streamlined collection, which may help the script finish successfully if a certain section stops responding.

  • This cmdlet skips running the Best Practices Analyzer and makes the collection faster.

    .\TSS.ps1 -SDP SQLbase -SkipSDPList skipBPA 
    
  • This cmdlet skips some small collection items that may fail in a regular collection and makes the script more reliable.

    .\TSS.ps1 -SDP SQLbase -SkipSDPList skipHang
    
  • This cmdlet skips some additional collection parameters that may not be needed.

    .\TSS.ps1 -SDP SQLbase -SkipSDPList skipTS
    
  • This cmdlet skips testing Server Message Block (SMB) connectivity to any Cluster Shared Volumes (CSVs) in the failover cluster.

    .\TSS.ps1 -SDP SQLbase -SkipSDPList skipCsvSMB
    

Note: You can combine multiple skip parameters with comma-separated items, such as the following example:

.\TSS.ps1 -SDP SQLbase -SkipSDPList skipBPA,skipHang,skipTS,skipCsvSMB

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
- Supported versions of Windows Client - Supported versions of Windows Server · Source date 02/12/2026
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。