Re: ER and HA environment questions

mpruet wrote: > > I'd like to start a separate thread on this issue. > > Based on the feature request thread, there were some folks requesting > better functionality of ER in an HA solution. I'd like some feedback > on that. > > 1) Why is ER being used for HA instead of HDR? > > 2) What specific functionality is being requested on ER? > > I realize that quite a few folks prefer usage of ER over HDR because > the secondary server can be more than a read-only server, a sub-set of > the main server, or on a different platform. However, HDR will always > be much easier to set up and ER does not support a synchronous mode of > replication. > > But I would like to get a bit of feedback on this topic so I can > better understand why ER is being used and what the perceived pain > points are with HDR. > > Thanks > M.P. We 'd like to ask for better alarming when ER cant cope with the workload anymore. Also we think that there should be an easy onstat command to see how full mem queues are and if you are already spooling out to disk etc. In short: I'd like to see a onperf tool for ER diagnosis and monitoring much like the onperf query tool does it for scans & joins dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe