IIS Logs and Log Parser Studio Reports

 

Applies to: Exchange Server 2013

Analyzing Log Parser Studio Reports

Log Parser Studio is a utility that allows you to search through and create reports from several types of log files, including those for Internet Information Services (IIS). It builds on top of Log Parser 2.2 and has a full user interface for easy creation and management of related SQL queries.

Download Log Parser Studio and then review the blog post Getting Started with Log Parser Studio.

Remember that in Exchange 2013, all traffic has to go through IIS. This means analyzing IIS logs is the best way to get a complete picture of the number of connections that are hitting a server, of protocol-specific information about the connections, and of the users who are most impacting performance. Over twenty new reports have been developed for Log Parser Studio, for the purpose of troubleshooting Exchange 2013 performance issues.

Log Parser Studio Reporting for Exchange 2013 Performance Issues

To gain a comprehensive understanding of overall load in your Exchange 2013 environment, use the following reporting and compare the numbers against each server.

A .zip file containing the Log Parser Studio reports listed here, and additional troubleshooting-related reports, can be downloaded from here.

  • IIS: Requests Per Hour. Feed in IIS logs from either the Default Web Site (W3SVC1 directory) or the Backend Website (W3SVC2 directory), but not both at the same time.

  • ACTIVESYNC_WP: Clients by percent. Calculates all ActiveSync requests broken down by user-agent and percentage of each client to the total number of requests.

  • ACTIVESYNC_WP: Requests per hour (CSV). Lists the ActiveSync requests per hour and sends the results to a CSV file.

  • ACTIVESYNC_WP: Requests per user (CSV). Lists ActiveSync requests per user and sends the results to a CSV file.

  • ACTIVESYNC_WP: Requests per user (Top 10k). Lists ActiveSync requests per user for the top 10,000 users.

  • ACTIVESYNC_WP: Top Talkers (CSV). Lists the top ActiveSync clients from highest to lowest request count and sends the result to a CSV file.

  • EWS_WP: Clients by percent. Calculates all EWS requests broken down by user-agent and percentage of each client to the total number of requests.

  • EWS_WP: Requests per hour (CSV). Lists the total number of EWS requests per hour.

  • EWS_WP: Requests per user (CSV). Lists EWS requests per user and sends the results to a CSV file.

  • EWS_WP: Requests per user (Top 10k). Lists EWS requests per user for the top 10,000 users.

  • EWS_WP: Top Talkers (CSV). Lists the top EWS clients from highest to lowest request count.

  • OLA_WP: Errors, per user, per hour, per day. Outlook Anywhere users by number of requests.

  • OLA_WP: Requests per hour. Lists the Outlook Anywhere requests per hour.

  • OLA_WP: Requests per hour, per user. Lists the Outlook Anywhere requests per hour, per user.

  • OLA_WP: Requests per user (CSV). Lists Outlook Anywhere requests per user.

  • OLA_WP: Requests per user (Top 10k). Lists Outlook Anywhere requests per user for the top 10,000 users.

  • OLA_WP: Top Talkers. Lists the top Outlook Anywhere clients from highest to lowest request count.

  • OWA_WP: Clients by percent. Calculates all OWA requests broken down by user-agent and percentage of each client to the total number of requests.

  • OWA_WP: Requests per hour (CSV). Lists the OWA requests per hour and sends the results to a CSV file.

  • OWA_WP: Requests per user (CSV). Lists OWA requests per user and sends the results to a CSV file.

  • OWA_WP: Requests per user (Top 10k). Lists OWA requests per user for the top 10,000 users.

  • OWA_WP: Top Talkers (CSV). Lists the top OWA clients from highest to lowest request count and sends the result to a CSV file.