Monthly Archives: May 2012

This one is a killer: Sybase ASE Load Generator, Sybase ASE Execution Statistics Analyzer, Sybase ASE Code Player &c…

Remember the teaser I published a couple of weeks ago?    I have been finally able  to compile a reasonable “beta” version of the tool.  This one is really fun (not that the earlier tools were NOT fun, but this one is just that – FUN).  I have been using a much more simple version […]

Never write the same query twice – just run it…

Ok.  This one will definitely not get the best software award.  It is rather stupid.  But it works. I don’t know which tools most of you are using, but during my professional experience as DBA I have found myself often writing the same query… twice.  Yes, I do have my queries organized, categorized, stored somewhere […]

Location for the Sybase Monitoring Tools Has Moved…

I know, this is a bit annoying, but when I realized that 4share site asks you to register in order to download files I’ve got a bit pissed off.  I did not read any warning that this will happen to those using the service (may have misread this actually).  But whether I was prompted and […]

Blog Update: ASE Tools repository + A Teaser…

First of all I would like to thank you for the interest you have shown in the tools I shared so far.   I did imagine that sharing some of the tools I have created to make MY professional life easier with colleagues will generate interest.  I did not realize how strong that interest will be. In […]

Sybase Simple Real-Time Monitoring: Seeing things as they unfold…

OK.    Is there anyone out there working with Sybase ASE who does NOT know at least two, three…. ten tools providing the real-time monitoring for Sybase ASE?  Surveillance?  Quest?  Precise?  Nimford?  Hyperic?  Ignite?  Bmc?  &c…  There are quite a few.  I did not work with all of them.  SCC offers some monitoring capabilities as […]

SYBASE MDA TABLES: 83 monTables, 1312 monTableColumns, and still counting…

Well, Sybase MDA Tables have been around for quite some time.  First released in 12.5.0.3 (2003 it was?) with 35 “proxy” tables (as they were called then), they started to acquire more and more depth and precision.  Closing almost a decade by now (ASE 15.7) they have grown to 83 monitoring tables, spanning 1312 columns […]

Sybase Sysmon: What the hell do I do with all these counters!

As someone administering Sybase Dataservers for more than a decade, Sybase System Monitoring Report has always been something very useful, but oh, so very tiresome as well!  On the one hand, it holds a lot of valuable information (all those waits, contentions, throughput identifiers).  On the other – whenever there was a need to look […]