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
- Log in to your Site24x7 account.
- Download and install the Site24x7 Server Monitoring agent (Windows).
- 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.
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 |