| title | View the Windows Application Log (Windows) | Microsoft Docs | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| ms.custom | |||||||||
| ms.date | 06/13/2017 | ||||||||
| ms.prod | sql-server-2014 | ||||||||
| ms.reviewer | |||||||||
| ms.technology | performance | ||||||||
| ms.topic | conceptual | ||||||||
| helpviewer_keywords |
|
||||||||
| ms.assetid | 168a6c6e-12df-46a9-9904-55d63ca8fe14 | ||||||||
| author | MikeRayMSFT | ||||||||
| ms.author | mikeray | ||||||||
| manager | craigg |
When [!INCLUDEssNoVersion] is configured to use the Windows application log, each [!INCLUDEssNoVersion] session writes new events to that log. Unlike the [!INCLUDEssNoVersion] error log, a new application log is not created each time you start an instance of [!INCLUDEssNoVersion].
-
On the Start menu, point to All Programs, point to Administrative Tools, and then click Event Viewer.
-
In Event Viewer, click Application.
-
[!INCLUDEssNoVersion] events are identified by the entry MSSQLSERVER (named instances are identified with MSSQL$<instance_name>) in the Source column. SQL Server Agent events are identified by the entry SQLSERVERAGENT (for named instances of [!INCLUDEssNoVersion], [!INCLUDEssNoVersion] Agent events are identified with SQLAgent$<instance_name>). Microsoft Search service events are identified by the entry Microsoft Search.
-
To view the log of a different computer, right-click Event Viewer, click Connect to another computer, and complete the Select Computerdialog box.
-
Optionally, to display only [!INCLUDEssNoVersion] events, on the View menu click Filter, and in the Event source list, select MSSQLSERVER. To view only [!INCLUDEssNoVersion] Agent events, instead select SQLSERVERAGENT in the Event source list.
-
To view more information about an event, double-click the event.
View the SQL Server Error Log (SQL Server Management Studio)