Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    1. Home
    2. NickW
    3. Topics
    N
    • Profile
    • Following 0
    • Followers 0
    • Topics 4
    • Posts 8
    • Best 0
    • Groups 0

    Topics created by NickW

    • 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?