SQL Server Logs

Site24x7 AppLogs improves SQL server management experience by allowing search queries over SQL server log information that has been pre-sorted into relevant fields like date & time, message, and process. It also enables collection and analysis of data from a single web client, thereby acting as a novel solution for log management. Learn more about log management with Site24x7.

Getting started

1. Log in to your Site24x7 account.
2. Download and install the Site24x7 Server Monitoring agent (Windows). 
3. Go to Admin > AppLogs > Log Profile and Add Log Profile.

Logs file path

Each application writes logs in different folders and files. By default, SQLserver logs will be sourced from the below-mentioned folder path for the respective Operating System. If you have logs in a different folder, you can mention it under the File Path to source them from that particular folder while creating a log profile.

:

C:\Program Files\Microsoft SQL Server\*.MSSQLSERVER\MSSQL\Log\ERRORLOG*

Log pattern

$DateTime:date$ $Process$      $Message$

This is the default pattern defined by Site24x7 for parsing SQLserver logs based on the sample mentioned below.

Sample log

2017-07-31 22:22:58.56 spid3s      Recovery completed for database ReportServer (database ID 5) in 1 second(s) (analysis 208 ms, redo 60 ms, undo 436 ms.) This is an informational message only. No user action is required

The above sample log can be separated into 3 fields, each of which will take its respective value from here and will then be uploaded to Site24x7.

Field name	Field value
Date Time	2017-07-31 22:22:58.56
Process	spid3s
Message	Recovery completed for database ReportServer (database ID 5) in 1 second(s) (analysis 208 ms, redo 60 ms, undo 436 ms.) This is an informational message  only. No user action is required

Related log types

• SQL agent logs
• Windows event logs
• MySQL slow query logs
• Other supported log types