Raghu's SharePoint Column : SharePoint - My Lifeline!!

Raghu's SharePoint Column

SharePoint Performance Testing Tools

Delivering a high performance application in SharePoint is quite challenging and most of the times you end up using many tools to figure out the reason behind the delay in Page Load.

There can be many factors due to which the response is very slow, some of them are

  1. Hardware Configuration.
  2. Software Configuration for Load Balancing.
  3. Architecture of the SharePoint Farm.
  4. JavaScripts, CSS, Images and Html on the Page.
  5. Capacity Planning.
  6. Poor Server/Client side code.
  7. I/O activity on SQL server.

The following tools are can help you in figuring out the causes of performance issues:

  • Fiddler – a very handy and light weight tool that can provide quick overview of you web site performance. It can also records scripts that you can use in VSTS. This MSDN article provides detailed information on how Fiddler can be used for performance tuning.
  • neXpert – an add-on to Fiddler which automates the classic performance best practice checks and produces a HTML report on the issues found in a Fiddler capture. Also adds the ability to insert step markers in Fiddler sessions to associate network objects together (create transactions). Check out more here
  • Web Page Test –   Is a free over-the-web tool for performance testing a page from either Dulles, VA, USA or Wellington New Zealand. Pagetest allows you to provide the URL of a webpage to be tested provides a waterfall of your page load performance as well as a comparison against an optimization checklist 
  • WireShark When you need to look into network issues, use WireShark. It works with many media, and you can capture packets from recreated TCP/IP conversations when you recreate issues. For more information, see wireshark.org.
  • Visual RoundTrip Analyzer (VRTA) You can use VRTA to examine the round-trip performance from request to response. VRTA examines the communications protocol, identifying the causes of excessive round trips, and recommending solutions. You can download it from Microsoft downloads, Visual Round Trip Analyzer.
  • SQL Profiler You can use this useful tool, installed with SQL Server, for monitoring an instance of SQL Server Database Engine or SQL Server Analysis Services. It enables you to discover issues with queries, deadlocks, timeouts, recompilations, and general errors and exceptions.
  • SQLDiag This tool, also installed with SQL Server, collects valuable information about the configuration of the computer running SQL Server, the operating system, and the information that is reported to the SQL Server error logs.
  • SQL Query Analyzer This is a low-level debug tool for analyzing query performance issues. It also is part of the SQL Server toolset.
  • Custom tool for client-based URL ping this is one of the most useful tools because it enables the comparison of statistics before and after implementing configuration changes to the environment. See the appendix on the SharePoint Performance Optimization page.

A must read for people who are interested in understanding how Microsoft tuned their SharePoint website go through the blog post http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?PageType=4&ListId={72C1C85B-1D2D-4A4A-90DE-CA74A7808184}&pID=470

 
Comments

Raghavendra, please consider adding WAPT module for SharePoint testing to your list.

Module for SharePoint testing (http://www.loadtestingtool.com/sharepoint-testing.shtml) is a solution that extends the functionality of WAPT and WAPT Pro load testing tools by adding a number of features that facilitate and automate the use of session-specific values in the load tests of SharePoint applications.

Leave a Reply
*

Protected by WP Anti Spam