Is there a possibility that i can limit a user's cpu/memory usage so that if this user (the database) generates a report, this process won't hang up the whole sql server ?
thanks in advance
edgar
Well ...
Maybe the time to optimize you report query has come?
Considering the question, answer is no.
|||Not exactly. You can prevent a query from running by setting Query governor cost limit, but this will stop all queries with a cost above the specified threshold from running at all.
There is no way to say allow this query to run, but limit it to use x% of y resources.
