MS SQL DB Resource Management

[eldiablopotato]

Here's the problem. Someone's code is crippling a Microsoft SQL 2008 Standard server. The memory is maxed out, pagefile maxed, and to be honest I'm new to RDBMS administration. How can you figure out what queries & user are causing this? I looked at the resource reports through the Microsoft SQL management studio, but it didn't show a single 'thing' causing all of this trouble (like I expected).

 

[ejjpi]

you can trace queries with the sql profiler and then find the most expensive ones.