February 2, 2011 at 9:10 pm
Say i have a db serving a web application. There are 2 kinds of users: modify data and read data; the first one is more important. To deal with workload, we think about to replicate the db, so that modify data users access 1 db and read data users access another OR using resource governor, divide the resource for the two kinds of users.
In our case, which one is better?
Thanks
February 2, 2011 at 10:35 pm
thecoding (2/2/2011)
In our case, which one is better?
It depends. If the two type of users are competing with CPU or memory resource, resource governance will help. If they are more on competing with IO resource, resource governance can't help at all (to date). If resource governance can be of help here, it also depends on the current performance matrix, your performance expectation, your budget etc to be able to decide which one is better.
February 3, 2011 at 9:14 pm
Also another big 'if' on this is how much latency you can live with, can you wait 5 seconds for something changed on the writer db to make it to the reader db.
Also keep in mind resource governor is not perfect, it does not govern everything going on with the server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply