July 27, 2007 at 1:43 pm
We have 1 big developer box used for both Datawarehouse and regular dev. When the Datawarehouse guys get going, they really dirve up disk utilzaiton causing the other developers to complain about sluggishness. (and they are right!) Does sql 2005 have a "governor" or other way to restrict the datawarehosue process so it and other process can fruitly use the sevrer at the same time?
TIA,
barkingdog
July 29, 2007 at 2:32 am
It does, but the governor is enabled either a server level or per connection. All the governor will do is prevent very expensive queries from been run, depending on the value of the cost limit.
Look up "query governor" in books online for more info.
Btw, while it won't help you, SQL 2008 (Katmai) has what you are asking for.
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
July 30, 2007 at 6:27 am
why don't you add some disks and split the DW database to a seperate array?
Query governor is more trouble than it's worth. Better to train your developers.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
July 30, 2007 at 7:05 pm
>>> why don't you add some disks and split the DW database to a seperate array?
That's exactly what I did as query governor didn't offer me what I wanted.
Barkingdog
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply