[SDP 3][5da7d6cb-35c7-4eec-b453-04cceaa24307] SQL Server General Data Collection Diagnostic for Windows 7 and Windows Server 2008 R2

Applies to: SQL Server 2008 R2 DatacenterSQL Server 2008 R2 EnterpriseSQL Server 2008 R2 Standard

Summary


The SQL Server General Data Collection Diagnostic for Windows 7 and Windows Server 2008 R2 was designed to collect diagnostic information that is useful in troubleshooting a broad class of issues involving the SQL Server engine.

More Information


This article describes the information that may be collected from a machine when running SQL Server General Data Collection Diagnostic.

 

Information Collected

Event Logs- General
DescriptionFile Name
Event Log – Application  –evtx format{Computername}_evt_Application.evtx
Event Log – System  –evtx format{Computername}_evt_System.evtx
Event Log – Security  –evtx format{Computername}_evt_Security.evtx


Hotfixes and Updates
DescriptionFile Name
Installed Updates/ Hotfixes{Computername}_Hotfixes.*


Server Manager/ Roles Information
DescriptionFile Name
Information about server roles installed on a server generated by servermanagercmd.exe{Computername}_ServerManagerCmdQuery.*
Server manager log file located at %windir%\logs\ServerManager.log{Computername}_ServerManager.log


File Version Information
DescriptionFile Name
File version information from %windir%\system32\*.dll{Computername}_sym_System32_dll.*
File version information from %windir%\system32\*.exe{Computername}_sym_System32_exe.*
File version information from %windir%\system32\*.sys{Computername}_sym_System32_sys.*
File version information from %windir%\system32\drivers folder{Computername}_sym_Drivers.*
File version information from %windir%\SysWOW64\drivers\*.*{Computername}_sym_SysWOW64_sys.*
File version information from %windir%\SysWOW64\*.dll{Computername}_sym_SysWOW64_dll.*
File version information from %windir%\SysWOW64\*.exe{Computername}_sym_SysWOW64_exe.*
File version information from {Program Files (x86}}\*.sys{Computername}_sym_ProgramFilesx86_sys.*
File version information from {Program Files}\*.sys{Computername}_sym_ProgramFiles_sys.*
File version information from {Program Files}\Microsoft iSNS Server\*.* and %windir%\system32\iscsi*.*{Computername}_sym_MS_Iscsi.*
File version information from all drivers currently running on machine{Computername}_sym_RunningDrivers.*
File version information from %windir%\cluster\*.*

(If Failover Cluster feature installed)
{Computername}_sym_Cluster.*
File version information from all processes currently running on machine{Computername}_sym_Process.*


Virtualization
DescriptionFile Name
Basic information about machine virtual environments{Computername}_Virtualization.*


MSINFO32
DescriptionFile Name
System Information - MSInfo32 tool output – txt format{Computername}_msinfo32.txt


Failover Cluster Feature (If feature is installed)
DescriptionFile Name
Cluster Logs generated by Get-ClusterLog PowerShell cmdlet{Computername}_Cluster.Log
Cluster resources properties using PowerShell Get-ClusterResource cmdlet{Computername}_ClusterProperties.txt
Event Logs - Microsoft-Windows-FailoverClustering* - evtx format{Computername}_evt_FailoverClustering*.evtx
Cluster Dependency Report generated by Get-ClusterResourceDependencyReport PowerShell cmdlet{Computername}_DependencyReport.mht


Additional Information

In additional to the files collected and listed above, this troubleshooter can detect one or more of the following situations:
  • Machine is running on a virtual environment.
  • 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.
  • A problem obtaining cluster information.

References                                                                                                                            
  • 973559 - Frequently asked questions about the Microsoft Support Diagnostic Tool (MSDT) for Windows 7