I'm looking into a case where all sandboxed solutions runs terrible, not only slow, but they use abnormally a lot of resource points too.
Its not a large farm, 3 server + sql. All running on HyperV.
Server 1: Acts as Front End, 8GB Ram Server 2: Front End, 8GB Ram, HLB with Server 1 Server 3: App, 12GB Ram
SQL: 16GB Ram
Dont remember CPU cores atm, but I think it was 8 cores pr server.
I made a dummy solution for testing in their farm, since I don't have access to their code. I made a simple solution that runs a query to a list 10 times. And after hitting the run button for some time, 25 times maybe the resource points was up in 47 ( I know its based on hardware etc, but it says something). And it looked pretty random how long it took to run. Even had execution errors a couple of times, because it took more than 30secs.
I have the same data and list on a test VM here with the same solution, and it is on a shitty VM running on my laptop with 4GB ram. Loaded much faster, and hardly used resource points, less than 1point.
So, anyone know what could cause sandboxed solutions to behave like this?