SharePoint Dragons

Nikander & Margriet on SharePoint

Category Archives: Uncategorized

The great free performance, load and stress testing tools that can be used with SharePoint verdict

Here’s a verdict of a list of tools we’ve tested to see if they’re useful in scenarios where you want to perform performance, load, and stress tests for SharePoint. Note that we’ve deliberately left out the Visual Studio Web Test tooling, as we’re finding lots of companies that don’t have the required licenses to use it. We do feel that every software author of each tool deserves a fair judgment based on facts and arguments, the only thing is, this verdict is not going to provide any of that. We’ve looked at a list of 100+ performance, load, and stress testing tools, and discarded any that were either commercial or not Windows oriented enough for our tastes. For the small list of remaining tools, we will just list them and tell you whether we liked it or not without getting into the in depth arguments why we reached a certain conclusion. Is that fair? Probably not. Here goes:

LoadUI at http://www.loadui.org/ is a great tool with at first, a brilliant user interface. Later on, the UI is still proves to be quite good, but not as great as the various Microsoft tooling we’re accustomed to.

WCAT (http://www.iis.net/downloads/community/2007/05/wcat-63-(x64)) is Microsoft’s community effort and is low on UI, but rich in functionality. If you’re planning on using WCAT, you’d better also download the WCAT Fiddler Extension (http://blogs.iis.net/thomad/archive/2010/05/11/using-the-wcat-fiddler-extension-for-web-server-performance-tests.aspx) which allows you to record WCAT scenarios using Fiddler.

StressStimulus (http://stresstimulus.stimulustechnology.com/) is a Fiddler add-in that looks promising but failed on our machine because it couldn’t install SQL Server Compact (we love Compact, btw). This was caused by the fact that we ran it on a 64 bit computer, and it tries to download the 32 bit version. You can solve it by downloading and installing SQL Server Compact yourself. To complicate things, the 64 bit version of Compact requires the 32 bit version of Compact (aaargh), but after that it works and you can install StressStimulus after all. That was the point when we found out that the free version of it was so limited that we had to forget about the tool.

We can forget about DieselTest (http://sourceforge.net/projects/dieseltest/), it’s as old and extinct as a dinosaur.

As far as D-ITG (the Distributed Internet Traffic Generator) goes (http://www.grid.unina.it/software/ITG/), we should have known better when we saw the animated NEW images and should have stopped there.

With the Fast Web Performance Test Tool (FWPTT at http://fwptt.sourceforge.net/), we pressed ‘Start Recording’ and that’s the last we ever heard back from the tool. That is probably caused by the fact that the tool might not believe in communicating with the end user.

The HttpRider tool (http://httprider.codeplex.com/) started out all right, but apparently isn’t able to handle authentication scenarios which renders it quite useless (unless of course, getting unauthorized HTTP responses is your thing).

After all, IxoraRMS (http://www.ixorarms.com/) turns out to be not Windows-oriented enough for our tastes. We want a setup or exe button, okay?

Load Tester Lite (http://www.webperformance.com/load-testing/free-load-tester-lite.html) would probably have been a decent tool, but since we’re still waiting for our confirmation mail after registration, we’re giving up.

Loadster (http://www.loadsterperformance.com/) throws HTTP 401 Unauthorized when hitting SharePoint. There must be better ways than this one.

OpenLoad (http://www.opendemand.com/openload/) is a command line tool that allows to specify a single URL and simulates 5 clients. Doesn’t like authentication either. It does work if you’re exactly looking for this type of functionality, but really, if this is what we can get we prefer to write our own tool instead.

OpenSTA (http://opensta.org/) begins by setting our expectations below zero by requiring a system restart. Really, for this type of tool? It’s just not fair. After that, we find out that by default it expects the IE5 browser and complains that it can’t find it (no kidding?) and again we’ve had enough.

Ostinato (http://code.google.com/p/ostinato/) looks kinda cool but managed to wreck our web server in such a way that we decided to restore a previous snapshot. Having said that though, it did look like a powerful tool that requires more studying.

TestMaker (http://www.pushtotest.com/) asked us to download a version that was 600+ MB in size. Apparently we asked for the OS version of the load and stress testing tool, such sizes are ridiculous, so we’re not that desperate yet.

XLT (http://www.xceptance.com/products/xlt/what-is-xlt.html) finds us on a not so good day. We’re not really interested in playing a game of hide and seek to find out how to start this tool.

At this point, we remember why Open Source isn’t the end all solution for all of world’s software problems. The first three tools are our top 3 choices, but certainly, when considering this type of tool, it might not be a bad idea to try to get some budget for it and check out a commercial vendor. We’d say that except for WCAT and maybe LoadUI, there’s no free lunch and the free functionality is so limited that it’s nothing more than a teaser to buy commercial versions.

SharePoint Emulators for SharePoint 2010

SharePoint Emulators for SharePoint 2010 make unit testing a lot easier: http://blogs.msdn.com/b/visualstudioalm/archive/2012/11/26/introducing-sharepoint-emulators.aspx Now, we just need emulators for SharePoint 2013/CSOM, because this seems to be a little too late.

Office 365 Terminology Update

The old Office 365 P1 plan in the new 2013 release becomes Office 365 Small Business and is intended for companies of 1-10 persons, if you want to have the Office 365 clients as well, it’s called Office 365 Small Business Premium. The Administration UI is kept to the absolute minimum.

For companies of 11-250 persons, its called Office 365 Midsize Business. It has a more advanced Administration UI and more capabilities.

For companies of 250+ persons, its called Office 365 Enterprise, which has an Education variant (which only has a different licensing model) and a Government version that is only available in the US and has a completely isolated Data Center.

AutoSPInstaller

The following script automates SharePoint 2013 installation and is based on PowerShell: http://autospinstaller.codeplex.com/ It’s quite cool!

VMWare doesn’t like competition?

That was a surprise, we tried to install VMWare workstation and we got the following message: “Error: This product may not be installed on a computer that has Microsoft HyperV installed.” VMWare must really hate competition, this is like Word saying it’s not going to run unless you remove any piece of Adobe software immediately.

Since we didn’t think it was fair of VMWare to demand this of us, we used the vmdk2vhd converter (at http://www.softpedia.com/get/System/File-Management/Vmdk2Vhd.shtml ) which was able to convert the VMWare image we needed to a VHD file and used that within Hyper-V. The conversion worked great!

What 1 Fool May Ask Of You

Disable Loopback Note to Self

We always find ourselves looking for this info, so we’re posting it on our own blog for future reference. Here’s an explanation of problems caused if you don’t Disable Loopback on your SharePoint 2013 machines: http://support.microsoft.com/kb/896861?wa=wsignin1.0 (and solutions as well).

Alternatively, you can just run the following PowerShell script:

new-itemproperty HKLM:\System\CurrentControlSet\Control\Lsa -Name “DisableLoopbackCheck” -Value “1” -PropertyType DWORD

JD Edwards and SharePoint

Recently a customer approached us with the following story: they’re upgrading their JD Edwards installation using Syntax’s JDE Upgrade , after they want to integrate it with SharePoint 2010/2013. This kinda leaves us in uncharted territory, but the following links were a helpful starting point:

SharePoint migration and content databases that are too big

In his first job, Nikander started out as a junior internet engineer for the newly founded Internet division of a large Dutch media company (Wegener). The internet division was called WIN (Wegener Internet Nederland) but didn’t exist long (only 2-3 months) because Wegener decided to buy one of the most successful Dutch internet companies of the time: Riverland (later this company was called Netcast, but it also doesn’t exist anymore).

Because of this lucrative take over, the ceo’s of Riverland decided it would be a good idea to move to a different location and expand. The ceo’s even had a better idea: they understood that they could save some money by letting all junior developers move the stuff and let them do the cabling for the building, instead of hiring professionals to do the job. During this period of a couple of weeks, Nikander only saw computers from a distance, but did get his hands on miles of cables and hundreds of cable ties. We stumbled upon this web site, so for old time sake, if you want to be like Nikander and have fun with cable ties, please check out cable ties and hundreds of cable ties.

Once Nikander was allowed access to computers again, one of the first problems he was dealing with was a database not performing well because of its size. Recently, a customer experienced the same thing. They have a single SharePoint content database, used by a single site collection containing many subsites, which is gaining rapidly in size, already surpassing 200 GB. How to deal with this?

First some pieces of relevant knowledge:

  • A site collection can be moved to another content database.
  • A single site collection is connected to a single content database.
  • You can set the content database status to offline to prevent new site collections being connected to such a content database.
  • Offline content databases will still continue to grow in size because of new content in existing site collections.
  • Don’t let the content database stay in offline status for too long (see http://www.sharepointsteve.com/2011/02/side-effect-of-setting-content-databases-to-offline for more info).
  • You can have +/- 300 content databases per SharePoint web application.
  • You can have +/- 2000 site collections per content database, and 250,000 (non personal) site collections in a farm.
  • The recommended maximum site collection size is 100 GB.
  • The recommended maximum content database size is 200 GB.

BTW, if you like some help with checking SharePoint requirements, try the SharePoint Max Dragon (http://gallery.technet.microsoft.com/Maxer-for-SharePoint-2010-8cd0f26f).

In this scenario, the approach of dealing with a large content database goes something like this:

  • Create new content databases.
  • Put the current one in offline status.
  • Promote current sites to site collections via custom code.
  • Divide site content equally among new content databases to share the load and adhere to MS size recommendations.
  • Change old content database status back to normal.

As a rule of thumb, we like to go for content databases of approx. 50 GB in size.

Now, we know not everybody has the possibility to use custom code, and most of the time it’s not even the best approach. Instead, you can use one of the quality sharepoint migration tools out there.

The SharePoint 2013 Machine Translation Service

SharePoint 2013 is an awesome product, but for some features we have to wait and see if they’re mature enough before reaching a verdict (SharePoint Apps will be great eventually, but are they in this release?), but there is one feature that just fails to enthuse us: the Machine Translation Service.

We’ve heard a presenter say on SPC 2012 that it’s all about translating words into foreign words, and okay, you might loose some context, but the foreign reader will at least be able to understand it. We’re pretty sure that this presenter only speaks a single language, because this is not what translation is all about. More than being able to translate the words, it’s about being able to capture the context of the original text. Did you ever run a real text thru a translator service? This could be a party game in its own right, because the garbage you get is incredible typically resulting in the most incomprehensible texts imaginable.

We remember doing a job for Intel Europe and they had a team of dedicated translators ready because normal translators weren’t able to translate technical content into something readable, the total opposite of a machine translator but that worked.

Is there anybody out there gaining real benefit from this machine translation service? We’d love to know!