Can anyone shed some light on how the licensing is going to work for Table Partitioning? It would be really useful for our system, but costs could be prohibitive.
I believe it will be licensed in the same way as TDE and OE Replication: as an add-on to an existing Enterprise DB license. I don't know how much per user/CPU/agent/...
Thanks Paul. If that's the case then I doubt we will ever implement it. :(
I hear you. That's going to be the case for a lot of companies. But really that means that you don't need it right? It's like heated seats in your car: nice to have in Atlanta when the temperature dips to a frosty 45F but really worth the extra $$ in Montreal and Minneapolis.
Well... there's a difference between needing something from a technical perspective, and needing something from a business perspective. We're probably right on the cusp of the justification (300+GB database). Loads of legacy data that we can't archive off, and loads of tables with natural split points too. It would make a huge difference to performance. But in terms of bums on seats' time saved it's not going to be enough IMO.
Still - much bigger fish to fry in terms of our performance gains at the moment. And the small subject of High Availability. I wonder if there's a workshop any time soon?! ;)
There is a HA workshop in less than a month at the EMEA PUG Challenge in Dusseldorf. Or if you have enough interest in your local PUG, we can figure something out with respect to expenses and have me come out to give it locally in your area.
Where are you geographically?
The ";)" was an attempt at sarcasm... I'm already signed up for the HA Workshop in Düsseldorf. :) Very much looking forward to it.
I'm still on my first coffee after listening to my twin 2-year old boys cry from 00:30 to 4:00. The sarcasm did not register.
:-) <--- That's a smiley. It means "I decided to have kids and I love them even if they keep me up all night"
Architect of the SmartComponent Library and WinKit
I'm with you there! Thankfully my kids are slightly older (3 and 5) and the sleepless nights are less frequent! That, and it's nearly 3pm here so plenty of coffee consumed.
I can confirm that TP is licensed as a DB add-on. Costs are reasonable; comparable to other add-on products. I heard rumblings about the bundle that Tom mentioned but haven't seen anything firm yet. There will be a new price list in December so perhaps we'll see something then.
@Mike: yeah I was surprised. You told me you were going to make a special slot at 7:00 for me. Gilles saved me from that didn't he?
@Mike: do they have proper beer in Dusseldorf? Or will I have to go out for that?