1 DB 1instance vs 1 DB multiple instances --- Wh
Guys here is the scenario
we have 30 different clients.currently running one db and one instance(medium configuration).getting better big configuration.
is it better to create 5 clients per instance.
we have tons of data in each table in the range of 5-10 million rows .I say my database as OLTP tooo...
So wchih one is th ebest option and why do you all think so....
is
1 DB 1instance for all clients vs 1 DB multiple instance for a group of clients --- Which one you reccomnd
thanks
Re: 1 DB 1instance vs 1 DB multiple instances --- Wh
Quote:
Originally posted by prodadmin So wchih one is th ebest option [/B]
There is only one option which your corp is going for. Why does the corp spend on hardware upgrades if they can manage and impress their clients with existing hardware. That means that you Clientele is not satisfied with current performance OR sooner they will not be satisfied as management see there is gonna be growth in their client base and current hardware may not be enough to support.