Help on limiting resources

Help on limiting resources

 

  

Hi guys:
Is there a way in a given SQL 2005 instance to limit the services
resources per DB?.
I have a DW and and OLTP DB coexisting in the same server. When the ETL
that feeds the DW runs the OLTP users get annoyed with Timeouts and big
latencies.
Any ideas would be appreciated
Mario


MS Sql Server LazyDBA home page