SQL Server Setup data-collection diagnostic tool

This article describes the information that may be collected from a computer when the SQL Server Setup data-collection diagnostic tool is running.

Original product version:   SQL Server 2008
Original KB number:   2621109

Summary

The SQL Server Setup Data Collector for Windows 7, Windows Server 2008 R2, Windows 8, Windows Server 2012, Windows 8.1 and Windows Server 2012 R2 collects diagnostic information that is useful in troubleshooting setup-related issues for Microsoft SQL Server 2008, for SQL Server 2008 R2, and for SQL Server 2012.

SQL Server features are categorized as Instance Features or as Shared Features.

Instance Features

The Instance Features are as follows:

  • Database Engine Features (SQL Server Replication, Full-text, and Semantics Extractions search, Data Quality Services)
  • Analysis Services
  • Reporting Services - Native

Shared Features

The Shared Features are as follows:

  • Reporting Services - SharePoint
  • Reporting Services Add-in for SharePoint Products
  • Business Intelligence Development Studio
  • Client Tools Connectivity
  • Integration Services
  • Client Tools Backward Compatibility
  • Client Tools SDK
  • SQL Server Books Online
  • Management Tools - Basic (Management Tools - Complete)
  • SQL Client Connectivity SDK
  • Microsoft Sync Framework
  • Data Quality Client
  • Master Data Services
  • Distributed Replay Controller
  • Distributed Replay Client

The SQL Server Setup Data Collector is cluster-aware and will collect cluster-specific information when the SQL Server Setup Data Collector is run against a clustered instance of SQL Server. When you troubleshoot a Setup failure that occurred on a Windows cluster, the SQL Server Setup Data Collector should be run against the cluster node at which the Setup failure occurred. To troubleshoot multiple Setup failures on multiple nodes that are joined to the same cluster, the SQL Server Setup Data Collector must be run against each node at which the failure occurred.

The SQL Server Setup Data Collector should be run under the security context of the account that was used to run Setup. Also, the SQL Server Setup Data Collector must be run by a user who has administrative rights on the computer on which the data collector will be run.

