Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    1. Home
    2. Rob Fitzpatrick
    • Profile
    • Following 4
    • Followers 0
    • Topics 32
    • Posts 97
    • Best 7
    • Groups 0

    Rob Fitzpatrick

    @Rob Fitzpatrick

    Geek.

    9
    Reputation
    1152
    Profile views
    97
    Posts
    0
    Followers
    4
    Following
    Joined Last Online
    Email rf@wss.com Location Toronto

    Rob Fitzpatrick Unfollow Follow

    Best posts made by Rob Fitzpatrick

    • PT3.3s: cosmetic bug in motd.cfg
      "~Setup an alert to notify..." 
      

      You're missing the "n" after "~".

      Q: Is there a limit to how minor a bug I will report?
      A: There is not.

      posted in ~~Bugs~~
      Rob Fitzpatrick
      Rob Fitzpatrick
    • Posting limit

      Forum posting error:

      Error
      
      As a new user, you can only post once every 120 second(s) until you have earned 3 reputation - please wait before posting again
      

      This is mildly annoying... 🙄
      Do you suppose you can "rep" me?

      posted in Chit Chat
      Rob Fitzpatrick
      Rob Fitzpatrick
    • Tip: full-screen session on Windows

      Are you trying to run ProTop in a maximized proenv session?
      Does it keep resizing on you to 160 x 48, no matter what you do with the Layout tab in proenv Properties?
      Have you pulled out most of your hair?

      Me too! 🙂

      Here's the tip:

      • Edit <protop>\bin\protop.bat and <protop>\bin\protopenv.bat
      • Comment out this line in each: mode con cols=%COLS% lines=%ROWS%
      • Sweep up your hair.

      Happy monitoring!

      posted in Using ProTop
      Rob Fitzpatrick
      Rob Fitzpatrick
    • RE: "Endless" loop after DB shutdown

      Holy crap where has ^\ been all my life??? 😱

      Just when I think I'm starting to learn this platform...

      posted in ~~Bugs~~
      Rob Fitzpatrick
      Rob Fitzpatrick
    • New releases/prereleases

      Thanks @jdpjamesp for the heads-up about 3.3sx.

      Would it be possible to have an announcement here when new versions show up on the download server?

      BTW, lots of great new stuff in 3.3sx, judging from the release notes. 👍 Looking forward to using it.

      posted in Roadmap
      Rob Fitzpatrick
      Rob Fitzpatrick
    • RE: Happy pi day - pt3.14 has been released!

      If you find a bug, will there be a .159 patch? 😛

      posted in Announcements
      Rob Fitzpatrick
      Rob Fitzpatrick
    • RE: Ignore 'irrelevant' alerts

      @jdpjamesp
      (Somewhat off-topic): That KB list is pretty close to a list of my own that I've been updating off and on over the years. I stopped updating mine when, thankfully, I got rid of my last WG license.

      However to me this looks questionable, re licensing requirements for TDE:

      OpenEdge Enterprise RDBMS and OpenEdge TDE or alternatively Advanced Enterprise Edition RDBMS available since OpenEdge 11.5 (for Production)
      OpenEdge Development Server (for Application deployment)
      

      I don't see what OE Dev Server has to do with TDE. It is the development version of App Server, is it not? Same goes for the footnotes for MT and TP.

      Also, aren't -napinc and -napstep decommissioned?

      posted in Roadmap
      Rob Fitzpatrick
      Rob Fitzpatrick

    Latest posts made by Rob Fitzpatrick

    • RE: Installation Instructions

      @tom said in Installation Instructions:

      Would be a better error message?

      Sure

      posted in Downloading and Installing ProTop
      Rob Fitzpatrick
      Rob Fitzpatrick
    • Web portal | General Info | Connections

      I'm looking at the numbers from a client site and they don't make sense to me. At a given time stamp today, I see the following user connection counts:
      4GL: 412
      batch: 30
      remote: 383
      self-service: 0

      I know this client has self-service users. I believe that most if not all of those 30 batch users are also self-service. Looking at historical data, most of the time this database shows zero self-service users, with occasional spikes of 1.

      What criteria are used to determine that a client is self-service?

      posted in ~~Bugs~~
      Rob Fitzpatrick
      Rob Fitzpatrick
    • RE: Dashboard change?

      @tom Sorry... off to the coffee machine...

      posted in Using ProTop
      Rob Fitzpatrick
      Rob Fitzpatrick
    • Dashboard change?

      It seems the dashboard layout changed recently.

      I am looking at "Main Dashboard" for a monitored database. I have the following panes:

      • Latest Status (13 panels)
      • a new unlabelled one that says "CPU: Unknown • Memory: Unknown • OS: Unknown"
      • General info (3 panels)
      • Database I/O (3 panels)
      • Transactions & Locks (3 panels)
      • Record activity (3 panels)
      • Network metrics (3 panels)
      • Async Writers Statistics (3 panels)

      There used to be panes for BI and AI info. Have they been relocated? Will they be returning?

      posted in Using ProTop
      Rob Fitzpatrick
      Rob Fitzpatrick
    • RE: SQL Servers are double-counted in 3.141x

      @tom said in SQL Servers are double-counted in 3.141x:

      That's kind of dumb. Who the heck coded that?

      case statements are hard. 😛

      posted in ~~Bugs~~
      Rob Fitzpatrick
      Rob Fitzpatrick
    • SQL Servers are double-counted in 3.141x

      dc/dashboard.p:

      case  _Connect-type:
      ...
        when "sqsv"  then tt_Dashboard.con_sqlServ = tt_Dashboard.con_sqlServ + 1.
      ...
      end.   //case
      if _Connect-type begins "SQSV" then tt_Dashboard.con_SQLServ = tt_Dashboard.con_SQLServ + 1.
      

      This may also be in previous versions; I haven't checked.

      posted in ~~Bugs~~
      Rob Fitzpatrick
      Rob Fitzpatrick
    • RE: Alert re lkHWM near lkTableSize

      @tom said in Alert re lkHWM near lkTableSize:

      Regarding the specific alert: there is a lkTblPct field which I use for a similar purpose. Rather than the HWM it reflects the locks in use at that moment. In some ways that is better -- the HWM sticks around until you restart and if something went bump in the night is going to keep alerting once you hit the threshold.

      Good to know, thanks.

      posted in Using ProTop
      Rob Fitzpatrick
      Rob Fitzpatrick
    • Alert re lkHWM near lkTableSize

      Maybe this belongs in "Roadmap" rather than "Using", but anyway...

      Looking at alert.cfg:

      #
      # Metric Type Compare Target Sensitivity Notify Message              Action
      # ====== ==== ======= ====== =========== ====== ==================== =======================
      # LogRd   num       > 100000         3:5 Always "Hit Ratio &1 &2 &3" alert-message,alert-log
      #
      # Metric        The ui-det name of the field being monitored.
      #
      # Type          Data type -- char or num (string or numeric).
      #
      # Compare       Operator  -- >, <, =, <>, <=, >=
      #
      # Target        The threshold value of the metric to be tested.
      

      Since it isn't stated explicitly, does "Target" have to be a constant? Could it be another metric of the same data type as "Metric"? Or an expression on constants or metrics (e.g. lkHWM * 0.8)?

      Use case: let's say I want to configure an alert to fire when the lock HWM is getting close to -L, and have it work regardless of the value of -L, which could possibly vary over time or from one DB to another. Is that possible? Or do I just need to decide which number (say, 7000) I care about and configure it to alert when lkHWM > 7000?

      Food for thought: the alerting mechanism would become more powerful if the target values could be dynamic in some way. Maybe passed to the back end via the API.

      posted in Using ProTop
      Rob Fitzpatrick
      Rob Fitzpatrick
    • RE: Web portal Alerts Feed

      Cool, thanks.

      Do you similarly flag tables where table reads are very high compared with the reads of their indexes? The calculations would be more involved but it might be useful.

      posted in Using ProTop
      Rob Fitzpatrick
      Rob Fitzpatrick
    • RE: Report inactive indexes

      For reference, the non-essential audit indexes (which are often purposely deactivated, except in audit archive DBs):

      _aud-audit-data._AppContext-Id
      _aud-audit-data._Connection-id
      _aud-audit-data._Event-context
      _aud-audit-data._Event-group
      _aud-audit-data._EventId
      _aud-audit-data._Userid
      _aud-audit-data-value._Field-name

      posted in Roadmap
      Rob Fitzpatrick
      Rob Fitzpatrick