Learn about how to access event viewer for Microsoft SQL Server.
Image this, your Microsoft Server Server crashed and you started poking around the Microsoft Windows Event Viewer and could not find anything. Yikes! Well there is a solution. Microsoft SQL Server has an event log tool. In this episode, I will guide you on how you can access the Microsoft SQL Server event log, officially known as Log File Viewer.
The Log File Viewer also archives historical event in a sequential archives.
If you are new to SQL server, Microsoft SQL Server 2019 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications.
The Microsoft SQL Server Log File Viewer will let you know thing like AppCrash, Fault Bucket, Problem Signature and Event Name
Here are some of the fault parameters used by Microsoft SQL Server.
The fault parameter values are as follows:
P1: Process name
P2: Process version
P3: Process timestamp
P4: Module name
P5: Module version
P6: Module timestamp
P7: Exception code
P8: Exception offset from the start of the module
P9: Unused
P10: Unused
Reference