You are currently offline, waiting for your internet to reconnect

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

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

SDP 3.0 SQL Server Engine Diagnostic
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2483962 - Last Review: 12/16/2010 21:03:00 - Revision: 1.0

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

  • KB2483962
Feedback