How to set up SharePoint 2010 Load Testing with VS2010 Ultimate Edition Part I

24. July 2011 14:21 by Eric in SharePoint  //  Tags: , , ,   //   Comments (1)

As for the part of SharePoint 2010 platform roll-out process, we would like to introduce "Load Testing" procedure to ensure the sever performance to the clients, and another round of self-assessment for the server installation and configuration.

In the following of the article, it demonstrates the steps with regards to how to install the VS2010 Ultimate on the workstation, configuring the test controller environment for the VS2010 Ultimate and how to set up the load test project through the Visual Studio.

Install the VS2010 Ultimate

  1. Before kicking off the installation, just so you know, the work station is based upon Windows XP SP3 32 bit operation system along with SQL Server 2008 R2 Express edition.
  2. Installation of VS2010 Ultimate should be pretty straight-forward, you could quickly get all components installed by choosing "Full" configuration type, then go all the way to the end until seeing the big green shiny "Success" window.

    The good practice here is that if there is another edition VS2010 installed on the workstation, please remove it and restart the computer before starting off the installation of VS2010 Ultimate on it

    install VSU Step1
  3. Once it's all finished, then run the windows updates to patch on all the fixes and cumulative service pack.

    install VSU Step2


    install VSU Step3
  4. Since the latest VS2010 SP1 came out quite recently, it's definitely worthwhile patching this onto the VS2010 Ultimate.

    The SP1 will take quite a while to apply all the fixes onto the workstation and do restart the machine after SP1 gets installed successfully.

    install VSU Step4


    install VSU Step5


Configure the load test SQL Database

  1. As part of the load testing configuration requirement, there must be a SQL Server 2008 installed as a load testing result repository.

    SQL Server 2008 and SQL Server 2008 R2 are both compatible in the case, and it doesn't seem be rigid about edition as well. In my case, I just used the SQL Server 2008 R2 Expression installed on the same workstation with VS2010 Ultimate.

  2. Configure the installed SQL Server to create the dedicated load testing database. You must Launch SQM Management Studio from the start menu, connect to the Database engine and open and run the SQL script located at C:\Program Files \Microsoft Visual Studio 10.0\Common7\IDE7\loadtestresultrepository.sql

  3. To configure Visual Studio to use the above database, from Visual Studio go to the “Test” menu and select “Manage Test Controllers…” and click on button to configure load test results store.

  4. Configure Visual Studio to use SQL database (configure load test results not shown)

    Ensure you use windows authentication and select “LoadTest2010” (or whatever your load test database you have. Just to make sure that your database name matches up with the database creation script you run in the first place) database from the list.


To be continued on Part II







SharePoint 2010 Environment Setup

5. November 2010 23:14 by Eric in SharePoint  //  Tags: , ,   //   Comments (0)


This blog entry aims to demonstrate that the simple setup steps for building up the SharePoint 2010 environment from ground-up on a fresh development box.


Essentially we would like to install SharePoint 2010 “Server Farm” mode – (not “stand-alone” or “Front-end only” mode) and use the SQL 2008 R2 instance as its target database server.


Install SQL Server 2008 R2

SQL Server 2008 R2 gets installed without any hassle on Windows Server 2008 R2 and all default feature settings are coped with SharePoint 2010 installation.

In our case, we would like to install the default instance with full-text indexing and other shared components except for Reporting Service. (Please refer to the following the screen-shot)

Install KB971831 and SharePoint 2010 Pre-requisites

Before installing SharePoint 2010 Pre-requisites, we need to make sure that WCF Hotifx for Microsoft Windows (KB971831) has been applied on the target machine.

Once it has been done, we could quickly start to install SharePoint 2010 Pre-requisites from the SharePoint 2010 installation media. (Please refer to the following screenshot.)

Install SharePoint 2010

1. Choose the Server Farm as the installation type. DO NOT SELECT Standalone because the standalone version installs a copy of SQL Server Express and should not be used.

2. From the server type, same again. Do not choose standalone edition. We should always choose complete edition with all components.

3. After the installation, it’s highly recommended to run the windows updates and cumulative updates rather than going straight to configuration part. Firstly, patch on, then

It’s important to install any service packs and cumulative updates first before continuing with the SharePoint configuration.

Configure SharePoint 2010

1. Create a new server farm

Fire off the configuration wizard, and acknowledge the IIS service re-set during this process. Then create a new server farm and then move on. (Please refer to the screen-shot below.)

2. Configure database
Enter the name of the database server and select a name for the Config database.

3. Enter a farm passphrase
In my case, I would just use my NDE AD password for it.

4. Specify port numbers for SharePoint application Use 3100 for Central Admin, 3500 for Search and 4000 for My sites (Please refer to the screen-shot below.)

5. Choose NTLM for security protocol

6. Review the settings and click Finish to complete the configuration wizard.

Initial Farm Configuration Wizard

1. Run the wizard to provision the components.

2. Create a service account that will become a managed service account for the farm.

3. Check the service applications that will be installed. In my case, I select all of them.

4. After the service application provisioning process has completed, the wizard will prompt me to create a web application and root site collection.

5. After putting title and selecting a template, we are all set for provisioning SharePoint 2010 environment.

Install Visual Studio 2010 and SharePoint 2010 SDK

a. Install Visual Studio 2010
I recommend doing a complete installation along with all shared components, by which there is less hassle for later configuration and patch on.

b. Download and Install the Microsoft SharePoint 2010 SDK
This basically installs the SharePoint 2010 SDK and SharePoint Foundation Server 2010 SDK onto the target machine for development usage.

Download & Install SharePoint 2010 Designer

You could download the designer 64bit from this address


There are a lot of other ways to set up the SharePoint 2010 farm enviornment, and here I have just quickly gone through the set-up process based upon the latest exercise I have conducted and hopefully, it could benefit anyone who's looking for similar reference from the internet.

In the next article, I would like to show you the post-installation configuration and tips-n-tricks when it comes to SharePoint 2010 farm installation and configuration.

Stay tuned and there are a lot more to come!

Welcome to another techie's blog

11. June 2007 05:00 by Eric in General  //  Tags: , , , , , , , , ,   //   Comments (0)

Hey, I'm your host, Eric Xue, a veteran in agile software development methodology with 7 years commercial experience as a SharePoint/.net Consultant, Team Lead, Web Developer and Business Analyst.

This is where I keep and collaborate my software consulting knowledge-base from my daily work and share back to the community where I learn every little thing from. ;)

Shop our huge range of women fashion accessories online, including necklaces, earrings, bracelets, rings and apple accessories.