Try CROSS APPLY

SELECT t.*

FROM dbo.EMP AS e

CROSS APPLY dbo.testfn(e.Employeeid) AS t;

Change it, then keep an eye on your processor to see if you're still seeing bottlenecks there. Monitor processor queue length and the wait states to see if those numbers...

When you're returning 1/7 of the table, just scanning it makes more sense for the optimizer. I suspect that's the primary issue, but without details, we're still stabbing in the...

If you're not seeing it, I'd put money down that he's accessing an old backup or has a second set of commands that's stripping out the users. Nothing else makes...

Probably just has to do with the structure and access mechanisms. Assuming no changes to the execution plan, no changes to the distribution of the data, no changes to the...

Have you taken a look at the Resource Governor?

Start at Microsoft. That's always the best spot.

I wouldn't sweat the Max Degree of parallelism nearly as much as I would the cost threshold for parallelism. The default value there is 5, which is EXTREMELY low, especially...

Take a look at the execution plan for the query. see what it's doing. It could be you're building lots of temporary storage processes (hash tables, sorts, work tables, etc.)....

I agree with everyone else. Resource Governor is going to get you close-ish, to what you're looking for, but it's not going to do specifically what you need. And, it's...

I'm not aware of anything like this in 2012. To my knowledge the best you could do is use the resource governor to try to limit the one you don't...

Also check out SQL Cop. I wrote a review of it here[/url].

And the query stats are aggregate only. If the query was called multiple times and only one of them spiked, you won't be able to tell much about the spike.

4gb of memory is really not enough to run that many VMs.

You have two options. 1) Make the VMs part of your existing network. You can add them to your...

Data changes can lead to statistics changes which can cause a recompile. If you have a nightly load or something like that you'll see recompiles. Also, plans can simply age...