Home » How to get SharePoint 2010 requests per second (RPS)

How to get SharePoint 2010 requests per second (RPS)

Problem

Many of the capacity planning documents at technet talk about requests per second (RPS) and how to project this based on the number of users and other variables. But few online resources explain how to directly measure this number once your farm is up and running.

Solution:

Finding RPS requires looking at your IIS logs, not your SharePoint logs. This information won’t be found in or via your Web Analytics service.

Resources:

The steps below are taken from two online resources:

  1. Mohamed El Ashmawi’s: SharePoint 2010 Capacity Management: Log Parser
  2. Analyze SharePoint Products and Technologies Usage

I wanted to pull all the scripts (from the first link above) and put them together onto a single page so that they could be run together quickly without repetitive copying and pasting and fixing of typos. I have made one minor edit to correct a typo and renamed the output files to make more sense to me. I will also include an excel file with pretty graphs (coming soon).

 

Requirements:

  1. Log parser
  2. IIS Logs as IISW3C (from all WFE servers)
  3. A “load.txt” file, saved to the same folder as the logs:

Steps:

  1. Download and Install Log Parser
  2. Add ;C:Program Files (x86)Log Parser 2.2 to the Path environment variable (instructions)
  3. Restart computer
  4. Copy your log files from your WFEs into a single directory on your desktop. Here’s how:
    1. On your desktop computer’s desktop, create two folders
      1. One called “LogFiles”
      2. Another called “LogFilesConsolidated”
    2. Inside “LogFiles”, create a folder called “Server1”
    3. If you have two WFE servers, then create a second folder called “server2” and do keep doing this for however many servers you have
    4. Copy all logs from WFE1 to the “Server1” folder (note: just copy the main folder that contains all the .log folders and files)
    5. Copy all logs from WFE2 to the “Server2” folder (note: just copy the main folder that contains all the .log folders and files)
    6. In an explorer window navigate into “LogFiles”.
    7. In the search area at top right, type “.log” without the quotes
    8. Select all the .log results and move them into “LogFilesConsolidated”. If prompted, choose to “move, but keep both copies”
  5. Copy the “load.txt” file (above) into “LogFilesConsolidated.”
  6. Launch Log Parser
  7. cd into “LogFilesConsolidated,” the directory containing the log files.
  8. Copy and paste the following into Log Parser’s cmd window

Leave a Reply

Your email address will not be published. Required fields are marked *

*