limitting user resources? 1

[Spidy6123]

Hey guys,
I'm having trouble searching for this particular topic.. basically I'm interested in limitting or adjusting resource consumption such as cpu or memory for particular users..

Does anyone know where this is done in sql 2005?

Cheers

 

[JayKusch]

The feature you are looking for is called the Resource Governor.

unfortunately, this is a feature of the upcomming SQL Server 2008 and is not available in 2005.

You are not able to differentiate different units of work in SQL 2005 thus you are unable to manage specific allocations of memory and CPU based on a process and/or user.

Thanks

J. Kusch

 

[Spidy6123]

really..
Is there anything you can do governing a database other than your standard max disk space? Maybe I can isolate these users to a database..

 

[JayKusch]

even at the DB level you are not going to be able to manage how much CPU or Memory each DB can be allocated.

The only way would be to create another instance of SQL Server and allocate the resources between the instances.

A bit over kill imho.

Have a great weekend!

Thanks

J. Kusch

 

[Spidy6123]

hrmmm.. so there's really nothing that I can do on the single instance?

Basically I have a group of users on one database that I don't want tying up resources for my team. Is there maybe a method of controlling priorities? Such as, perform my query before the other users?

 

[JayKusch]

Sorry again ... but no.



Thanks

J. Kusch