Navigation

    • Register
    • Login
    • Search
    • [[global:header.categories]]
    • [[global:header.recent]]
    • [[global:header.tags]]
    • [[global:header.popular]]
    • [[global:header.users]]
    • [[global:header.groups]]
    • [[global:header.search]]
    1. Home
    2. Recent
    Log in to post
    • All categories
    • Announcements
    • Downloading and Installing ProTop
    • Using ProTop
    •      killprosession
    • ~~Bugs~~
    • Roadmap
    • Chit Chat
    • All Topics
    • New Topics
    • Watched Topics
    • Unreplied Topics
    • tom

      ProTop Newsletter
      Announcements • • tom

      1
      0
      Votes
      1
      Posts
      121
      Views

      No one has replied

    • Wim van der Ham

      Size of AI file to large for integer
      ~~Bugs~~ • • Wim van der Ham

      8
      0
      Votes
      8
      Posts
      727
      Views

      paul

      $PROTOP/etc/NOTES_*.

    • tom

      ProTop 3.1415 has escaped!
      Announcements • • tom

      1
      0
      Votes
      1
      Posts
      856
      Views

      No one has replied

    • tom

      ProTop 3.1415 release candidate!
      Announcements • • tom

      2
      0
      Votes
      2
      Posts
      692
      Views

      tom

      tick, tick, tick...

      The time for pre-release feedback is drawing to a close!

    • paul

      Installation Instructions
      Downloading and Installing ProTop • • paul

      4
      0
      Votes
      4
      Posts
      3754
      Views

      Rob Fitzpatrick

      @tom said in Installation Instructions:

      Would be a better error message?

      Sure

    • Rob Fitzpatrick

      Web portal | General Info | Connections
      ~~Bugs~~ • • Rob Fitzpatrick

      2
      0
      Votes
      2
      Posts
      840
      Views

      tom

      if ( not _Connect-device matches "*batch*" ) and _connect-batch <> "yes" then tt_Dashboard.con_self = tt_Dashboard.con_self + 1.

      So "self" is counted for non-batch self-service connections. It (mostly) equates to local interactive connections.

      Somehow I suspect that you are going to suggest that that might be sub-optimal 😉

    • tom

      ProTop 3.141 is in the wild!
      Announcements • • tom

      1
      0
      Votes
      1
      Posts
      796
      Views

      No one has replied

    • Rob Fitzpatrick

      Dashboard change?
      Using ProTop • • Rob Fitzpatrick

      4
      0
      Votes
      4
      Posts
      7791
      Views

      Rob Fitzpatrick

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

    • Rob Fitzpatrick

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

      4
      0
      Votes
      4
      Posts
      1418
      Views

      tom

      Looks like it dates back to pt3.3n.

      It is fixed now.

    • Rob Fitzpatrick

      Alert re lkHWM near lkTableSize
      Using ProTop • • Rob Fitzpatrick

      3
      0
      Votes
      3
      Posts
      1055
      Views

      Rob Fitzpatrick

      @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.

    • Rob Fitzpatrick

      Web portal Alerts Feed
      Using ProTop • • Rob Fitzpatrick

      4
      0
      Votes
      4
      Posts
      1449
      Views

      tom

      Nope. You're right -- that's a bit more difficult to calculate and it seems much less likely.

      But I'll add it to the "think about it" list 🎣

    • Rob Fitzpatrick

      Web dashboard info cut off
      ~~Bugs~~ • • Rob Fitzpatrick

      2
      0
      Votes
      2
      Posts
      1864
      Views

      tom

      Portal v4 has a lot of enhancements to stuff like this. Real Soon Now.

    • Rob Fitzpatrick

      Report inactive indexes
      Roadmap • • Rob Fitzpatrick

      4
      0
      Votes
      4
      Posts
      1918
      Views

      tom

      Which reminds me of another needed alert "not having audit archive db" 😉

    • K

      Critical Resources
      ~~Bugs~~ • • kandavel879

      2
      0
      Votes
      2
      Posts
      865
      Views

      tom

      I think I probably need more visuals. I'm not forming a picture in my head of what you are describing.

    • Rob Fitzpatrick

      User "batch" displayed as "local"
      Using ProTop • • Rob Fitzpatrick

      5
      0
      Votes
      5
      Posts
      1354
      Views

      tom

      Should be fixed in pt3.141x. I decided to simply use the first part of the device name unless the device name is "batch" and only if the name is otherwise blank. If that fails then use the usr#.

    • K

      No data in Table and Index Stats page
      ~~Bugs~~ • • kandavel879

      2
      0
      Votes
      2
      Posts
      905
      Views

      tom

      This is almost always for one of these reasons:

      The -tablerangesize or -indexrangesize parameters are not set to cover the active tables & indexes. The ChUI "T" command will show you what values are recommended and create a sample .pf file for you in the ProTop temp directory. Unfortunately you cannot change these values online. A db restart will be needed.

      The activity on the tables and indexes does not meet the threshold criteria. You can review the thresholds on the portal "Resource" screen. For development and test environments you probably want very low values. For Production you want higher values -- a chart with 2,000 objects on it will be unusable (that is why we have a minimum activity threshold).

      You should also verify that etc/pt3agent*.cfg has the TableActivity and IndexActivity data collectors enabled. If they are missing from ptInitDC then that data is not being sent to the portal.

    • tom

      Release 3.141 is drawing nigh!
      Roadmap • • tom

      3
      0
      Votes
      3
      Posts
      898
      Views

      tom

      That didn't take long!

      Thanks for the tip, I'll look into it 👀

    • Rob Fitzpatrick

      OE 12 support
      Using ProTop • • Rob Fitzpatrick

      5
      0
      Votes
      5
      Posts
      1614
      Views

      Rob Fitzpatrick

      @tom said in OE 12 support:

      Lastly, I also (sneakily) patched the pt3.14 release a week or so ago. If your "as of" date on that is in May rather than March then you should also have the oe12 changes (but not the "4" hotkey).

      That explains it, I got the error from the original March version.

    • Rob Fitzpatrick

      Configure the User Information Viewer
      Using ProTop • • Rob Fitzpatrick

      3
      0
      Votes
      3
      Posts
      1150
      Views

      Rob Fitzpatrick

      @tom said in Configure the User Information Viewer:

      I'm thinking that the statement cache should automatically appear or disappear based on whether or not it is enabled for a particular client.

      That's reasonable. Though I'd still like to be able to turn the individual browses on or off. 😉

      It would also be nice to have the act of turning off User Information Viewer revert to a view that is more useful, as opposed to just removing the header section. E.g. if the act of going into it cached the current list of displays (e.g. d, t, i, u), so they could be restored when u is pressed again. Food for thought.

    • tom

      Happy pi day - pt3.14 has been released!
      Announcements • • tom

      8
      0
      Votes
      8
      Posts
      2512
      Views

      tom

      Trust me, I had that idea long before Rob mentioned it 😉