SharePoint Stress Testing

James Edelen — Fri, 25 Mar 2005 21:11:00 GMT

Stress Testing SharePoint with Application Center Test (ACT)
Testing SharePoint is and incredibly important part of capacity planning. There is nothing worse than spending weeks or months implementing a solution and it not being able to handle the required load. Using a tool like ACT will enable you to test your hardware before production in order to ensure that it will perform as expected. It will also let you more easily discover bottlenecks in your system before going live. You can watch performance counters on your servers while stress testing to find bottlenecks.
ACT stands for Microsoft Application Center Test tool and it is included with Microsoft Visual Studio .NET Enterprise and Enterprise Architect. When you launch it, it creates a blank project as shown below:

Under the project (which in this case is called Application Center Article), there are 3 items – tests, results and users. You must create a test before you can run a test. On creation, you will be given two choices – Create an Empty test and Record a test. Record a test is great, but it only works with SharePoint Anonymous Access, which is not ideal for stress testing, so we will create a new Blank Test. To Create a Blank Test:
1. Right-click Tests and select new Test
2. Click Next to start the Wizard
3. Select Create an Empty Test
4. Select a Script Language (all examples here will be VBScript)
5. Give the Test a Descriptive name (SharePoint Basic Test)
6. Click Finish to complete the wizard.
This will create the most basic test you can have:
Test.SendRequest("http://localhost")
This command creates a request and sends it to the localhost. It will ask the webserver for the default document and time how long it takes for the server to process the request and send the data back to the client. You will want to edit this line to point to your SharePoint server.
Now, we still need to do a couple of things to prepare a test to run against SharePoint. First is that we need to create users. You will want to create a batch of test users (between 50 and 100) in Active Directory. These users should have progressive name (ie test0, test1,test2, etc) and they should all have the same password. These users must have at least reader permissions to SharePoint.
Once the users are created in active directory, they must be referenced in ACT. As long as the users have progressive names and the same password, doing this is incredibly easy. To associate these users with ACT do the following:

1. Right click the Users item and select add.
2. Right click on the created group (new users group), select rename and change the name to a descriptive name (SharePoint Users) – this should look like the following:

3. Click the Actions Menu, then select Generate Users
4. Under number of users, select the number of test users you created
5. Under User name prefix, enter the domain\username (trainsbydave\test)
6. Under Password, enter the password for all these users.
It should now look as follows:

Now, click ok and all the users will be associated with ACT. It will looks as follows:

You now have all the users associated with the SharePoint users group in ACT, but we still need to link the SharePoint Users Group to the Test and set some properties on the test. To do so:

1. Right click the test your created earlier and select properties
2. On the General Tab, enter a number of simultaneous browser connections and set a test duration time.

NOTE: When setting the number of simultaneous browser connections, you want to start this number low (1) and slowly ramp up until you get your CPU usage to 90% on your Web Front End SharePoint Servers.

NOTE: Often you will want to set a 30 second warmup period in order to allow the portal to load and cache data before running the full blown test in order to get more accurate results.

3. One the Users Tab, select specify users and check the group you created (SharePoint Users)
4. Click OK
You are now ready to run the test. Click the green sideways triangle on the taskbar to start the test. You will get a screen that looks like this:

Once the test completes (or is stopped), you will want to review the test results. Click on the results item under the project and select the report for the test you just ran.

Under that report, you will get some very useful information. The most useful are:
Average requests per second: 6.92
Average time to first byte (msecs): 112.83
Average time to last byte (msecs): 120.29

The Average requests per second should meet or exceed the number you calculate using the Operations per second equation. The Average time to first byte is the time in milliseconds that it takes the server to generate the page and start sending it. The Average time to last byte is the time from the request being sent until the whole page is downloaded to the client. Using this, you can test your portal and use performance counters on your servers to monitor bottlenecks.

SharePoint Database Explorer and SPExport

James Edelen — Thu, 20 Jan 2005 16:30:00 GMT

It would seem that my old blog provider bloggedup.com disappeared from the face of the earth, and with it all my posted files and blog entries. Mindsharp has graciously agreed to host my new blog and the latest versions of SharePoint Database Explorer and SPExport! I don't expect to blog as often as I would like since school is really time-consuming this year as a get everything resolved so I can graduate in June. I got a job as a Full Time Program Manager at Microsoft for Exchange which I will start in August (but I will still participate in SharePoint activities as much as I can). Without further ado, I give you both the binaries and source (for the first time) for SharePoint Database Explorer as well as SPExport:

Download SPExport Binaries
Download SPExport Source
Download SharePoint Database Explorer Binaries
Download SharePoint Database Explorer Source