There is still something missing for me as a practising DBA. Imagine I face hundreds of servers and I have to see all of them from a particular perspective. You’ll say – “easy, any monitoring tool today has it” and you will be mostly right. Imagine I want to monitor things that make sense to me and to me alone. You’ll say, again – “easy, most of the monitoring tools today have this capability” and almost certainly you will be quite right again. Now, imagine I want to be able to investigate events retrospectively by inspecting every single metric MDA has to offer me in case I miss the fun of being there where things happen? You’ll say – “well, bro, some of the monitoring tools can show you some of the waits and stats back historically, but usually you’ll have to rely on your own MDA collections” and you will be quite right again.

                                                     ……And what judgment Would step from this to this? Sense sure you have, Else could you not have motion. But sure that sense Is apoplexed…                                                                   I am of late have been involved in a lot of tuning activity around replication server.  Lots of things to tune.  Lots of hidden moving parts.  Complex creature (although […]

Now that SAP ASE comes with it own brand-new Always-On option it is worth having a closer look at it. Below is a peep-view at Sybase HADR Option. HADR has three basic components:  ASE, RS and Fault Manager.  I skip the Fault Manager for the moment (although it reduces all of self-management to nil) and […]

I have been in this situation numerous times:  a customer has to upgrade its ASE server.  Decision makers sit down to negotiate possible upgrade paths. Downtime is measured for each.  Risks are carefully calculated.  The best upgrade path turns out to be using replication server for upgrade.  Zero downtime.  Perfect downgrade path.  Risk low.  Everyone […]

Well, [SAP] Sybase has always been well known (and coveted) for its replication technology.  Sybase Replication Server is a well established, rock-solidly stable product allowing homo- or heterogeneous replication solutions or different types and topologies across most platforms.  But as opposed to other DBMS vendors (say Microsoft?) the solution was always kept separate from ASE […]

For those considering to move up the ladders from their current ASE release (whether it is ASE 12.5.x or ASE 15.x) there are, obviously, two possible migration alternatives:  ASE 15.7 & ASE 16.   To make the decision more tricky, SAP has stamped both with the same supportability badge:  both have the same EOL dates somewhere […]

Finally the tickets are in my pocket and I may start arranging the suitcase… Hope to see you all at ISUG 2015 conference to take place in Atlanta! See the details here:   ISUG-TECH : ISUG-TECH Conference, 2015 : Content Landing Page For all those interested in ASE (and other ex-Sybase) technology this the place to […]