SharePoint Test Data Load Tool
Q: Do you have any tools to load data into SharePoint Server 2007 or WSS 3.0, including documents, sites, etc?
A: We have just published the SharePoint Test Data Load Tool (WSSDW.exe).
The Tool WSSDW.exe is on Codeplex and is a community supported tool, not an officially Microsoft released product. It can be downloaded here. Please don't contact product support with any issues you may experience using the tool. This is the tool referred to on TechNet as the tool that was used to for load testing by the SharePoint Performance test team at Microsoft.
From Codeplex workspace:
"The SharePoint test data population tool (WSSDW.exe) is a capacity planning and performance testing tool that populates data for testing SharePoint deployments. The SharePoint test data population tool is available as a command-line executable program that extracts information about how to populate the server from an XML configuration file, and calls Microsoft .NET assembly: WSSDWLib.dll. "
Q: What tools did you use to do the performance testing?
A: We used Visual Studio Team System for Test.
For additional SharePoint performance and capacity planning information, see Plan for performance and capacity.
For additional Excel Services performance and capacity planning information, see Determine resource requirements to support Excel Services.