Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
 Posted - 2011-02-14 : 02:45:00
|
| I have one simple question Can we do databasewise CPU / memory allocation in SQL 2008 R2 Enterprise edition |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-02-14 : 03:26:29
|
| Well...the Resource Governor manage SQL Server workload and system resource consumption. You can also limit the number of CPUs and the amount of memory that's available to the SQL Server, but not to an individual database. Read about Resource Governor here:-> http://msdn.microsoft.com/en-us/library/bb933866.aspx- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
Can we do databasewise CPU / memory allocation