cpu quota / resource management

Hello *,

Is there a way to restrict resource consumption by user or connection?

If I execute some long running reports my complete server slowes down. I'd like to assign this reports only limited resources.

Thanks,

Michael

You can configure database mirroring for the target database in your production SQL instance and create snapshot on the mirror server (your backup SQL instnace) on different machine. The principle system can be considered as your normal OLTP business system and the mirror server can be used to support your reporting system. Since the reporting system will be run on differet SQL Server instance on different machine, it will not hurt your normal business onthe principle server. HTH|||Really your easy options are limited to setting query govenor which is time based not resource based.|||Thanks for the hint, "SET QUERY_GOVERNOR_COST_LIMIT" is useful in this context. Additional question:-
Is there a way to cancel running querries? For instance by issuing a "cancel" call from a seperate thread?

Thanks,
Michael