Author Archives: andrewmeph
For all those who downloaded and started to use this tool please note: I have released an update that optimizes quite a few things in the tool. The top limit of the number of servers displayed in the monitoring screen has been raised to 100. Added the possibility to display only the last sample in […]
Yet another TechED is behind us. Besides the fun of getting reconnected… Besides ambitious meetings fraught with expectations… Besides funny labels and stickers to pass to your colleagues as memento… What actually is there for us ASE professionals in this 20-years celebratory event? On the one hand there is this: it is always a […]
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 […]