Information that is collected

  • All event logs

    Description File name
    System log - Evtx format ComputerName_System.evtx
    Application log - Evtx format ComputerName_Application.evtx
    Security log - Evtx format ComputerName_Security.evtx
    FailoverClustering-Operational - Evtx format ComputerName_FailoverClustering-Operational.evtx

    Note

    Failover Clustering event logs will be collected only on servers that have Failover Clustering configured.

  • Registry information that is related to Session Manager and Debugging

    Description File name
    Collect Registry Key - HKLM\Software\Microsoft\Windows NT\CurrentVersion\AEDebug ComputerName Recovery_Registry.TXT
    Collect Registry Key - HKLM\Software\Microsoft\DrWatson _ComputerName _Recovery_Registry.TXT
    Collect Registry Key - HKLM\System\CurrentControlSet\Services\i8042prt\Parameters ComputerName Recovery_Registry.TXT
    Collect Registry Key - HKLM\System\CurrentControlSet\Control _ComputerName _Recovery_Registry.TXT
    Collect Registry Key - HKLM\System\CurrentControlSet\Control\Session Manager ComputerName Recovery_Registry.TXT
  • Existing Dr. Watson logs files and memory dump reports and files

    Description File name
    Memory dump report ComputerName_DumpReport.htm
    Memory dump report ComputerName DumpReport.txt_
    Memory dump file (minidumps) ComputerName DMP{Date}.zip
  • Information about all services that are installed on the operating system

    Description File name
    Collect information about all OS services ComputerName_SC_Services_Output.txt
  • Information about all filter drivers that are active on the computer

    Description File name
    Upper and lower filters information that uses fltrfind.exe utility ComputerName FltrFind.txt_
  • Information about all the running processes and driver details together with their file versions

    Description File name
    %programfiles%\*.sys ComputerName_sym_ProgramFiles_SYS.CSV
    %programfiles%\*.sys ComputerName_sym_ProgramFiles_SYS.TXT
    %windir%\system32\drivers\*.* ComputerName_sym_Drivers.CSV
    %windir%\system32\drivers\*.* ComputerName_sym_Drivers.TXT
    %windir%\system32\*.exe ComputerName_sym_System32_exe.CSV
    %windir%\system32\*.exe ComputerName_sym_System32_exe.TXT
    %windir%\system32\*.sys ComputerName_sym_System32_sys.CSV
    %windir%\system32\*.sys ComputerName_sym_System32_sys.TXT
    Running processes ComputerName_sym_Process.CSV
    Running processes ComputerName_sym_Process.TXT
    Running drivers ComputerName_sym_RunningDrivers.CSV
    Running drivers ComputerName_sym_RunningDrivers.TXT
  • Performance-related information for the operating system

    Description File name
    System processor basic information ComputerName Processor_Details.txt_
    System processor performance information ComputerName OS_Perf_Details.txt_
    System performance statistics ComputerName OS_Perf_Statistics.txt_
  • Information about the network configuration of the computer

    Description File name
    TCP/IP basic information ComputerName_TcpIp-Info.txt
    SMB basic information ComputerName_SMB-Info.txt
  • Output of the NetDiag utility

    Description File name
    Networking diagnostic output that uses the NetDiag.exe utility ComputerName_NetDiag.txt

    Note

    NetDiag is a diagnostic tool that helps isolate networking and connectivity problems by performing a series of tests to determine the state of the network client.

  • Information about Windows scheduled tasks that are configured on the computer

    Description File name
    Scheduled tasks list ComputerName_schtasks.csv
    Scheduled tasks list ComputerName_schtasks.txt
  • Boot configuration data of the computer

    Description File name
    Output from Bcdedit.exe utility ComputerName_BCDEdit.txt
    Output from Bcdedit.exe utility ComputerName_BCD-Backup.bak
  • Servicing information for the computer

    Description File name
    Component-Based Servicing logs that are located at %windir%\Logs\CBS ComputerName _CBS*.log
    DPX Setup Act log that is located at %windir%\logs\DPX ComputerName_setupact.log
    Pending Operations Queue Exec log that is located at %windir%\winsxs ComputerName_poqexec.log
    Windows Side-by-Side Pending Bad log that is located at %windir%\ winsxs ComputerName_pending.xml.bad
    Windows Side-by-Side Pending log that is located at %windir%\ winsxs ComputerName_pending.xml
  • Operating system SetupAPI logs

    Description File name
    SetupAPI logs that are located in %windir%\inf folder ComputerName_SetupApi.app.log

    ComputerName_SetupApi.evt.log

    ComputerName_SetupApi.offline.log

    ComputerName_SetupApi.Dev.log
  • Information about all hotfixes that are applied on the computer

    Description File name
    Installed updates and hotfixes ComputerName_Hotfixes.CSV

    ComputerName_Hotfixes.Txt

    ComputerName_Hotfixes.HTM
  • Backup of CurrentControlSet and SQL Server registry hives

    Description File name
    HKLM\System\CurrentControlSet\SessionManagers ComputerName_CurrentControlSet_Reg.txt
    HKLM\SYSTEM\CurrentControlSet\Control\Lsa ComputerName_CurrentControlSet_Reg.txt
    HKLM\SYSTEM\CurrentControlSet ComputerName_CurrentControlSet.Hiv
    HKLM\SOFTWARE\Microsoft\Microsoft SQL Server ComputerName_REG_SQL.TXT
    HKLM\SOFTWARE\Microsoft\MSSQLServer ComputerName_REG_SQL.TXT
    HKLM\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist ComputerName_REG_SQL.TXT
    HKLM\Software\Microsoft\MSFTESQLInstMap ComputerName_REG_SQL.TXT
    HKLM\SOFTWARE\Microsoft\Microsoft SQL Native Client ComputerName_REG_SQL.TXT
    HKLM\SOFTWARE\Microsoft\OLAP Server ComputerName_REG_SQL.TXT
    HKLM\SOFTWARE\Microsoft\SNAC ComputerName_REG_SQL.TXT
    HKLM\SOFTWARE\Microsoft\SQLXML4 ComputerName_REG_SQL.TXT
    HKLM\Software\Microsoft\Vsa ComputerName_REG_SQL.TXT
    HKLM\SOFTWARE\ODBC ComputerName_REG_SQL.TXT
    HKLM\SOFTWARE\Microsoft\MSDTS ComputerName_REG_SQL.TXT
    HKLM\SOFTWARE\Microsoft\MSXML 6.0 Parser and SDK ComputerName_REG_SQL.TXT
    HKLM\SOFTWARE\Microsoft\MSXML60 ComputerName_REG_SQL.TXT
    HKCU\Software\Microsoft\Microsoft SQL Server ComputerName_REG_SQL.TXT
    HKLM\SOFTWARE\Microsoft\Microsoft SQL Server ComputerName_Microsoft_SQL_Server.HIV
  • Output of MSINFO32

    Description File name
    Microsoft System Information report ComputerName_MSINFO32.NFO

    ComputerName_MSINFO32.TXT
  • Output of PStat utility

    Description File name
    PStat.exe output ComputerName_Pstat.txt

    Note

    PStat is a character-based tool that lists all running threads and displays their status.

  • Backup of cluster-related registry keys

    Registry key File name
    HKLM\Software\Microsoft\Windows NT\CurrentVersion
    HKLM\Software\Microsoft\Windows\CurrentVersion
    ComputerName_reg_CurrentVersion.TXT
    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall ComputerName_reg_Uninstall.TXT
    HKLM\SYSTEM\CurrentControlSet\Control\ProductOptions ComputerName_reg_ProductOptions.TXT
    HKLM\System\MountedDevices ComputerName _reg_MountedDevices.*
    HKLM\System\CurrentControlSet\Control\CrashControl
    HKLM\System\CurrentControlSet\Control\Session Manager
    HKLM\System\CurrentControlSet\Control\Session Manager\Memory Management
    HKLM\Software\Microsoft\Windows NT\CurrentVersion\AeDebug
    HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Image File Execution Options
    HKLM\Software\Microsoft\Windows\Windows Error Reporting
    HKLM\Software\Policies\Microsoft\Windows\Windows Error Reporting
    ComputerName_reg_Recovery.TXT
    HKCU\Software\Microsoft\Windows\CurrentVersion\Run
    HKCU\Software\Microsoft\Windows\CurrentVersion\Runonce
    HKCU\Software\Microsoft\Windows\CurrentVersion\RunonceEx
    HKCU\Software\Microsoft\Windows\CurrentVersion\RunServices
    HKCU\Software\Microsoft\Windows\CurrentVersion\RunServicesOnce
    HKLM\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer\Run
    HKLM\ Software\Microsoft\Windows\CurrentVersion\Run
    HKLM\Software\Microsoft\Windows\CurrentVersion\Runonce
    HKLM\Software\Microsoft\Windows\CurrentVersion\RunonceEx
    HKLM\Software\Microsoft\Windows\CurrentVersion\RunServices
    HKLM\Software\Microsoft\Windows\CurrentVersion\RunServicesOnce
    HKLM\Software\Microsoft\Windows\CurrentVersion\ShellServiceObjectDelayLoad
    HKCU\Software\Microsoft\Windows NT\CurrentVersion\Load
    HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows\Run
    HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer\Run
    HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\UserInit
    ComputerName_reg_Startup.TXT
    HKLM\SYSTEM\CurrentControlSet\Control\Print ComputerName_reg_Print.HIV
    HKCU\Software\Policies
    HKLM\Software\Policies
    HKCU\Software\Microsoft\Windows\CurrentVersion\Policies
    HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies
    ComputerName_reg_Policies.txt
    HKLM\SYSTEM\CurrentControlSet\Control\TimeZoneInformation
    HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones
    ComputerName_reg_TimeZone.txt
    HKLM\SYSTEM\CurrentControlSet\Control\Terminal Server
    HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Terminal Server
    HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Terminal Server Web Access
    HKLM\SYSTEM\CurrentControlSet\Services\TermService
    HKLM\SYSTEM\CurrentControlSet\Services\TermDD
    ComputerName_reg_TermServices.txt
    HKLM\SYSTEM\CurrentControlSet\Services\LanmanServer
    HKLM\SYSTEM\CurrentControlSet\Services\LanmanWorkstation
    HKLM\SYSTEM\CurrentControlSet\Services\MRxSmb
    HKLM\SYSTEM\CurrentControlSet\Services\SMB
    HKLM\SYSTEM\CurrentControlSet\Services\MRxSmb10
    HKLM\SYSTEM\CurrentControlSet\Services\MRxSmb20
    ComputerName_reg_SMB.txt
    HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters ComputerName_reg_TCPIPParameters
    HKLM\SYSTEM\CurrentControlSet\Services\VSS ComputerName_reg_VSS.TXT
    HKLM\SYSTEM\CurrentControlSet\Services\iScsiPrt
    HKLM\SOFTWARE\Microsoft\iSCSI Target
    HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\iSCSI
    ComputerName_reg_iSCSI.TXT
    HKLM\System\CurrentControlSet\Control\MPDev
    HKLM\System\CurrentControlSet\Control\iSCSIPrt
    HKLM\System\CurrentControlSet\Services\MSiSCSI
    HKLM\System\CurrentControlSet\Services\MSDsm
    HKLM\System\CurrentControlSet\Services\MPIO
    HKLM\System\CurrentControlSet\Control\Class\{4d36e97b-e325-11ce-bfc1-08002be10318}
    HKLM\System\CurrentControlSet\Services\Tcpip
    ComputerName_reg_Storage.TXT
    HKLM\SYSTEM\CurrentControlSet\Enum ComputerName_reg_Enum.TXT
    HKLM\System\CurrentControlSet\services\ClusSvc
    HKLM\System\CurrentControlSet\services\CluDisk
    ComputerName_reg_ClusSvc.TXT
    HKLM\Cluster ComputerName_Cluster.hiv

    Note

    This information will be collected if the SQL Server Setup data-collection diagnostic tool detects that the computer on which the tool is running is a cluster.

  • Basic information about Windows Failover Cluster

    The data that is collected includes the following:

    • Cluster logs
    • Shared volume information
    • Cluster resource properties
    • Cluster reports folder
    • Cluster resource dependency
    • Cluster validation report
    Description File name
    Cluster logs that are generated by Get-ClusterLog Windows PowerShell cmdlet ComputerName_Cluster.Log
    Cluster MPS Tool (clusmps.exe) output ComputerName_Cluster_MPS_Information.txt
    Cluster validation reports files that are located at \Windows\Cluster\Reports\*.mht ComputerName _*.mht
    Cluster reports XML files that are located at \Windows\Cluster\Reports\*.xml ComputerName _*.xml
    Cluster validation log files from \Windows\Cluster\Reports\Validate*.log ComputerName _Validade*.log
    Cluster resources properties that use the Windows PowerShell Get-ClusterResource cmdlet ComputerName_ClusterProperties.txt
    Cluster Dependency Report that is generated by the Get-ClusterResourceDependencyReport Windows PowerShell cmdlet ComputerName_DependencyReport.mht
    Cluster Shared Volume information - HTML format ComputerName_CSVInfo.htm
    Cluster basic Validation Report that is generated by the Test-Cluster Windows PowerShell cmdlet ComputerName_ValidationReport.mht

    Note

    This information will be collected if the SQL Server Setup data-collection diagnostic tool detects that the computer on which the tool is running is a cluster.

  • Information about SQL Server instances that are installed on the computer

    Description File name
    MSI Installer information for SQL Server products ComputerName_FindSQLInstalls.txt
  • Information about TCP/IP ports that are used on the computer

    Description File name
    TCP/IP port usage information ComputerName_PortUsage.txt
  • Information about User Rights Assignments

    Description File name
    Local User Right Assignments ComputerName_userrights.txt
  • Backup of the Setup Bootstrap folder for SQL Server installations

    Description File name
    Compressed directory %programfiles%\ Microsoft SQL Server\90\Setup Bootstrap\Log ComputerName_SQL90_Bootstrap.Cab
    Compressed directory %programfiles%\ Microsoft SQL Server\100\Setup Bootstrap\Log ComputerName_SQL100_Bootstrap.Cab
    Compressed directory %programfiles%\ Microsoft SQL Server\110\Setup Bootstrap\Log ComputerName_SQL110_Bootstrap.Cab
  • SQL Server error logs for all instances of SQL Server that are installed on the computer

    Description File name
    Collects SQL Server error logs for all instances that are installed on the computer on which the diagnostic tool is executed. The number of files that are collected is determined by how many error logs exist on the file system. Named instance:
    ComputerName instance_name .errorlog
    Default instance:
    ComputerName MSSQLSERVER.errorlog

    Note

    The SQL Server Setup data-collection diagnostic tool will collect error logs for a clustered instance only if the shared drive that is storing the error log is currently owned by the server on which the utility is being executed.

More information

In addition to the files that are collected and listed here, this troubleshooter can detect one or more of the following situations:

  • The computer is running in a virtual environment.
  • The cluster service of a FailoverCluster node is not running.
  • The state of any of the cluster nodes is Offline.
  • Any of the cluster groups is offline.
  • There is a problem in obtaining cluster information.

Applies to

  • SQL Server 2008 Enterprise
  • SQL Server 2008 Developer
  • SQL Server 2008 Express
  • SQL Server 2008 Express with Advanced Services
  • SQL Server 2008 Web
  • SQL Server 2008 Workgroup
  • SQL Server 2008 Standard
  • SQL Server 2008 Standard Edition for Small Business
  • SQL Server 2008 R2 Datacenter
  • SQL Server 2008 R2 Developer
  • SQL Server 2008 R2 Enterprise
  • SQL Server 2008 R2 Express
  • SQL Server 2008 R2 Express with Advanced Services
  • SQL Server 2008 R2 Standard
  • SQL Server 2008 R2 Workgroup
  • SQL Server 2008 R2 Standard Edition for Small Business
  • SQL Server 2008 R2 Web