SQL Agent Logs
SQL agent logs mostly host critical log data. With Site24x7 AppLogs you can drill this data down to find out vital errors. The appropriate segregation of log information into relevant fields like date & time, user, log level, event ID, and Message gives more clarity on the log data. 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, SQL agent logs are 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$ $User$ $LogLevel$ [$EventId$] $Message$
This is the default pattern defined by Site24x7 for parsing SQL agent logs based on the sample log mentioned below.
Sample log
2017-07-31 22:22:58 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
The above sample log can be separated into 5 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 |
User | - |
Log Level | - |
Event ID | 364 |
Message | The Messenger service has not been started - NetSend notifications will not be sent |