Database troubleshooting tools

Stand-alone database tools provide a wide range of information that might be useful for troubleshooting.

The following tools might be helpful for SQL Server troubleshooting:
  • Microsoft SQL Server Enterprise Manager
  • Query Analyzer
  • SQL Profiler
The following tools might be helpful for Oracle troubleshooting:
  • Oracle Enterprise Manager
  • SQL Plus
  • Traces

Refer to the documentation of each tool to learn how to use it effectively. Using Traces may require the assistance of a database administrator.