Skip to content

Latest commit

 

History

History
46 lines (33 loc) · 2.81 KB

view-the-windows-application-log-windows-10.md

File metadata and controls

46 lines (33 loc) · 2.81 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords
View the Windows Application Log (Windows)
When SQL Server is configured to use the Windows application log, each session writes events to that log. Learn how to view the Windows application log.
MikeRayMSFT
mikeray
maghan
12/26/2024
sql
performance
how-to
viewing logs
application logs [SQL Server]
logs [SQL Server], application
monitoring Windows NT application log [SQL Server]
Windows NT application logs [SQL Server]
displaying logs
monitoring [SQL Server], events
logs [SQL Server], viewing

View the Windows application log

[!INCLUDE SQL Server]

[!INCLUDE ssNoVersion] is configured to use the Windows application log, each [!INCLUDE ssNoVersion] session writes new events to that log. Unlike the [!INCLUDE ssNoVersion] error log, a new application log is not created each time you start an instance of [!INCLUDE ssNoVersion].

This article covers Windows 10 operating systems and later.

To view the Windows application log

  1. On the Search bar, type Event Viewer, and then select the Event Viewer desktop app.

  2. In Event Viewer, expand the Windows Logs folder, and select the Application event log.

  3. [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion], [!INCLUDE ssNoVersion] Agent events are identified with SQLAgent$<instance_name>). Microsoft Search service events are identified by the entry Microsoft Search.

  4. To view the log of a different computer, right-click Event Viewer (local). Select Connect to another computer, and fill in the fields to complete the Select Computer dialog box.

  5. Optionally, to display only [!INCLUDE ssNoVersion] events, on the View menu, select Filter. In the Event source list, select MSSQLSERVER. To view only [!INCLUDE ssNoVersion] Agent events, instead select SQLSERVERAGENT in the Event source list.

  6. To view more information about an event, double-click the event.

Related content