You bet, thanks for making this article.  It was really helpful getting me started.

It appears the wildcard syntax you're using is deprecated.

This seems to work now:
@results = EXTRACT postcode string, oacode string, total int, percentage int, filename string...

Thank you, I will take a look at that today. I just got access to sharepoint.

I do think that's the issue (spns) however the sql server for sure has spn's, and the ssrs server too.

It's the service account that sharepoint/ssrs is using that...

My apologies.

On a datasource in sharepoint/ssrs, I get the error, Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' for one server, but it works great on a different server.

The spn's appear...

Indeed, we will be going over the vm config in depth shortly.

If it looks like a duck.....

Since I posted this, I had the systems guy move them onto the same physical host and the TPM shot up to 75k.

It's for sure...

SQL Server version is 12.0.4449.0 (2014 sp1 cu6)

The asynchronous run:

Here is a summary of waits after tpcc database build and followed by a 10 minute performance run.

I restarted...

Thank you for realizing I'm not a spam bot. Not sure what's up with that guy.

I am hoping it isn't right because the drop in performance is so massive.

I have...

Thanks everyone for the brain storming session. I really appreciate it.

Thanks Jeff, Yeah we are aware of the cache hit ratio issue. We have some REALLY bad dynamic sql queries coming out of the application that cause this. ...

Let's see if I can get everyone's responses covered.

John, great advice, I'll look closely at that, there are a few tables that are extremely large, I'll see if I can...

Ok I probably should have specified that, index rebuilds are off hours.

As for restoring db's good point, i'll verify that isn't happening. Our users have a process that can...

Thanks Grant, I saw that too. I poked around on my msdn account and it appears the two are separate download and installs now. So I downloaded the...

I just made it much simpler. I stripped off all connections except the destination, and renamed it generically to 'destination' then instructed the ops to modify it in the ui....