The following blog post will discuss access methods in data sources and what happens when you run a load test on multiple agents. 

http://blogs.msdn.com/slumley/pages/description-of-access-methods-in-data-sources.aspx