Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    1. Home
    2. Recent
    Log in to post
    • All categories
    • All Topics
    • New Topics
    • Watched Topics
    • Unreplied Topics
    • paul

      Simplified Downloads for Windows and Linux
      Downloading and Installing ProTop • • paul

      1
      0
      Votes
      1
      Posts
      1781
      Views

      No one has replied

    • paul

      ProTop 319
      Announcements • • paul

      1
      0
      Votes
      1
      Posts
      1842
      Views

      No one has replied

    • N

      Online backups and buffer hit rate
      Chit Chat • • NickW

      3
      0
      Votes
      3
      Posts
      3030
      Views

      tom

      As Paul says every block with data in it must be read - even for an incremental backup. Which is why an incremental backup takes about as long to run as a full backup.

      -Bp 10 helps to prevent the entire -B buffer pool getting flushed as a result of a backup running and the follow-on impact that that will have to the hit ratio. During the backup itself though you will still almost certainly see a poor hit ratio.

    • N

      Telegraf on Windows
      Using ProTop • • NickW

      4
      0
      Votes
      4
      Posts
      3127
      Views

      N

      @mlb3820 Thanks Mark. That's fixed it.

    • N

      User experience LH metric
      Using ProTop • • NickW

      5
      0
      Votes
      5
      Posts
      718
      Views

      paul

      @nickw still getting the dbanalys msg too? Or just the "cannot find drive" msg?

      Can you email to me log\dbmonitor.log and tmp\dbmonitor.debug and err please?

    • tom

      ProTop Newsletter
      Announcements • • tom

      1
      0
      Votes
      1
      Posts
      609
      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
      3669
      Views

      paul

      $PROTOP/etc/NOTES_*.

    • tom

      ProTop 3.1415 has escaped!
      Announcements • • tom

      1
      0
      Votes
      1
      Posts
      1615
      Views

      No one has replied

    • tom

      ProTop 3.1415 release candidate!
      Announcements • • tom

      2
      0
      Votes
      2
      Posts
      1189
      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
      4730
      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
      1341
      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
      1157
      Views

      No one has replied

    • Rob Fitzpatrick

      Dashboard change?
      Using ProTop • • Rob Fitzpatrick

      4
      0
      Votes
      4
      Posts
      8488
      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
      2024
      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
      1616
      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
      2077
      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
      2445
      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
      4540
      Views

      tom

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

    • K

      Critical Resources
      ~~Bugs~~ • • kandavel879

      2
      0
      Votes
      2
      Posts
      1252
      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
      2032
      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#.