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
folderComputerName_SetupApi.app.log
ComputerName_SetupApi.evt.log
ComputerName_SetupApi.offline.log
ComputerName_SetupApi.Dev.logInformation about all hotfixes that are applied on the computer
Description File name Installed updates and hotfixes ComputerName_Hotfixes.CSV
ComputerName_Hotfixes.Txt
ComputerName_Hotfixes.HTMBackup 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.TXTOutput 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.errorlogNote
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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for