Databases Reference
In-Depth Information
Using LogParser
LogParser is a simple to use yet powerful tool for log i le analysis, popularized for analyzing logs
from IIS web servers. LogParser can be used to examine a range of log types and can provide output
in various forms. Once installed, LogParser enables pseudo-SQL querying of log i les! This can be
great when searching Windows Event Logs, IIS logs, or PerfMon logs.
LogParser is part of the Windows Resource Kit and available as a standalone download from
logs must be converted to CSV (using Relog) prior to analysis with LogParser.
SUMMARY
This chapter provided you with details on when and how to use PerfMon to capture server perfor-
mance data. You read specii c guidance on prescriptive counters to help identify common issues with
poorly performing SQL servers. Additionally, the chapter provided guidance on using the PAL tool
to analyze performance logs, as well as other log manipulation tools such as Relog, LogMan, and
LogParser for log analysis.
Search WWH ::
Custom Search