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

Article ID: 2483962 - View products that this article applies to.
Expand all | Collapse all

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
Collapse this tableExpand this table
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
Collapse this tableExpand this table
DescriptionFile Name
Installed Updates/ Hotfixes{Computername}_Hotfixes.*


Server Manager/ Roles Information
Collapse this tableExpand this table
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
Collapse this tableExpand this table
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
Collapse this tableExpand this table
DescriptionFile Name
Basic information about machine virtual environments{Computername}_Virtualization.*


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


Failover Cluster Feature (If feature is installed)
Collapse this tableExpand this table
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

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: December 16, 2010 - Revision: 1.0
APPLIES TO
  • 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
Keywords: 
KB2483962

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com