Troubleshooting Concepts (Database Engine)

This section contains information about troubleshooting the SQL Server Database Engine. 

Troubleshooting the Data Collector

Provides information for troubleshooting common problems with the data collector.

Troubleshooting Database Engine Connectivity

Contains information about troubleshooting connections to the Database Engine.

Troubleshooting Database Mail

Provides information for troubleshooting common problems with Database Mail.

Troubleshooting Database Mirroring Deployment

Contains information to help you troubleshoot problems in setting up a database mirroring session.

Troubleshooting Error 3313, 3314, 3414, or 3456 (SQL Server)

Discusses possible responses to an error during a redo, undo, or recovery operation that places a SQL Server database into the SUSPECT state (error 3313, 3314, 3414, or 3456).

Troubleshooting a Full Transaction Log (Error 9002)

Discusses possible responses to a full transaction log and suggests how to avoid it in the future.

Troubleshooting GROUP BY Errors

Lists GROUP BY error messages and suggests resolutions

Troubleshooting Insufficient Data Disk Space

Discusses how to respond if the Database Engine lacks sufficient disk space for data files during recovery.

Troubleshooting Insufficient Disk Space in tempdb

Provides procedures and recommendations to help you diagnose and troubleshoot problems caused by insufficient disk space in the tempdb database.

Troubleshooting Metadata Visibility

Discusses how to troubleshoot problems with viewing metadata.

Troubleshooting Orphaned Users

Explains how to detect and resolve the situation in which the SQL Server login for a database user is undefined or is incorrectly defined on the server instance (creating an orphaned user).

Troubleshooting Policy-Based Management Policies

Contains information to help you troubleshoot policy failures and performance problems.

Troubleshooting Protocol Errors During Database Engine Startup

Discusses how to interpret error codes that you receive when the Database Engine encounters a protocol-related error during startup.

Troubleshooting Queries

Contains information about troubleshooting query problems in the Database Engine.

Troubleshooting Query Notifications

Provides troubleshooting information for common problems with query notifications.

Troubleshooting Resource Governor

Provides troubleshooting guidance for Resource Governor.

Troubleshooting SQL Dependencies

Describes common object dependency problems and their solutions.

Troubleshooting SQL Mail

Discusses how to troubleshoot common problems with SQL Mail.

Troubleshooting the SQL Server Utility

Describes how to troubleshoot common problems with the SQL Server Utility.

Troubleshooting SQL Server Resource Health (SQL Server Utility)

Provides information about mitigating resource health issues identified by a SQL Server UCP.

Troubleshooting Data-tier Applications

Discusses how to find error information about data-tier application management actions.

Community Additions