March 24, 2014 at 2:25 am
Hi everybody, in sql server 2008 is possible to set priority for single database ?
i want to give more priority (for performance) to "database1" then "database2"
is possible ?
March 24, 2014 at 2:30 am
Not directly.
You can configure Resource Governor and create pools and resource groups and set limits, but it's far from perfect.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 24, 2014 at 5:24 am
ok thanks.
Do you have a small example for create resource group ? can i add database to this reource group ?
March 24, 2014 at 5:50 am
It's not something that has 'small' examples. Spend some time reading up on resource governor (Books Online has a fair bit, there's a whitepaper iirc as well), test out in a dev environment, make sure you understand what it does and what it doesn't do before you consider implementing in production. Implementing it is not a 5 minute job.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 24, 2014 at 6:07 am
In addtion to Gila, if set up incorrectly it may lead to performance issue on the server too.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2014 at 6:43 am
ok thank's to everybody. I'll read some documentation about that, but i suppose that's not a good way to solve.
"Implementing it is not a 5 minute job." i know 🙂
thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply