Thanks Gaz, I've been through the documentation, a couple of times, this is the first real implementation, were planning on using the App_name in order to seperate the different projects as all connection strings should pass that to the database.

We're running SQL Server Build 10.0.5500 on a 32 core (hyper-t to 64) with 256GB of ram.

One thing I have noticed is that even though I set up a MAX_DOP=2 in the Workload Group set up, when the query runs it the server seems to override this and use more of the processors.

Yet when I reset the MAX_DOP=1 it runs as expected on a single processor,is this a known issue with the resource guvernor or have i missed something simple?